Hello,
I want to create a behaviour to change Parent table values based on the Child update (change of a field value).
I know that I should use the "Data: execute an action on a set of rows" along with "Data: set the values of some columns in this row", but still struggling with the expressions.
So, I have a Parent table named "opportunities" and child table "quotes" with Ref column to the Parent table.
In both tables I have columns for Stage with ENUM list of choices. When the Stage value into the Child table is changed to "Sent" I want the Stage value to the Parent table to be changed respectively to "Feedback".
1. I created a behaviour ("Stage - Feedback")to the Parent table with action "Data: set the values of some columns in this row" with action: Stage = "Feddback" but how to tell to the behaviour section that this should work only when the Child Stage is "Sent"?
2. I created a behaviour ("Update Opportunity Stage") to the Child table "Data: execute an action on a set of rows" with
For a record of this table: Child table
Referenced Table: Parent table
Referenced Rows: I do not know how to create an expression for this
Referenced Action: the child behaviour ("Stage - Feedback")
Could someone try to help with the 2 highlighted in bold sentences?
Thanks in advance for any help.
Solved! Go to Solution.
In addition to my previous post - I think I solved it. The problem was with the second Child behaviour with the condition [status]= "Sent". With this condition enabled I tested it with a button and it worked (the button was visible only if the condition was true), but even that I attached it to the Child form_view action it did not do anything. Then I created an event with Updates Only to the Child table (Status = "Sent") and then created a bot with this event and with the Child behaviour as an action (Data: execute an action on a set of rows).
@Suvrutt_Gurjar Thanks again for your help.
User | Count |
---|---|
34 | |
8 | |
3 | |
2 | |
2 |