Help

Output checkbox as text

Topic Labels: Data
Solved
Jump to Solution
117 3
cancel
Showing results for 
Search instead for 
Did you mean: 
user2100
5 - Automation Enthusiast
5 - Automation Enthusiast

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".

1 Solution

Accepted Solutions

Hello,

You can try something like this (my example is made with 3 checkbox fields, it will work the same with 15)

Pascal_Gallais_0-1726561886182.png

Formula for field "Mail content" is:

Pascal_Gallais_1-1726561929401.png

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":

Pascal_Gallais_2-1726562090936.pngPascal_Gallais_3-1726562118666.png

Regards,

Pascal

 

See Solution in Thread

3 Replies 3

Hello,

You can add a formula field for each check box:

Pascal_Gallais_0-1726557843195.png

Formula associated with the "Licence" checkbox field being:

Pascal_Gallais_1-1726557900802.png

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)

Pascal_Gallais_0-1726561886182.png

Formula for field "Mail content" is:

Pascal_Gallais_1-1726561929401.png

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":

Pascal_Gallais_2-1726562090936.pngPascal_Gallais_3-1726562118666.png

Regards,

Pascal