Skip to main content
Question

How to make a record unique?

  • July 31, 2018
  • 0 replies
  • 55 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
    • Quickbase Alumni
    • 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
    • AryehZelczer6
    • Quickbase Alumni
    • July 31, 2018
    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