Populate field on parent table from a value on child table based on state in child table

Suryansh Verma
Tera Contributor

I want to auto Populate the field on the parent table from a value on the child table based on the state in the child table.

The child table has a choice field "FIELD1" with 2 choices A&B

The parent table has the same field "FIELD2" with 2 choices A&B

So when on the child table if I select A and mark it as closed complete, then I want the parent table FIELD1 to be populated based on the value from FIELD2.

 

find_real_file.png

 

 

1 ACCEPTED SOLUTION

Ishaan Shoor
Mega Sage
Mega Sage

You can create an update BR on the child table to set the whenever "field A" is updated or changed it sets the same value of "field B" on the parent table. 

You can either dot walk that field in and set the value directly(Screenshot 1)

find_real_file.png

find_real_file.png
You can also write a script to do the same(Screenshot 2)

find_real_file.png

Hope this helps!
BR.
Ishaan Shoor

View solution in original post

15 REPLIES 15

Not working for me.

On the child table, I have a field that stores pass/fail

find_real_file.png

and on the parent table, the field is 

 

find_real_file.png

 

so I want when the state is closed complete the parent table field previous pass/fail auto-populates from the value from overall pass/fail field

You can add the trigger condition on the BR as "state changes to closed complete" and try again.

Other items to set the values can remain the same.

Hope this helps!
BR.
Ishaan Shoor

still doesn't work 😞

Can you share the screenshot of BR you've created?

 

Hope this helps!
BR.
Ishaan Shoor

find_real_file.png

 

find_real_file.png