- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 19, 2020 12:35 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 19, 2020 02:38 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 19, 2020 01:02 PM
How does this new record arrive?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 19, 2020 02:29 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 19, 2020 02:38 PM
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.
