Forum Discussion

VivekVishwanat3's avatar
VivekVishwanat3
Qrew Cadet
7 years ago

How to make a record unique?

Hi,
I have a table with few columns in it. I want to make a record unique.
can we achieve a unique row? (However I tried to combine all the field values in a new Formula row and made that formula row unique).
But, here I have a summary Field from Child table to parent table, and I need that summary Field also should be validated in making the record unique.
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain

    You can set field values to be unique as a property of the field.
     Under properties, the Basic section, check "Must be unique".

  • You can not enforce Unique when the formula contains Summary fields or Lookup fields
  • You can make it the record id (if you want to do that - it can break current relationships) use the API to set record id