Forum Discussion
AnkitPruthi1
Qrew Member
Do I need to create a new filed (Formula Url) to do this?
------------------------------
Ankit Pruthi
------------------------------
------------------------------
Ankit Pruthi
------------------------------
LauraThacker
5 years agoQrew 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__You5 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
------------------------------ - AnkitPruthi15 years agoQrew MemberHi Laura,
Thanks for the suggestion. Quick Question? When you mean push the calculated value into the key field, you mean automation right?
I am uploading data, which run's in thousands, Automation is limited to 1000 rows max, so in such a scenario pushing via automations will not be possible right?
Appreciate your help!
Regards
------------------------------
Ankit Pruthi
------------------------------- MarkShnier__You5 years agoQrew LegendNo, we were assuming this was manual data entry in Forms and you would using firm rules. If you are uploading then Pre calculate the key field before uploading.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------