Is there a way to filter the email from a Submited form to only show data based on input

Taun Brown asked on April 17, 2014 08:03

I have an online form with a bunch of check boxes on it and I want to know if there is a way with the form editor for the email notification to have it filter data to only show where the value is 'true'

So with the auto generated email sending data like this:

Full Name Mr.Test Email testing@amo.on.ca All Advocacy Issues True Agriculture False Culture & Heritage False

I am hoping there is a way to have the email only show the 'True' values so it would look like this:

Full Name Mr.Test Email testing@amo.on.ca All Advocacy Issues True

Or even if there way a way to color code the field would work too

Thanks again in advance for everyone's assistance

Correct Answer

Jan Vlasák answered on April 28, 2014 04:47

You are putting 'True' in the macro instead of 'value', so {% if(Advocacy) { "$$label:Advocacy$$: $$value:Advocacy$$" } |(identity)GlobalAdministrator%}

should be enough :)

0 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on April 17, 2014 08:28

Look here for the automatically used alternative forms. Simply put, you can create an alternative form with the code name "filter" and create a filter with less than 5 minutes of work.

0 votesVote for this answer Mark as a Correct answer

Taun Brown answered on April 17, 2014 08:43

Brenden thank you for your answer but that doesn't seem to allow me to do what I am after as the email notification layout is what I am trying to filter that is sent. and I don't see a way to use the alt.form for that.

0 votesVote for this answer Mark as a Correct answer

Jan Vlasák answered on April 20, 2014 03:02 (last edited on December 10, 2019 02:30)

Hi Taun, you might want to try the following macro in your custom layout: {% if(boolean_field) { "$$label:boolean_field$$: $$value:boolean_field$$" } |(identity)GlobalAdministrator%}

It should work in both Autoresponder and E-mail notification tabs.

0 votesVote for this answer Mark as a Correct answer

Taun Brown answered on April 22, 2014 09:15 (last edited on December 10, 2019 02:30)

Jan thank you for answering,

I added the code {% if(Advocacy) { "$$label:Advocacy$$: $$True:Advocacy$$" } |(identity)GlobalAdministrator%} but all I get is the label but not the value maybe you or someone else can tell me what I am missing?

0 votesVote for this answer Mark as a Correct answer