Skip to main content
Question

How to make a record unique?

  • July 31, 2018
  • 0 replies
  • 58 views
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.
    This topic has been closed for replies.

    • ChrisChris
    • Registered
    • July 31, 2018

    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
    Terms & ConditionsAccessibility statement