Forum Discussion

JuanSolorio1's avatar
JuanSolorio1
Qrew Cadet
11 years ago

Can a formula text field be used as the table's key?

I have a formula text field that I want to use as my table's key, however the option is not available to me. Can formula fields not be used as the Key? Note: values in that formula field are and wi...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
11 years ago
No, the Key field must not be a formula.

An alternative is to have your form show the calculated formula and then have a Form Rule that says "when the record is saved, change the value of [my key field] to the value in he field [my key field formula]".

But then you will also probably want a safety net to subscribe to where the Key fields does not equal the formal field.