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

Sourabh26 · ‎01-31-2022

Hi,

Have you try the above code?

Sebastian L · ‎01-30-2022

Is "alert(g_form.getValue('variable_set_name'));" giving you undefined?

Can you do a screenshot of the actual variable set and name, because this should give you the value of the mrvs, and the client script with alert as this, and the end result.

Best regards,
Sebastian Laursen

shloke04 · ‎01-30-2022

Hi,

Please update your script as below :

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);
	//g_form.setValue('Variable Name',totalCost);
}

This is working for me in my PDI.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Deepika18 · ‎01-30-2022

Hi thank you but its not working

shloke04 · ‎01-31-2022

Can you share the version of code which you have written to assist you further?

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke