QuickBase Scripts
I have top tier QB enterprise access. I need a way to build and run a script within QB and have it systematically run it on a schedule. what I want to do can't be done with the default pipeline bui...
Wel you say this:
Ultimately I don't care were it is or what language it is in. I just want it to be contained within QB and run by QB.
Great, just do an easy simple native Pipeline to run at 7:30 each morning (Pipelines can be scheduled to run daily at a particular time), scan for qualifying records, and then the For Each loop either directly add the records, or else have a step before the Search to create a bulk upsert and add a Bulk Upsert row inside the for each loop, and then outside the loop Commit the Upsert.
"Best Practice", if there will be a lot of records it to build a Bulk upsert as that keeps the processing outside Quickbase as the upsert is very fast in Quickbase, nd only happens once.
