Aug 23, 2021 07:21 AM
We could have more than two records with the same name. But Is it possible to prevent the record with the same name from appearing? I hope it will pop up a window to warn me when a same name record is created.
Aug 23, 2021 08:59 AM
Airtable deals with record uniqueness under the hood using a randomly generated record ID. You can see this ID using the
RECORD_ID() function in a formula field. Aside from that, it doesn’t prevent the creation of records with the same data in the primary field, nor does it provide any mechanisms for alerting the user of such duplications. It’s possible to run an automation on a schedule that executes a script to look for and mark records with duplicate primary field values, but this will obviously eat up a lot of automation runs depending on the schedule chosen.
What method are you using to create the primary field contents? If it’s a formula, the best solution there is to add as much unique data as possible to the formula’s output so that you effectively guarantee unique values, although doing so obviously makes the field contents longer and not as easily consumable at a quick glance.
Aug 23, 2021 04:47 PM
There should have been some way to resolve it. Unique is an important attribute. I am not sure whether filter could resolve such problem.
Aug 23, 2021 06:23 PM
I understand your concerns, so I’ll return to the question that I asked in my previous post: what method are you using to create the primary field contents? Are the fields being filled manually? Via an automation? An external tool like Zapier or Integromat? Something else?
Aug 23, 2021 06:51 PM
I created the primary field contents manually. In fact most of the contents are filled manually…
If there are too many records, I can’t find what whether my new record’s primary field has been filled.
Aug 24, 2021 08:35 AM
In lieu of running an automation on a schedule, you might consider manually running a script periodically to look for and mark records with duplicate primary field content.
Another option is to use the Dedupe app to find duplicates, keeping in mind that it’s also designed to delete and/or merge duplicate records. You could just skip that part and use it for review only.
Aug 24, 2021 08:47 AM
Thanks for your advice.