The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Add value of an MRV field

jkelvynsant
Tera Contributor

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

jkelvynsant_0-1758205553273.png

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);
}

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@jkelvynsant 

this link has approach and you can enhance

Populate field outside MRVS with a total sum of fields inside MRVS 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@jkelvynsant 

this link has approach and you can enhance

Populate field outside MRVS with a total sum of fields inside MRVS 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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