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

Deepika18 · ‎01-31-2022

Not working.

var gr = g_form.getValue('abc');

this is not holding any value.

Deepika18 · ‎01-31-2022

we are getting this error while adding a row in MRVS

Ankur Bawiskar · ‎01-31-2022

Hi,

did you check which script is that?

Regards
Ankur

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

Deepika18 · ‎01-31-2022

yes. regarding the same script which I'm working on

Sourabh26 · ‎01-30-2022

Hi,

Try the below script.

var value = g_form.getValue('MRVS_FIELD_NAME');
var multiJson = JSON.parse(value);
var sum = 0;
for(var i = 0; i<multiJson.length; i++)
{
  //execute all the rows of mrvs
  if(multiJson[i].MRVS_FIELD_SEAT){ //if seat is not empty then
    var t = multiJson[i].amount;
    sum = sum + Number(t);
  }
}
g_form.setValue('FIELD_NAME',sum);//field outside of MRVS

Mark this as Helpful/Correct if Applicable.

Regards,

Sourabh