Forum Discussion

RajeevShukla's avatar
RajeevShukla
Qrew Member
6 years ago

Primary Key creation

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
------------------------------
Formulas and functions
Tables and fields

2 Replies

Sort By
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    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
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    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
    ------------------------------