Global Variables and pipelines

Question

Is it possible to User Global application variables in Pipelines? if so what is the syntax to use it? I assume it would be some kind of Jinja?

Would I be able to loop and append data to it? then clear it out later in the pipeline?

MarkShnierYou · Answer

Well, nobody ever asked that question before. Surprisingly, to me at least, there are API calls to get and set Application variables Here is some help on that.

https://helpv2.quickbase.com/hc/en-us/articles/4418302337428-API-GetDBVar

An alternative using Application Variables would be a helper table with only one record in it and setting a relationship from that one record to any other table where you need the values looked up. Or you could use a formula query.

Then you could edit that record more "normally" by editing that record.

An advantage of storing values on a regular Quickbase record is they become visible to users and you can have users manually edit who are not administrators.

You use a Make Request step to call the API.

Sign up

Login to the community