How to make a record unique?

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

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Chris

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
(Edited)
Photo of ARYEH ZELCZER

ARYEH ZELCZER

  • 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