Not able to retrieve Multi Row variable set data using onSubmit client script

Deepika18 · ‎01-30-2022

I'm unable to retrieve MRVS data from onsumbit client script. I have a requirement to get the total value of seats into a variable outside of MRVS. I'm using on submit client script.

Below is the code which I tried

function onSubmit() {
var gr = g_form.getValue(#varibale set name);
var parser = JSON.parse(gr);
var sum = 0;
alert(parser);for(var i=0;i<parser.length;i++){
sum = sum + parseFloat(parser[i].seats); // variable name inside MRVS
alert(sum);
}

I'm getting gr value as empty and the total field is also not updating. Please help me in getting the total value into a variable outside of the multi row variable set.

Sai Kumar B · ‎01-31-2022

Hi Author,

To access the outside variables do the below

First, You would need to create an Onload script in your catalog item, with isolate script set to false:

function onLoad() {
   //We need to make the g_form object for the parent item available for later
	
    this.cat_g_form = g_form;
   
}

Once that is in place, you can use something like in a script on the MVRS (also set to isolate script false).

function onSubmit() {
    //Type appropriate comment here, and begin script below
    var multiRowVariableSet = JSON.parse(g_form.getValue('demo_variable_set')); // Replace your variable set Name and not label here.
    var totalCost = 0;
    for (var i = 0; i < multiRowVariableSet.length; i++) {
        totalCost += multiRowVariableSet[i].Variable_Name; //add all totals from the MRVS to 1 total
    }
    alert(totalCost);
	//Service Portal logic
    if (this) {
        this.cat_g_form.setValue('variable_name', 'totalCost');
    } else {
		//Native UI logic
        parent.g_form.setValue('variable_name', 'totalCost');
    }
}

View solution in original post

Sai Kumar B · ‎01-31-2022

@Deepika Could you please mark my response as correct and close the loop it would help future readers as well

Nick Parsons · ‎08-07-2022

If you're using Quebec or higher you can use g_service_catalog.parent to access all row MRVS data from within your MRVS client script:

var mrvsDataJSON = g_service_catalog.parent.getValue("MRVS_INTERNAL_NAME");

Ankur Bawiskar · ‎08-08-2022

Does this work in both Native + Portal?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Nick Parsons · ‎08-16-2022

Yes, it works in all environments such as the Service Portal, Now Platform/Native, Workspace, and Now Mobile.

The main limitation is that the above is only able to get/read a value, it can't set values. For that we need to use the other methods shown here.