Filtering data inside a field

[Noemie_Fortin-B]

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!

[Noor]

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

[Vivid-Squid]

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.