How can I avoiding same input in same column

Hi,
How can I avoid the same value in the same column? I have a list to add items to. No element should have the same name. How can I output an error message if the value has already been taken?

Thanks
Jean

  • Create a User Specific Column to temporarily store the user input
  • Create a relation between this column and the target column
  • If the relation is not empty, the user input will create a duplicate

Hi Darren,
ah cool, thanks for the rapid and helpful answer.
Thanx
Jean

No problem, feel free to ask if you need any help getting it working.