Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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.
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:
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
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
Nov 12, 2022 02:45 AM
@Alexandre_42 I finnally get it done. Your advice were very usefull for me. Many thank’s
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"
Feb 14, 2024 04:59 PM
Any updates on this? I don't think I need to say how important this is.
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.
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.