How to make a record unique?

  • 0
  • 1
  • Question
  • Updated 4 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 4 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 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".

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
You can not enforce Unique when the formula contains Summary fields or Lookup fields
(Edited)
Photo of ARYEH ZELCZER

ARYEH ZELCZER

  • 342 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