I would love to have a feature that would search a given table by a field or set of fields to find and surface duplicate rows. It would then be great to be able to take a pre-defined action on duplicated rows such as delete, or merge. Dealing with dupes is always a pain with large data sets or importing new data into a set where some records may already exist. A way to deal with dupes in a somewhat automated way would be really helpful.
It is hard to believe as many tables are formed bringing in dirty data and needing to remove or manage dupes. Gives me second thoughts as migrating into a system like this requires these types of tools.
This isn’t currently possible directly in Airtable but you could use Zapier to Find duplicates - you would probably have to use a formula to look for records excluding the record you are comparing. You could then get Zapier to change one of the values, send a message to warn you or whatever you want.
Note you would need a paid Zapier account for this because it uses a multi step zap (Trigger, Find, Update).
However, there is no way to prevent entry of a duplicate in the first place at the moment.
I would also need this feature since I am dealing with large sets of data. I am using airtable to organize a database of business people, so obviously having duplicated records for e-mail addresses and name of companies is quite an issue for me.
