
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2019 01:11 PM
Is there any way to force uniqueness on the key field? In other words, I want the value in the key field to be unique across all records. So I should not be able to create two records with the same key field value.
Thanks.
–Brad

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2019 01:26 PM
Airtable keeps a unique recordID for every record you create, but this recordID is not exposed by default on the UI. They expose this unique recordID through a formula function:
If you make your key field a formula, and incorporate this function into its output, you’ll end up with automatically generated unique keys for every record you make – however, you will not have any control over the format of that unique key; they are usually 17(?) characters long and a mixture of numbers, upper-case letters, and lower-case letters.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2019 02:00 PM
Hi Jeremy,
Thank you for that explanation. So AirTable provides a unique record_ID, but there’s no inband mechanism for enforcing uniqueness on a user-defined field.
Thanks again.
–Brad

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2019 02:05 PM
That’s correct – no problem

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2019 09:01 PM
The Autonumber field type enforces unique values. Even if you delete a record, Airtable will never reuse the deleted number.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 02, 2020 12:09 PM
I have a table called Contacts with a field:Contact Names. I want to make sure Contact Names in this table has no duplicates. Is there a strategy to do this in Airtable?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 02, 2020 08:35 PM
Welcome to the community, @Dan_Bliss! :grinning_face_with_big_eyes: The first thing that comes to mind is the Dedupe block, which is designed just for this purpose. Because it’s a block, your base will need to be in a Pro plan workspace if you’re past the free trial period.
On a side note, it’s preferable to start a new thread instead of adding to an existing one, especially if the existing one is old (anything where the latest post is older than a few months IMO).
