
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 07:49 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 09:37 AM
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, '✅', '⬜')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 16, 2022 09:37 AM
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, '✅', '⬜')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 17, 2022 08:49 AM
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 :slightly_smiling_face:
