Script to identify duplicates in a CRM and merge fields

[Data_things]

Hi all,

I have a CRM in Airtable and looking to automate merging contact records if the email address matches. This would include merging multi-select and linked fields. I know there’s the dedupe app, but I’m looking to automate this so the dataset is always up to date. Can anyone point me in the right direction with how to do this via a script please?

Thanks in advance!

[Vivid-Squid]

I have not tried it, but there is a dedupe script in the Community Showcase that you can try on automations.

Airtable

Example Script Showcase - Airtable Universe

There are tons of ways to use the scripting app, so the Airtable team has collected some of our favorite examples, both internally and from the community, to...