Hi guys, I really need help with setting up the search formula for my specific case. We have an attendees email column in Airtable, which each cell will includes multi emails, e.g. email1, email2, email3.
In the zap, I need to search certain email in this column, and find the right row, then read the other related info from the same row.
I used the FIND("{{94825201__hidden_email}}",{AttendeeEmails}) in the search formula in Zap, which works, but it doesn’t apply to find the exact same email, e.g larose@test.com (let’s say email A), and rose@test.com (let’s say email B), when searching B, the system will find A.
Then I changed the formula to FIND(", {{94825201__hidden_email}}",{AttendeeEmails}), added ", " into, which can help to find e.g “, A”, but this doesn’t apply to the first email address, since there’s no ", " before it.
Does anyone have any idea about this will be very appreciated!
Another small question, does anyone have the idea to find the multi records/rows at the same time? (If the email address exists in multi rows)
Thanks,
Jeff
