Qrew LegendWhat 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,
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
Qrew Legendbelieve me, I'm not a programmer. But the Quickbase staffers call a data entry field a scalar field meaning a field that you just type in to as opposed to being a formula field or look up field.
Also a Pipeline step to run a saved table to table import is just a Make Request Quickbase Channel step like this
| Pipeline API_RunImport Import Example; The URL is just | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| https://mycompany.quickbase.com/db/xxxxxxxx?a=API_RunImport&id=11 Method = POST nothing else is required |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
Thanks for the clarification and example.
