Unique values in a column

[Graham_Charles]

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.

[Alexandre_42]

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

[Alvaro_Hernande]

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

[Alvaro_Hernande]

@Alexandre_42 I finnally get it done. Your advice were very usefull for me. Many thank’s

[agbush]

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"

[cameron_tangata]

Any updates on this? I don't think I need to say how important this is.

[MarcoLaRosa]

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. 

[djforema]

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.

[Sal_Ams]

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.