Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

When sending an email via automation checkbox shows as true or false but I want the checked/unchecked emoji

Topic Labels: Automations
Solved
Jump to Solution
1490 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kev_Sherratt-Pe
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

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

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

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

See Solution in Thread

2 Replies 2
Vivid-Squid
11 - Venus
11 - Venus

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

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

IF(Checkbox = 1, '✅', '⬜')
Kev_Sherratt-Pe
5 - Automation Enthusiast
5 - Automation Enthusiast

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: