Help

Re: Primary Field

994 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Howard_Cohen
5 - Automation Enthusiast
5 - Automation Enthusiast

I could not find an answer to this - is a [text] primary field case sensitive?

3 Replies 3

Are you asking within the context of linked fields?  If so, yeap, they are

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).

> (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

Screenshot 2023-03-03 at 7.05.59 PM.png

Apologies if I've misunderstood your questions!