Copy a reference field value from one table to reference field in another table.

[Bindhu1]

Hi,

How can I copy the value selected in the select_the_approver variable (referencing the sys_user_grmember table) to the approver variable (referencing the sys_user table) on a ServiceNow catalog item form? The goal is to automatically populate the approver variable with the corresponding user from the selected group member in select_the_approver. Kindly help me with script.

(getValue and setValue method did not work here since variables referring to different table)

[Brad Bowman · Accepted solution]

Try the variable Auto-populate feature to dot-walk to the user of the sys_user_grmember variable

[Bindhu1]

@Brad Bowman  
Thanks as always! I hadn’t thought about it this way—appreciate your insight.