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

Suryansh Verma · ‎08-08-2021

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.

Ishaan Shoor · ‎08-08-2021

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)

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

Hope this helps!
BR.
Ishaan Shoor

View solution in original post

Upender Kumar · ‎08-08-2021

Go to the advance section and write script as mentioned in previous replies.

var grP=new GlideRecord('yourtable');
if(grP.get(current.control.sys_id)){
  grP.field2=current.field1
  grP.update();
}

Suryansh Verma · ‎08-08-2021

still not working

Ishaan Shoor · ‎08-08-2021

If you're Happy to get on a quick call to discuss this let me know.

Google Meet

Hope this helps!
BR.
Ishaan Shoor

Suryansh Verma · ‎08-08-2021

Thanks Ishaan for your Help and efforts :-))

Ishaan Shoor · ‎08-08-2021

Cheers, Suryansh, Happy to help!

Please mark the answer as correct.

Hope this helps!
BR.
Ishaan Shoor