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
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…
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
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?
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.