Skip to main content
Question

Key field

  • December 9, 2021
  • 0 replies
  • 103 views
Hello
I remember QB asking if the field I am creating is a key field or not; but I am not able to get back that option. I can go to fields and change the key field.

But I want to concatenate 2 fields and make it a key field. I saw this option too but I am not able to find it again.

Region      Customer   Sales
NA             1001              200
NA             1002             300

Key: Region + Customer

If I upload a file with NA and 1001, I expect QB to not to create a new record or say duplicate but overwrite NA 1001 combination.

Thanks!

------------------------------
Siva
------------------------------
Siva
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Quickbase does not allow a formula field to be a Key field.  If you are uploading you would need to build that concatenated field at the source before importing.  If some entry is by data entry on forms, you can have a formula field to build the concatenated field and then use a form rule to populate the scalar data entry field as the Key field by copying the value of the formula field into the Key field.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement