Forum Discussion
QuickBaseCoachD
11 years agoQrew Captain
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.
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.