Skip to main content
Question

Primary Key creation

  • April 6, 2020
  • 0 replies
  • 53 views
Hi Team ,

Can we create Composite Key on Quick base Tables .

Like I have two column  Customer Name & Customer Address  in Customer Table .  I want to use
unique Identifier = Customer Name +Customer Address .

Is it possible to achieve this functionality .


------------------------------
Rajeev Shukla
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Registered
  • April 6, 2020
Sure, create a formula rich text field and enter this as your formula:

[Customer Name] & [Customer Address]

If you want to make it more legible you can add a delimiter such as a pipe or underscore:

[Customer Name] & "|" & [Customer Address]

[Customer Name] & "_" & [Customer Address]

------------------------------
Adam Keever
------------------------------
MarkShnierYou
Forum|alt.badge.img+24
Quick Base does not have the functionality to be able to set a formula field as the Key field.
But you can make a formula field and then use a form rule to fill in the key field on the form.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement