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