How to make a record unique?

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • In Progress
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.
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Chris


  • 4,430 Points 4k badge 2x thumb

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


  • 362 Points 250 badge 2x thumb
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