Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 04, 2021 03:18 PM
Hi! I’m fairly new to Airtable, and I have a question about the automations.
I’m building a form with a multiple-select field. I want to send the user an email IF they select two choices or more. As far as I can see, this isn’t a valid trigger in the automations window.
Help is appreciated!
Jan 04, 2021 06:10 PM
Welcome to the Airtable Community!
You are correct that there isn’t a specific trigger for when a multi-select field has two or more choices selected. However, you can build up to this situation.
COUNT
functions don’t work on multi-select fields, so you have to use a workaround by counting the commas in the field value.IF(
multi,
LEN(multi) - LEN(SUBSTITUTE(multi, ",", "")) + 1,
0
)
Here are a couple of cautions: