Add value of an MRV field

[jkelvynsant]

Hello, community! I'm trying to sum variables (Value) within MRV and send that sum to a variable (Sum) outside of MRV. 

I developed this client script within the record producer, but it's not working:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading) {
        return;
    }

    var mrvsRows = g_form.getValue("nota_fiscal");
    if (!mrvsRows) {
        g_form.setValue("sum", 0);
        return;
    }

    var rows = JSON.parse(mrvsRows);
    var sum = 0;

    for (var i = 0; i < rows.length; i++) {
        var cost = rows[i]["value"];
        if (cost) {
            sum += parseFloat(cost) || 0;
        }
    }


    g_form.setValue("sum", sum);
}

[palanikumar]

on change of what field are you executing this JS?

[jkelvynsant]

Since MRV didn't appear, I left it blank. 

[palanikumar]

Suggest you to create a onsubmit client script within MRVS and add the below script to update the parent

function onSubmit() {
    if (isLoading) {
        return;
    }

    var mrvsRows = parent.g_form.getValue("nota_fiscal");
    if (!mrvsRows) {
        parent.g_form.setValue("sum", 0);
        return;
    }

    var rows = JSON.parse(mrvsRows);
    var sum = 0;

    for (var i = 0; i < rows.length; i++) {
        var cost = rows[i]["value"];
        if (cost) {
            sum += parseFloat(cost) || 0;
        }
    }
    parent.g_form.setValue("sum", sum);
}

[Brad Bowman]

If you change this line, you'll get something - onChange of whatever variable this is triggering on, provided the MRVS is populated prior to that variable changing. 

var cost = rows[i].value;

If you're looking for a way to make sure this count is accurate when rows are added, edited, or removed from the MRVS, check out these options:

https://www.servicenow.com/community/itsm-forum/populate-field-outside-mrvs-with-a-total-sum-of-fiel... 

https://www.servicenow.com/community/developer-forum/actions-after-a-mrvs-update/td-p/3031014