I have about 15 checkboxes in a form, I would like to output only the clicked checkboxes as text in email.
Example:
Check box “You need a driver’s license”
If this is choppy, I would like to have the "title" as text in the email so that the customer knows what things they need.
So far it only gives me "True".
Best answer by Pascal_Gallais-
Hello,
You can try something like this (my example is made with 3 checkbox fields, it will work the same with 15)
Formula for field "Mail content" is:
Note that you may have the impression that line breaks are not applied when you look at the result, it is just the way Airtable displays the result in the view. If you click on the "blue arrow" in the top right corner of a cell, it will expand it and display the "true result":
Regards,
Pascal
Hello,
You can add a formula field for each check box:
Formula associated with the "Licence" checkbox field being:
Regards,
Pascal
Hello,
You can add a formula field for each check box:
Formula associated with the "Licence" checkbox field being:
Regards,
Pascal
This works quite well so far, but with 15 checkboxes the table becomes very large. I tried combining several checkbox titles into one formula. Is it possible to set a new line for each value so that I have 5 values one below the other?
Hello,
You can try something like this (my example is made with 3 checkbox fields, it will work the same with 15)
Formula for field "Mail content" is:
Note that you may have the impression that line breaks are not applied when you look at the result, it is just the way Airtable displays the result in the view. If you click on the "blue arrow" in the top right corner of a cell, it will expand it and display the "true result":
Regards,
Pascal
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
