What are all of the requirements for a field to be set as the Key field?
QuickBase allows some but not all of my fields to be set as the key field, therefore, what are all of the requirements of a key field?
Forum Discussion
Well, the key field of a Parent table may not be a formula. There is no problem to have the Child table's reference field be a formula.
One work around can be to have a form rule which takes the calculated value of what you want the Key field to be and save it in the key field.
The form rule would look like this:
When the record is saved
change the value of the field [My key Field] to the value in the field [calculated concatenated Key field]
One work around can be to have a form rule which takes the calculated value of what you want the Key field to be and save it in the key field.
The form rule would look like this:
When the record is saved
change the value of the field [My key Field] to the value in the field [calculated concatenated Key field]
- I have one Table and was testing this. I have Longitude and Latitude fields. I created Formula-Text field to combine them to be Longitude / Latitude with a slash separating the two values. When I try to put the Form rule in, the Key Field is not visible in the list of fields that pops up.
- Record ID is not visible. I'm trying to create a key field using the values of Long and Lat combined. If key field cannot be a formula, I am thinking I can copy the combined values into a new field. Then make that new field the Key field
