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
Note that the Action works when triggered manually by clicking the icon on the form.
Could you confirm if the table “Job Board” is parent table of the table “Xero”
If so, does the second action "Set[Inv Status] reference the child table rows of the Xero table that are children of the parent table "Job Board"s same record where the first action changes the [Colour] column?
Hi Suvrutt,
“Job Board” is the parent of “Xero”. If a Job row is deleted in Job Board then the related Xero rows with the ref [Job ID] matchig the Job Board[ID] are also deleted.
Secondly per your question, the second item in the process to set the [Inv Status] to “Invoivced” is a text column in the child “Xero” table. The first item in the process to change the [Colour] to “green” is a colour column in the “Job Board” parent table.
Thank you for the details. Assuming you wish to change the status of children records of the same parent record where the first bot changes the parent record’s [Colour] column to “Green”, you could try the Grouped action option in the bot.
You could create the data change action “Change Colour to Green” and reference action to change the related children of “Xero” table to “Invoiced” status. Then you could group these two actions and use in the bot as grouped action option. My testing showed that grouped action option executes both the actions.
Grouped action in actions pane:
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:
Suvrutt,
To clarify, when you say “and reference action to change the related children of “Xero” table to “Invoiced” status.” Is the action created in the Xero table or the Job Board table? Can you group actions from different tables? Or do you mean to create an action for the Job Board table that somehow references the Xero rows and columns I wish to set to “invoiced”?
I have detailed the reference action in the screenshots above. Reference actions always act in pairs. The first action created on parent table lists the key of the rows of the child table that need to change. In the example, the following is the first reference action on parent. As you can see, it lists the records of the child table to act on and also mentions what action to execute in the child table. It also mentions the parent table and referenced table or the child table
Then following is the second action on the child table to change the child table column as desired.
While grouping you need to group the actions from the same table. However in the case of reference actions, the initiating or master action of the reference action is on the parent table. In grouping you need not mention the second action of the reference action ,because it automatically gets executed when the action on master action is executed. Consider the pair of reference actions as tightly coupled and only master action initiates both the actions-on parent and child tables.
Thank you for your patience.
I cannot select the child reference action from the list (see image below) in the Parent ref action? I have saved etc. The child action is called Set [Inv Status].
Your referenced table setting needs to be “Xero” and not “Job Board” 
The examples provided show this needs to be child table.
Yes! My oversight.
This is more complex than I thought. Thanks for working with me.
I have checked the structure and while the [Colour] changes to green, I can’t get the child table to update with [Inv Status] = “Invoivced”.
I have noticed the group action ihn Job Board is not being called by the Bot so I tried that and an error came up that two group actions can’t be called in one event. Makes sense.
What can I try next? I am stuck.
Are both actions included in the group action? Colour and Master reference action?
And is the group action being called in the bot as sample screenshots l shared?
Actually, the bot configuration is relatively simple and I shared the screenshots after testing at my end that it works. Request you to carefully again verify if you are not missing some configuration or setting.
The test of the referenced rows [Related Xeros] is returning the Xero[Inv ID] list values as expected, but the Set [Inv Status] action is not being applied?
Could you share relevant screenshots of the actions and bot?
What kind of action "Set [Invoice Status] to Invoiced "is?
Data: set the value of some of the columns in this row.
It needs to be " execute an action on a set of rows" type. That is master action of reference actions pair.
Set [Inv Status] was my version of your earlier post…
This is the child action?
Sorry Suvrutt, my mistake,
This is my master ref.
