Forum Discussion

MuhammadGhazali's avatar
MuhammadGhazali
Qrew Trainee
6 years ago

Unique Identifier on Multiple Fields

Hi, Is there a way to set up your Unique Identifier (key) based on multiple field combination? i.e., If I have fields User and Date, I want to restrict to have a specific user on a specific date onl...
Formulas and functions
Tables and fields
AustinK's avatar
AustinK
Qrew Commander
6 years ago
I don't believe this is possible anymore but I'd love to find out a way to do it as well. You used to be able to do it via a formula field and setting it with the API but they made a change somewhat recently that made this impossible to do.
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You can make a formula text field which concatenates the values together and mark that as unique - but they would not be the Key field.

The other option if the data entry is on a form is to calculate that concatentation and have a form rule populate a data entry field with the caluclated value and then set that data entry field to be the Key field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------