Forum Discussion
MarkShnier__You
Qrew Legend
2 years agoWhat if you try a pipeline step to copy the value of the formula query into a scalar field. Then use the scalar field in the real Pipeline. The copy could be done by making a bulk upsert and adding the Bulk upsert rows one by one, then commit the Pipeline. maybe that way it only has to calculate the formula queries record by record and it won't time out.
You may be able to copy your existing pipeline and then use the new pipeline designer interface to insert steps before your main pipeline steps.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
AaronB
2 years agoQrew Trainee
Mark,
I am not familiar with 'scalar fields' but will look into that subject and see if I can make it work for this situation.
Thanks for the suggestion....Aaron
------------------------------
Aaron B
ab1692@att.com
------------------------------