
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 29, 2016 10:39 AM
Hi there! I’m just curious how I enforce unique values in a column or a group of columns – that is, how to enforce a unique constraint. So that I don’t, for example, accidentally enter the same person (combination First Name + Last Name) twice.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 23, 2022 07:58 AM
What suited my case:
I created a column simple select with a value “NOK” with the color red
I created an automation:
- trigger:
- whatever you like
- action:
- find records (creates a list of records that passes a condition)
- conditional action
- if list_records > 1 → set simple select of curent record as NOK
And then every time i create a new record if it already exists, i see it with that with the flag NOK and i can decide to remove the new record or fuse the new and the old one

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 12, 2022 02:03 AM
Thanks @Alexandre_42. I am trying to do the same. But htere issomething that I do’nt get: ¿What is the condition to cretae a list with the same value in a column? Thank’s

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 12, 2022 02:45 AM
@Alexandre_42 I finnally get it done. Your advice were very usefull for me. Many thank’s
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 26, 2024 03:42 AM - edited Jan 26, 2024 03:43 AM
Adding a voice to get this added as a native feature in the product - i just want a way of setting "this text column needs to have uniqe data in it"
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 14, 2024 04:59 PM
Any updates on this? I don't think I need to say how important this is.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 23, 2024 04:11 AM
I have the same problem with my item master data. I don't want to use the same SKU twice and therefore it would help to set a column to "unique values" so you are not even able to add if it´s already used.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 21, 2024 05:19 AM
Could you help me with getting the condition part setup to create a list? I have tried a few different ways, but either it always fills in the 'NOK' field or never does. No matter what I type in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 15, 2024 07:35 AM
I also would like to voice support for the wish that AirTable adds a new attribute for each field for which the user can select whether or not the value of that field should be unique.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 05, 2025 02:20 PM
Enabling a 'Ensure values are unique' to a field would be HUGE for the community. Please do this Airtable!

- « Previous
-
- 1
- 2
- Next »