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.
Same here. We track jobs by job name and sometimes people will refer to a job by slightly different names. When we realize the jobs are the same I would like to combine the records.
I need to be able to make sure a value in a table is unique. Its used to handle ID tags, and we need an easy way to detect if a tag already has been assigned to someone, without having to do a search every time.
+1 for auto detect dups! Major weakness of the platform and tons of ppl looking! and without a COUNTIF function all the workarounds are too much for a simple ask.
Some more context on my use caseโฆ
I am using Airtable to manage an events calendar which my organization (~100 people) uses too see what events others are going to, speaking at etc. Iโm also encouraging everyone to contribute to the events calendar by filling out a form.
Iโm looking for a mechanism that will stop people from recording the same event twice, and for a way to add or edit existing events on the calendar.
