Have you checked out the DeDupe extension? It can't be automated, but you can manually run it whenever you need to clean up duplicates.

Thanks Scott. Yes I saw that. Unfortunately I can't use that as a workaround as it's too manual and those duplicate records would have created new records via the Zap on another platform. I'm waiting for our ATS provider to fix their api, but it won't be a priority. 

I tried to do an automation: when a record matches conditions, find records, then update duplicate records my check box for duplicate field. But I couldn't make "find records" find duplicates of the original. 

Yeah, I don't know of any way to do it with Zapier... I only know how to do it with Make, which would let you delete all but one of the found records. That's because the search will always return ALL of the records... so you have to tell it to skip over one of the records. Make can do this, but Zapier can't.

Also, if you know JavaScript or can find someone who knows Javascript, this can likely be automated with a Javascript. 

Thanks Scott. I'll have a look at Make. Perhaps I could Zap records to Airtable from our ATS, and then use a Make for Airtable to Webflow. WIll look into this. 

Hm, what if you had an automation that runs when a record's created in the table, and it'd have a "Find Record" action to find a record with the same name (or however you're identifying duplicates), and if it did find a record that had the same name as the triggering record, it'd check that "Duplicate" checkbox you mentioned?

I like that idea Adam. I tried that the other day using the Job Ad ID as that is a good duplicate identifier. See attached. When I added a record manually to test it, it would check the duplicate checkbox even if it wasn't a duplicate. So I gave up at that point. I was going to use the duplicate checkbox to filter in another view. 

Hmm, your automation doesn't have a conditional logic step, so it's always going to mark the checkbox?

Could you try adding a conditional logic step?

Aren't there two conditional logic steps? If JA Ad ID isn't empty and if JA Ad ID is not JA Ad ID. Any suggestion on how I properly lay the logic out? 

The logic for the steps would be whether the "Find Record" action found anything: if it did, it'd mark the checkbox, and if it didn't it'd do nothing

You've already created an automation with the conditional logic steps that isn't working I take it?  Could you provide screenshots of your new setup?

Thanks. Yes my automation isn't working. It's finding the duplicate records, just not updating them. Screenshots attached. Thanks for your help so far. 

In your latest screenshots, your automation still does not have a conditonal logic step

You need to add a conditional logic step to get your automation to do what you're looking for I'm afraid