Help

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