Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Preventing duplicates from entering a view

Topic Labels: Automations
Solved
Jump to Solution
365 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m capturing leads from a webform in airtable
I can’t keep people from submitting information multiple times (the webform is a drawing for a prize).
How can I create an automation for the original names entering a new view - that will check on email address as a unique identifier, for any other record already in the view with that email address before copying from the grid view/original view to the new “deduped” view?

1 Solution

Accepted Solutions

That would be even easier. Just have Zapier search for duplicates first, before adding the new record into Airtable. Then, you’ll only end up with unique records in Airtable. No additional views necessary.

See Solution in Thread

4 Replies 4

There are many different ways of approaching this, but in your case, I would just have the automation do a search for the email address upon form submission.

If it finds more than one result, then have it mark the new record with a checkbox that represents duplicates.

Then, your “DeDuped” view would be filtered to only show you those records where the checkbox is unchecked.

can you point me to a post on how to do this search and flag automation?

the form is not an airtable form -it’s a webform connected to airtable via zapier

That would be even easier. Just have Zapier search for duplicates first, before adding the new record into Airtable. Then, you’ll only end up with unique records in Airtable. No additional views necessary.