Hello there!
Is there a method to have a view trigger an action affecting a different table?
To be more clear I will elaborate on what I am trying to accomplish. I am trying to copy the function of the demo Inventory Management App created by AppSheet. However, unlike the demo app, when using the Sell view I wanted the current stock to be appended (have this cell changed) to my actual Google Sheet. The demo app uses a formula in a virtual column to report the available and it is not ever added to the Google Sheet.
I can get all the calculations correct. The portion of this implementation that is not working is that I cannot get my Sell form (which is a different table in the Google Sheet, think of a transaction log) to automatically trigger this update (of appending the new updated value) to the other Inventory table.
Any input would be greatly appreciated. I just discovered AppSheet and am amazed at its potential. I am excited to implement this into my companyโs workflow!
LinkedIn
Twitter
