Field Request: Unique

It would be great to have field which can be unique (not auto numbering). That would ensure no new entry with same details is added. For each row first thing that needs to be placed can be unique field itself.

1 Like

Yep, this would be a much-welcomed feature that most (if not all) other database programs already have. You may want to email support@airtable.com to request this feature.

In the meantime, the only way to prevent someone from entering a non-unique value at the time of adding a new record would be to write your own custom JavaScript using the scripting app (and then do all of your data entry for new records over there), or use this form from MiniExtensions when creating new records:

You could also use a variety of methods to tag duplicate records AFTER they have already been added into your system. For example, Airtable’s Automations now lets you search fields by values, so you could search for a specified value and mark the found records as duplicates. Or you could use Airtable’s DeDupe app to manually cleanup duplicates after the fact.