I am working on an Inventory App.
Under the Behavior category I have created two actions, one to simply add a quantity to inventory on hand via formulas on the Inventory sheet, and another action to register this addition via LINKTOFORM() formula which simply registers this transaction to another sheet. It works perfectly but I would like to simplify this process to make the user just press one action. Currently the user has to press the “add stock” button and then “register the transaction” button to complete the task. Is there a way to simplify this two actions into one? I tried adding an additional LINKTOFORM() formlula of the second action but it does not work.
It would be convenient if one could chain multiple actions by specifying on the same Action creation task.