Skip to main content

Unique primary field

  • March 27, 2022
  • 2 replies
  • 97 views

Forum|alt.badge.img+2

How do you make a primary filed unique?

2 replies

Forum|alt.badge.img+16
  • Inspiring
  • 529 replies
  • March 28, 2022

I do not think you can force a unique string anywhere in Airtable. You could set your primary field as a formula and set it to record_ID() which should be unique for your base.


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • March 28, 2022

If you want a unique primary field that is not meaningful, you can use an autonumber field, or a formula field that include the RECORD_ID().

If you want meaningful primary field, Airtable will not enforce uniqueness. You can set the summary value for the field to show the % unique if you want to check for uniqueness.