Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Finding Duplicate Instances in Field via Formula

Topic Labels: Formulas
Solved
Jump to Solution
2539 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jen_Rudd
7 - App Architect
7 - App Architect

I would like to flag a new record if it arrives and the email address of the new record matches an email address of a record already in the base.

I have gotten as far as lowercasing the email addresses to ensure the capitalization doesn’t throw it off, but I just want to have a visual flag immediately showing as an output in a field.

We have the pro version, and the dedupe block, but we want to just be able to see quickly if a record exists before wasting time deduping it or outright ignoring the new record.

1 Solution

Accepted Solutions

Yes, you should handle it in Zapier ahead of time, before it makes it into Airtable. If you’re looking for a cheaper option, check out Integromat.

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

How does this new record arrive?

Jen_Rudd
7 - App Architect
7 - App Architect

It comes directly via jotform into AT. I usually scrub it into AT via zapier, but we blow through too many zaps formatting and bringing in uploads to the form. I do have a zap to assign it a status once it hits the table. I think the limitation I was running into in Zapier was that it didn’t find all instances but rather just an instance, which should suffice. Should I just add on another task to filter for other instances and note duplicate task? I thought about using a script in AT since we have pro, but I feel like it takes just as long to open dedupe.

Yes, you should handle it in Zapier ahead of time, before it makes it into Airtable. If you’re looking for a cheaper option, check out Integromat.