Rachel_Braedyn - profile

Rachel_Braedyn · Aug 11, 2022

I have an automation set up that loads Google Calendar meeting info into my database, including attendee email addresses. What I want to do is extract the emails of only the people who are not internal employees. That is to say, extract all emails in...

Rachel_Braedyn · Aug 30, 2022

Thanks so much for the help! It seems to work perfectly except for 1 thing: If the company email address is not the first email in the list of populated emails, it also erases external email addresses before it, leaving a blank result.

Rachel_Braedyn · Aug 29, 2022

Did you find an answer to this? I’m trying to work out the same thing.

Rachel_Braedyn · Aug 23, 2022

Hi Adam, I used your formula and unfortunately got an error message saying “Invalid formula”. I replaced Name for the field/column name I want to reference, “Attendee email list”. Is that correct?

Rachel_Braedyn · Aug 12, 2022

I appreciate the help and it seems to have worked so thank you. However, I realized there’s a. second email domain I also want to filter out. So I want to filter out those ending in “@company.com” and “@group.calendar.com”. Is there any way I could f...

Rachel_Braedyn · Aug 11, 2022

I seem to understand how that pulls data for that particular string but want I want to do is, in a separate column/field, is list the participants whose emails are not from the company domain.

User Statistics

User Activity

Extracting text string that does NOT contain certain text

Re: Extracting text string that does NOT contain certain text

Re: Conditional updating of a single select field in another table (not base)

Re: Extracting text string that does NOT contain certain text

Re: Extracting text string that does NOT contain certain text

Re: Extracting text string that does NOT contain certain text