Forum Discussion
priyankagummulu
Qrew Trainee
Im completely new to quickbase and can you please guide me in creating a primary key with two fields where the two fields are foreign keys
------Original Message------
The form rule method could also work, however a limitation that you could encounter is if you data is being entered via grid edit or import as opposed to using a form.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
MichaelGrosky
5 years agoQrew Trainee
Sure:
1) Add a new field to a table setting the field type to Formula - Text
2) in the formula box in the field settings, select [Field1]&[Field2]
Note that each field should be surrounded by [] and the & is to concatenate the two fields. Your field types will also have to be text for Field1 and Field2. If they are not you can convert them in the formula totext([Field1]&[Field2])
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
1) Add a new field to a table setting the field type to Formula - Text
2) in the formula box in the field settings, select [Field1]&[Field2]
Note that each field should be surrounded by [] and the & is to concatenate the two fields. Your field types will also have to be text for Field1 and Field2. If they are not you can convert them in the formula totext([Field1]&[Field2])
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
- MarkShnier__You5 years agoQrew ChampionPriyanka,
It looks to me form your screen shot that one of your fields is a lookup fields, and you are trying to use that in a formula field being marked as Unique. A lookup field may not be used that way, because if the value on the lookup field changed at its source, then there would be no way for QuickBase to enforce Uniqueness.
you would be able to use the field [Related Item] though in a formula to be Unique.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------ - priyankagummulu5 years agoQrew Traineei want the field to be unique but if im trying the way you suggested me its accepting duplicate values as well.
------------------------------
priyanka gummuluri
------------------------------ - MichaelGrosky5 years agoQrew Trainee
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - priyankagummulu5 years agoQrew TraineeIts showing an error . If i try it.
------Original Message------
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - MichaelGrosky5 years agoQrew TraineeCan you share your formula and the properties of the fields that you are using in the formula?
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - priyankagummulu5 years agoQrew Trainee
------------------------------
priyanka gummuluri
------------------------------ - MichaelGrosky5 years agoQrew TraineeWill your Order ID always be unique? If so, mark that field unique as well and then try marking the formula unique as well.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - priyankagummulu5 years agoQrew TraineeI have marked orderid as unique and tried but still showing the same error message "This formula is incompatible...."
------Original Message------
Will your Order ID always be unique? If so, mark that field unique as well and then try marking the formula unique as well.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - priyankagummulu5 years agoQrew TraineeThank You . Thanks a lot it worked
------------------------------
priyanka gummuluri
------------------------------