Help

No duplicate detection, no unique value, low basic features, show stopper

Topic Labels: Base design
730 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Stephane_Hotte
4 - Data Explorer
4 - Data Explorer

These 2 options should be part of the basic design. And no, the Dedupe block is nice nut is not what is missing here.
Simple basic option in every database.
Please add this.

1 Reply 1

Welcome to the community, @Stephane_Hotte! :grinning_face_with_big_eyes: Airtable is more of a hybrid database/spreadsheet than a pure database. Internally, it does store a unique ID for every record, which you can see using the RECORD_ID() function in a formula field. However, as you’ve noticed, it does not prevent duplicate entries in the primary field. My guess is that they opted for the internal unique ID as the main identifier vs using the actual data entered into the primary field so that they could make the system more user friendly and appeal to a wider audience.