Email checkbox items as plain list

[mja850]

Hi Ben,

Thanks for the reply!

(1) Yes, each "category" of checkboxes is one database field
(2) There are about 70 checkboxes, but no more than 17 in a category
(3) I do need to show the categories in the email. I currently have the category name displayed within the if statement in the email.
(4) HTML currently, but plain text would be fine too. Correct, I basically want a list of the checkbox labels with <br> between them. I am literally trying to make a checklist that someone can tick off the items as they go. The goal is to generate a customized cleaning checklist for different cleaning jobs - the client is a cleaning company.
(5) Here is the email template:

<p><strong>Cleaning Checklist</strong></p>

{if $ANSWER_livingroom}
<p><strong>Living Room</strong><br>
{$ANSWER_livingroom}
</p>
{/if}

{if $ANSWER_diningroom}
<p><strong>Dining Room</strong><br>
{$ANSWER_diningroom}
</p>
{/if}

{if $ANSWER_kitchen}
<p><strong>Kitchen</strong><br>
{$ANSWER_kitchen}
</p>
{/if}

{if $ANSWER_familyroom}
<p><strong>Family Room</strong><br>
{$ANSWER_familyroom}
</p>
{/if}

{if $ANSWER_bedroom}
<p><strong>Bedrooms</strong><br>
{if $ANSWER_no_bedrooms}
Number of Bedrooms: {$ANSWER_no_bedrooms}<br>
{/if}
{$ANSWER_bedroom}
</p>
{/if}

{if $ANSWER_halls}
<p><strong>Halls/Stairways</strong><br>
{$ANSWER_halls}
</p>
{/if}

{if $ANSWER_office}
<p><strong>Office/Study</strong><br>
{$ANSWER_office}
</p>
{/if}

{if $ANSWER_bathroom}
<p><strong>Bathrooms</strong><br>
{if $ANSWER_no_bedrooms}
Number of Bathrooms: {$ANSWER_no_bathrooms}<br>
{/if}
{$ANSWER_bathroom}
</p>
{/if}

{if $ANSWER_playroom}
<p><strong>Playroom</strong><br>
{$ANSWER_playroom}
</p>
{/if}

{if $ANSWER_laundry}
<p><strong>Laundry Room</strong><br>
{$ANSWER_laundry}
</p>
{/if}


Thank you so much for your time and help! Form tools is awesome!

Mike

Hi mja,

Thanks for the post!

Just a couple quick questions / clarifiers:
(1) the checkboxes in all the categories are all stored in the same field in the database, correct?
(2) how many checkboxes are there?
(3) in the email, do you need to show the category to which the individual checkbox belongs?
(4) are you sending the email as HTML or text format (or both)? And you just want the list of checkboxes to be one per line, or one after the other on the same line?
(5) could you post your existing email template(s) so I could see what we're working with?

It should be do-able, though!

- Ben