Combo Primary Key

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
How do I set two fields in a table as a combo primary key, like in Access?  Thanks!
Photo of Shari Moehlenkamp

Shari Moehlenkamp

  • 110 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
In fact, a little known secret is that you can.  Make a formula field to say hyphenate them together and then use the API_SetKeyField.

You can just type the api call into the URL bar. 

Post back if you don't know how to use the API guide and need help.
Photo of Shari Moehlenkamp

Shari Moehlenkamp

  • 110 Points 100 badge 2x thumb
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?
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
Shari,
I have been tied up today and unable to respond. Can you contact me via the information on my website and I will walk you though the Steps. No charge :). QuickBaseCoach.com