Help

Filtering data inside a field

Topic Labels: Formulas
1241 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Noemie_Fortin-B
4 - Data Explorer
4 - Data Explorer

Hi!

I’m new to airtable. I’m running an automation to create google calendar events. I need to evaluate if the email addresses in a field are in our domain name, and if so add them to a new field. My challenge is that there can be many email addresses in the field, so the text-based formulas won’t work. Is there a way to loop through a multi-select and evaluate each element independently?

Thank you!

Screen Shot 2022-04-19 at 6.35.56 PM

2 Replies 2
Noor
6 - Interface Innovator
6 - Interface Innovator

hI @Noemie_Fortin-Brunet
Welcome to Airtable Community

Unfortunately there is no loop available anywhere other than airtable scripting feature. You can try airtable automation script and check each and every element and push the result to table

Thanks
Noor

Your Client Meeting Attendees list is a multiselect. If you instead add a table with contacts (name, email, phone), then change Client Meeting Attendees to Link from a record (the new Contacts table), you can add a lookup field to that link’s Email Address field with the condition of only including emails that contain your domain.
image