Duplicat Record

[Attila_Nagy]

Hello!

I want to list duplicat records within a table in a view so we can check them.
I found this, this would be good for us, but I don’t realy know how to make it work in the automation:

Automation: Check Submission for Duplicates before Publishing Automations

I’m trying to ingest a new user registration (password’s being handled separately). I want to make sure that the new registration does not use an email address already in the DB (prevent duplicate accounts–ideally even if they’re using “+variable” in something like a gmail address). I’m currently using automations, but I can’t seem to get around the “Find Records Action 0 results stops the automation” flow. I actually want to update the record AFTER a Find Records determines there aren’t any d…

I did some automation, so it’s not new to me, but maybe not as complex like this.

Best regards
Attila

[Alexey_Gusev]

Hi,

you can use simple no-code/no-automation way
create some _temp table (you can remove 3 empty records and 3 fields besides name).

• Add link field directed to your table.
  return to your table, copy whole column, paste it into new appeared link field.
  return to _temp table - you will see a table of all unique values with links. add count field, all >1 is a duplicate
  

add this count field in your table as lookup

[Attila_Nagy]

Hello Alexey!

Thank you for your tip.
You might be right, but I don’t understand to to a 100%.
If I share my demo AirTable with you, could you make it there work?
This way I would have a “spare” tabel, right!? Not sure I want to see such a table all the time…

Would an anotmation be much more complex?

[Alexey_Gusev]

Hi,

Yes, I can show, it’s a simple task.
As soon as you add ‘count’ field to your ‘main’ field (as a lookup), you can convert it to number (or text). Thus, you “unlink” it from parent table (_temp) and can delete _temp.

I would recommend you to try, it’s useful Airtable practice.
Using automation to solve ‘static’ task - find duplicates - it’s a wrong tool choice, Also, I doubt you can easily do that, because single automation step can only update single record, additional workaround needs to update more

[Attila_Nagy]

Hello Alexey!
Ok, I tried and I might get your idea, but this works only if I copy some row from my table into the new column, right!?
If I want this “notification” of duplicate record also at new records, do I have to input data also into the new column?

Best regards
Attila

[Alexey_Gusev]

Hi,
Yes, my solution is for ‘static’ goal - find duplicates.
If you need to dynamically check new record for duplicates and do something if yes, it’s very easy now, after Airtable added conditional automation steps.

I hope that can help

[melissaprinz]

Looking for advice budgeting for seniors? Get expert tips on managing money, planning for retirement, and maintaining financial stability with our comprehensive guide.