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

 

2 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

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