Ok so I’m trying to build an inventory management app that I can use for work to make it so I submit my inventory on time. So I have my whole app built and it works great but the hard part is getting that data out of the app sheet. They are using google forms to collect that inventory data at work. So I want to, on every Monday submit my inventory. So I think the best course of action is to use a Webhook; http post request, so I have that all working I now just need to submit that post request on a schedule. So I go into the bots and make a schedule biased bot to do just this and I test it and it send great but I cant seem to figure out how to reference variables in a scheduled bot. If the bot is triggered from data change I can totally add vars into my webhook like this: <<[Column name]>> but when I do that on a scheduled bot app sheets gets mad. Also I have my data (the whole post request) in a stagnate cell is there a way to reference a stagnant cell in a table to send that out on my webhook?
Data-change bots run in the context of a single record. Thus you can pull the values from that record’s columns.
Scheduled bots do not run in the context of any record. You would need to use some form of SELECT to pull values from specific records, or use a START expression to go into the context of a single record.
https://help.appsheet.com/en/articles/2357314-select
https://help.appsheet.com/en/articles/2357309-lookup
https://help.appsheet.com/en/articles/961746-template-start-expressions
What is a “stagnate cell”?
So for me the solution was to use this formula: SELECT(On hand submit[output],([qualifier] = True)) but i needed to wrap it in << >> to get it to evaluate. The stagnate cell i was referring to was a cell reference that doesn’t change so for example On hand submit!B3 so I just used the above statement to reference that same cell each time.
Thank you!