Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Update Parent Table Column based on Child change column

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 Solved
0 8 1,149
1 ACCEPTED 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.

View solution in original post

8 REPLIES 8
Top Labels in this Space