On Select Reference field variable & populate select box variable

[Km Sh]

Hello Team,

We have Reference variable in a Catalog form, when reference value is selected then auto populate the select box variable with the corresponding pairs as shown below:-

Reference Var	Select box Var
AS1041	APAC
AS1039	APAC
AS1149	EMEA
AS1057	EMEA
BS1054	Canada
BS1725	Canada
BS1578	Canada

Thanks

[Community Alums]

Hi @Km Sh

Can you do something like you can create one field in your custom table and in that field you can store the value of Select box variable , if it is possible you can simply glide on that custom table and in addQuery('sys_id', newValue)  and in if condition you can able to set the value of that field.

var gr = new GlideRecord('sys_user');
   gr.addQuery('sys_id', newValue);
   gr.query();
   if(gr.next()){
	g_form.setValue('select_value', gr.select_value);
        g_form.update();
   }

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak