- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2021 03:05 AM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2021 03:18 AM
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)
BR.
Ishaan Shoor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2021 03:09 AM
You can create a after update BR on child table. In BR get the parent record from parent sys_id from child record and update parent record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2021 03:11 AM
var grP=new GlideRecord('yourtable');
if(grP.get(current.parent.sys_id)){
grP.field2=current.field1
grP.update();
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2021 03:18 AM
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)
BR.
Ishaan Shoor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2021 03:35 AM
If you have sys_id of the record you can use shortcuts
https://developer.servicenow.com/blog.do?p=/post/training-grget/