question Populating response in MRVS using onSubmit client script in Virtual Agent forum

Populating response in MRVS using onSubmit client script

Ankita9793 — Mon, 29 Dec 2025 07:02:03 GMT

Hi all,

I am getting the expected response but not able to populate/ set value in MRVS field, Please suggest
based on the attachment 'employee id's will be populated in mrvs and onsubmit associated first and last name should be populate in the mrvs.

function onSubmit() {

var type = g_form.getValue('request_type');

var mode = g_form.getValue('request_mode');

var xl = g_form.getValue('excel_input');

var empID = g_form.getValue("employee_id");

if (type != 'Delete' && mode == 'Multi User Request') {

var multiRowVariableSet = JSON.parse(g_form.getValue('multiple_staff_id'));

for (var i = 0; i < multiRowVariableSet.length; i++) {

if (multiRowVariableSet) {

alert('multiRowVariableSet.employee_id[i]' + multiRowVariableSet[i].employee_id);

ShowHideLoaderCatalog();

var getDepartment = new GlideAjax('abcRecordHelper');

getDepartment.addParam('sysparm_name', 'getParametersHelper');

getDepartment.addParam('sysparm_table_name', 'sys_user');

getDepartment.addParam('sysparm_fields', 'employee_number,first_name,last_name');

getDepartment.addParam('sysparm_filter_query', 'employee_number=' + multiRowVariableSet[i].employee_id);

getDepartment.getXMLAnswer(function(response) {

if (!response) {

g_form.clearValue('employee_id');

g_form.clearValue('firstname');

g_form.clearValue('lastname');

// g_form.showFieldMsg('employee_id', getMessage('It is not a valid Employee ID'), 'error');

return false;

}

response = JSON.parse(response);

alert('response' + JSON.stringify(response));

alert('response[0]' + JSON.stringify(response[0]));

var newres = JSON.stringify(response);

if (response[0]) {

g_form.setValue('multiple_staff_id[i].firstname', newres[0].first_name);

g_form.setValue('multiple_staff_id[i].lastname', newres[0].last_name);

} else {

g_form.clearValue('employee_id');

g_form.clearValue('firstname');

g_form.clearValue('lastname');

g_form.showFieldMsg('employee_id', getMessage('It is not a valid Employee ID'), 'error');

}

ShowHideLoaderCatalog('hide');

});

}

Getting response/ response[0] as below

Re: Populating response in MRVS using onSubmit client script

Matthew_13 — Mon, 29 Dec 2025 07:14:46 GMT

Hi there, this is a common MRVS gotcha..

Even if your GlideAjax response looks correct, the MRVS will only populate if you set the MRVS variable itself the multi-row set field and the value you pass is JSON in the MRVS row format array of objects keyed by the MRVS variable names.

Lets see please check:

Make sure you’re doing g_form.setValue('<MRVS_VARIABLE_NAME>', JSON.stringify(rows));
not setting a field inside the MRVS

The JSON must be like:

[
  {"u_employee_id":"123","u_first_name":"John"},
  {"u_employee_id":"456","u_first_name":"Jane"}
]

Where the keys match the variable names inside the MRVS.

If you’re calling GlideAjax in a loop don’t set the MRVS inside each callback and async responses can overwrite each other. Build the rows array and set the MRVS once after all responses return.

Once I switched to setting the MRVS field directly and only updating it once at the end, it populated consistently.

@Ankita9793 - Please mark as Accepted Solution and Thumbs Up if you found Helpful!!

Re: Populating response in MRVS using onSubmit client script

Ankur Bawiskar — Mon, 29 Dec 2025 08:54:19 GMT

@Ankita9793

it might be challenging to set the MRVS onSubmit as by the time you set the form might submit

why not use onChange catalog client script to populate the MRVS?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Populating response in MRVS using onSubmit client script

Ankur Bawiskar — Mon, 29 Dec 2025 09:01:03 GMT

@Ankita9793

when you are returning value from script include pass the exact json string so that you can directly set it rather than parsing in client side

example: your json should be array of json objects like this

[

{

"first_name":"Abel",

"last_name":"Tuter",

"employee_id": "8978"

{

"first_name":"Beth",

"last_name":"Anglin",

"employee_id": "89895456"

}

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Populating response in MRVS using onSubmit client script

Brad Bowman — Mon, 29 Dec 2025 13:43:40 GMT

You could push the Script Include responses to an object in the Catalog Client Script, then set the value of the MRVS once it's done, but a better approach is for your Catalog Client Script to look more like this to call the GlideAjax only once, passing in the value of the MRVS. This ensures the client script runs efficiently, removing unnecessary trips to the server and back.

You'll need to change your Script Include Function to parse and loop through the MRVS rows, building a new object with the values from the GlideRecord results. You can try to make it dynamic as you did before, also passing in the table name, fields, and filter with the MRVS value, but that probably isn't as useful in this specialized situation.

You can instead run this in the process that is populating the employee ids in the MRVS when an attachment is added for a better user experience.

Re: Populating response in MRVS using onSubmit client script

Ankur Bawiskar — Mon, 23 Feb 2026 06:16:23 GMT

@Ankita9793

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏