Hello!
I would like to know if there is a formula to identify duplicates?
I have a database with codes for each product. When a new product is entered into the database, I would like to be informed if the code assigned to it already exists.
Thank you for your help.
Welcome to the community, @Pierre_Boccon-Gibod!
Formulas can’t check for duplicate records, because formulas can only see their own row or linked rows.
You might be able to automate something with a JavaScript (I’m not sure about this), but Airtable’s only built-in way to search for duplicates is the dedupe block, and it’s a manual process. You’ll need to run it whenever you want to check for duplicates.
Welcome to the Airtable community!
It is technically possible to detect duplicates with a combination of formulas/rollups. I wrote about it in this thread. At the time I wrote the solution, it required a single manual step (linking the record to the “control”), and that step can now be automated with the new Automations feature. However, this method isn’t practical in real life. It doesn’t scale and it is very resource intensive, and it only flags duplicates.
There are other better methods of detecting duplicates, as ScottWorld mentioned.
A closer look at your workflows, base design, and your subscription level (free, plus, pro) would help to determine what method to take.
Are you entering new products one at a time rather infrequently? If so, adding a step to search for the product first might be the easiest solution.
Are you doing a bulk import via copy/paste where the product codes can appear multiple times in multiple rows, and you just want to know about the new codes? Maybe you should move the product codes to a linked table with the product code as the primary field in the linked table. When you do the paste, the Airtable will create a new row in the linked table only if it doesn’t exist yet.
There are many other possible scenarios, each with a different solution.
By the way, if you have budget for a JavaScript solution, I have written many scripting solutions for clients.
Thank you for your response.
I currently have a pro subscription to Airtable.
I enter new products several times a month, so I was hoping to be able to automate the search for duplicates.
When I enter a new product in my database I fill in a form, so I don’t see which codes are already applied to the others…
I have to go back to the data table and create a dashboard…
It seems long and requires a lot of steps…
If you’re using a form, then I would recommend this tool: