Mar 01, 2023 10:48 AM
I could not find an answer to this - is a [text] primary field case sensitive?
Mar 02, 2023 12:16 AM
Are you asking within the context of linked fields? If so, yeap, they are
Mar 02, 2023 03:37 PM
Thanks for the response. My question was not well formed. What I want to understand is (i) does airtable enforce unique primary fields (i.e. will not allow two records to have the identical primary field), (ii) are two records with identical primary field spelling but different capitalization considered distinct primary fields; hence case sensitive (independent of linked fields).
Mar 03, 2023 03:06 AM
> (i) does airtable enforce unique primary fields (i.e. will not allow two records to have the identical primary field)
Nope, it doesn't enforce unique primary fields and will allow two records to have the identical primary field
> (ii) are two records with identical primary field spelling but different capitalization considered distinct primary fields; hence case sensitive (independent of linked fields).
I think so yeah. Each record has a unique record ID accessible via a formula field with the formula `RECORD_ID()`, and so two records with identical primary field spelling but different capitalization would still be treated differently
Apologies if I've misunderstood your questions!