Discussions

Expand all | Collapse all

How to make a record unique?

  • 1.  How to make a record unique?

    Posted 07-31-2018 12:56
    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.


  • 2.  RE: How to make a record unique?

    Silver
    Contributor
    Posted 07-31-2018 12:58

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



  • 3.  RE: How to make a record unique?

    Posted 07-31-2018 14:26
    You can not enforce Unique when the formula contains Summary fields or Lookup fields


  • 4.  RE: How to make a record unique?

    Posted 07-31-2018 14:44
    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