Forum Discussion
LauraThacker
Qrew Captain
Ankit, you can use a formula to calculate the key-value; but you must then push the formula value into a standard text field that you set as your Key for your table. If your table already exists; then you must build the new [Key] text field; populate it with unique values before you can make it the Key.
If your key value is a combination of other field selections separated by a delimeter of some kind; such as [xyz]-[abc]-[def], then you need a formula on your Add-form to "calculate" the Key value. Either when all required values are populated or when the record is saved, push the calculated formula value into the [Key] text field to save.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
If your key value is a combination of other field selections separated by a delimeter of some kind; such as [xyz]-[abc]-[def], then you need a formula on your Add-form to "calculate" the Key value. Either when all required values are populated or when the record is saved, push the calculated formula value into the [Key] text field to save.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
MarkShnier__You
5 years agoQrew Legend
... Ankit,
If it was not clear, Laura means to use form rules and set the form rule to fire all the time. De-select the checkbox at the bottom of the form rule screen so that at all times of the formula does not match the Key field to change the Key field to the value in the formula field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
If it was not clear, Laura means to use form rules and set the form rule to fire all the time. De-select the checkbox at the bottom of the form rule screen so that at all times of the formula does not match the Key field to change the Key field to the value in the formula field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------