Hi,
I thought I could create a simple BOT/Action relationship to modify a column value on a trigger. Not to be. I suspect it is a simple problem.
I have a working Bot that on a change in the table Job Board sets the colour column [colour] to the value "green". I wanted to add a Step in the Bot to then set the [Inv Status] in a ref list [related Xeros] to "invoiced". The Bot above works fine.
Next I added a new steop in the process...
The Referenced action is...
As I said I think the solution is simple but thank you for your help in advance.
John H
Solved! Go to Solution.
Thank you. You could use grouped actions in the bot. Testing showed grouped action executes.
In the example below "Orders" is the parent table and "Order Details" is the child table.
The grouped action
Set value to Green on parent table
Reference action on parent to select child table rows for setting invoice status:
Referenced action on child to set invoice status:
Grouped action included in bot:
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
3 |