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.
No duplicate detection, no unique value, low basic features, show stopper
+21Welcome 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.