Help

Primary Field Allowing Non-Unique Entries

Topic Labels: Formulas
486 1
cancel
Showing results for 
Search instead for 
Did you mean: 
lmm7186
4 - Data Explorer
4 - Data Explorer

Hello, I'm working on a new database and one of my tables includes various types of barcoding equipment.  Each record should have its own unique Serial Number, so I made Serial Number my Primary Field for that table.  I thought that, by default, the Primary Field always required unique values but I've just tried entering a duplicate S/N and it allowed the entry.

 

How can I make sure my Primary Field doesn't allow for the same value to be entered more than once?

1 Reply 1

It is recommended but not required. Airtable has no special built-in check constraint, but you can create automation for that. To perform 'soft-tracking', you can change summary type to 'Unique'. If the number of unique value less than number of records, then you have duplicates.