Enforc unique key values?

#1

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

0 Likes

#2

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.

0 Likes

#3

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

1 Like

#4

That’s correct – no problem

0 Likes

#5

The Autonumber field type enforces unique values. Even if you delete a record, Airtable will never reuse the deleted number.

0 Likes