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
------------------------------
AnkitPruthi1
5 years agoQrew Member
Hi 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
------------------------------
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
------------------------------