Sep 16, 2024 11:46 PM
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".
Solved! Go to Solution.
Sep 17, 2024 01:36 AM
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
Sep 17, 2024 12:26 AM
Hello,
You can add a formula field for each check box:
Formula associated with the "Licence" checkbox field being:
Regards,
Pascal
Sep 17, 2024 12:58 AM
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?
Sep 17, 2024 01:36 AM
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