Hello everyone,
I’m still quite new at AppSheet and having some difficulty with a BOT which is strange as it works for step 1 but not for the subsequent step.
I have an action to update another table. That action works fine when manually triggered so I’ve ruled out the action being the problem here.
I then set up a BOT to “Run a Data Action” namely the Action to update another table. No matter what I try the bot is not updating the other table. I’ve tried setting the BOT up as a standalone BOT. That didn’t work. I also tried attaching it as step two to another BOT that is working (at least in relation to step 1) and that didn’t work. In this instance, I have the Action within the BOT to “Add new rows”. Any ideas you have would be greatly appreciated.
It’s hard to give clean advice when we haven’t seen what you have already created. But I’ll try…
First things first…have you confirmed that the Bot is actually getting triggered? You can verify this by tapping the “Monitor” button at the top-right hand of the Bot. This takes you to the Bot Monitor Logs - you may need to select the specific app then select “Runs” view at the bottom. Search for your Bot listed as a run Bot.
If it’s not listed then the Bot is not getting triggered. You need to double-check the Event section and criteria that triggers the Bot.
If all that checks out and the Bot is getting triggered, then you need to look at the action.
One thing that jumps out at me is that you mention a single action but also state you are attempting to UPDATE a row in another table. A data action Bot runs with a particular row in context. to update a row in another table, there needs to be a “transition” from the current row context to in context the row in that other table. This requires 2 actions - 1) a “bridge” action 2) the update action
The “bridge” action is simply the “data: execute an action on a set of rows” type action and can be for 1 or more rows. In this action you insert an expression to select the row(s) from the other table to be updated, that table as the source and then insert the update action. This bridge action will send your identified rows, one by one, to the update action.
Lastly, if your update is simple and doesn’t rely on any other data for the changes, then you are all set. In many cases, the update is dependent on a change made in a row in another table. For this the INPUT() function needs to be used to pass the needed data from which the correct update can be derived.
This all very high level explanation…please ask questions if needed.
I hope this helps!
1 Like
Thank you so much for your help. I appreciate you.
This was a huge help and has helped me get to a solution.
As a person who is new to AppSheet, I am so thankful you are willing to help.
Have a wonderful day. 
1 Like