Forum Discussion
ShariMoehlenkam
Qrew Trainee
thank you! I'm a brand new user to Quick Base, so I'm not familiar with how to make a hyphenate formula or use the API_SetKey Field. Would you mind elaborating?
priyankagummulu
5 years agoQrew Trainee
Please can you tell me how to create a combo primary key
------------------------------
priyanka gummuluri
------------------------------
------------------------------
priyanka gummuluri
------------------------------
- RyanStanford15 years agoQrew CaptainYou would need to create a formula Text field...
in the formula section have something like:
[Field A]&"|"&[Field B]
You might need to add ToText() around the fields if they aren't text already... you then set this new formula field as the primary key of the table.
------------------------------
Ryan Stanford
------------------------------- priyankagummulu5 years agoQrew TraineeIts still not working . I cannot set it as key
------Original Message------
You would need to create a formula Text field...
in the formula section have something like:
[Field A]&"|"&[Field B]
You might need to add ToText() around the fields if they aren't text already... you then set this new formula field as the primary key of the table.
------------------------------
Ryan Stanford
------------------------------- MichaelGrosky5 years agoQrew TraineeThat is because you cannot set a formula field as the primary key. Is the data being imported in a way where you can create the key prior to import? Or alternatively you can set up a copy of the table and run a table to table import where the key field is populated from the formula field in your original table.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------