Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to write on change client script to get the sum of the MRVS

harinya
Tera Contributor

HI ,
Can someone please help on this
I have MRVS with two variables quantity and month, if i enter the value of quantity records 

i want the sum of the quantity values to be displayed in total quantity variable which is outside of the MRVS
need a on change client script as user can change the quantity , so Total quantity should show updated value

harinya_0-1700132696058.png

 

3 ACCEPTED SOLUTIONS

Hi @harinya 

 

There are a few steps you need to take:

 

First on your catalog item, create a (hidden) field 'quantity_updated' (type checkbox).

 

Then Create a onLoad Client script on your catalog item:

 

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

 

 

Second, create a onChange Client script on your catalog item, which triggers on change of quantity_updated. Please note that you need to fill the name of your MRVS.

 

 

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '' || newValue == 'no') {
        return;
    }
    g_form.setValue('quantity_updated', false);

    //Need to set a timeout because MRVS is not readable directly.
    setTimeout(function() {
        var mrvsRows = g_form.getValue("<<FILL MRVS NAME>>");
        var oMrvs = JSON.parse(mrvsRows);
        var total_quantity = 0;
        for (var i in oMrvs) {
            total_quantity += parseInt(oMrvs[i].quantity);
        }

        g_form.setValue("total_quantity", total_quantity);

    }, 500);

}

 

 

And last create a onSubmit Client script in your MRVS:

 

function onSubmit() {

        //Service Portal logic
        if (this) {
            this.cat_g_form.setValue('quantity_updated', true);
        } else {
            //Native UI logic
            parent.g_form.setValue('quantity_updated', true);
        }
}

 

 

That should be it.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

You could also try to set the timeout value to 1000 ms instead of 500, to give the instance more time to process the submit.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

Hi @harinya 

 

You can replace 

   total_quantity += parseInt(oMrvs[i].quantity);

 

by 

   total_quantity += parseFloat(oMrvs[i].quantity);

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

22 REPLIES 22

Peter Bodelier
Giga Sage

Hi @harinya 

 

A solution could be found here:
Solved: How to calculate the sum of the value in MRVS (mul... - ServiceNow Community

If you don't want to use this approach, let me know. I can try to come up with a different solution, if I have some time.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

Hi Peter Bodelier,

Thanks for your Response,

i have tried that script but it's not working for me 

harinya_0-1700139434904.png

 

 

Hi @harinya 

 

I'll try to create a working one for you. Can't promise it'll be today though. Will need to find some time.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

HI @ Peter Bodelier ,
Did you got the chance to look on this