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

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?

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

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

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

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