Skip to main content

Hi All,


Very new to Airtable and need assistance on an automation if you can help. I have a form that populates a checkbox field. I need to email this field to someone showing the condition as either “Yes” or “No” but the field only shows a “True” or “False”. Is there any way I can do this?


I have tried using a formula field to determine the result and change the it this way but the email shows a blank space where I expect the result to be (when calling the formula field).


Thanks in advance,

Kev

Hi @Kev_Sherratt-Pearson

You can add this formula to display a text checkbox emoji when the option is selected.


IF(Checkbox = 1, '✅')

Then you can put that formula as the result in your email.


If you want to also show an emoji when not checked, try this:


IF(Checkbox = 1, '✅', '⬜️')

Awesome! Thanks Vivid-Squid,

Looks like I was doing it correctly on a previous attempt but the generate preview function doesn’t populate the Emoji.


Thanks for your help 🙂

Reply


Terms & Conditions