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