Creating Expense Request using MRV

[Peter Williams]

Good Morning everyone,

i am task to create an expense request form in ServiceNow and have decided to use the MRV for the expense line items.

But one of the requirements is to get the total item cost listed on the form as they are entered into the MRV.

What is the best approach for this?

[Mohith Devatte · Accepted solution]

Hello @Peter Williams ,

IF you want to do it on change of the MVRS then i can suggest you a solution which i used in my requirement and it worked for me .But its bit a lengthy process but we can do .

Follow this process step by step :

1)You need to handle this via hidden widgets on the record producer 

create a widget with this code 

api.controller = function($scope) {
    /* widget controller */
    var c = this;
var g_form = $scope.page.g_form;
    $scope.$watch(function() {
        
        return g_form.getValue('your_mvrs_internal_name');
    }, function(value) {
        if (value) {
            var jsonData = JSON.parse(value);
         
            var total = 0;

            for (var i = 0; i < jsonData.length; i++) {
 
                total=total+parseInt(jsonData[i].your_cost_field_name_inside_mvrs);
            }

            //Set Value in the total field
          g_form.setValue('total_cost_field_name_outside_mvrs', total);
        }
    });
};

2)After this create a Variable of type Custom and add the Widget  in the widget field like below 

Hope this helps 

Mark my answer correct if this helps you 

Thanks

[Mohith Devatte · Accepted solution]

Hello @Peter Williams ,

IF you want to do it on change of the MVRS then i can suggest you a solution which i used in my requirement and it worked for me .But its bit a lengthy process but we can do .

Follow this process step by step :

1)You need to handle this via hidden widgets on the record producer 

create a widget with this code 

api.controller = function($scope) {
    /* widget controller */
    var c = this;
var g_form = $scope.page.g_form;
    $scope.$watch(function() {
        
        return g_form.getValue('your_mvrs_internal_name');
    }, function(value) {
        if (value) {
            var jsonData = JSON.parse(value);
         
            var total = 0;

            for (var i = 0; i < jsonData.length; i++) {
 
                total=total+parseInt(jsonData[i].your_cost_field_name_inside_mvrs);
            }

            //Set Value in the total field
          g_form.setValue('total_cost_field_name_outside_mvrs', total);
        }
    });
};

2)After this create a Variable of type Custom and add the Widget  in the widget field like below 

Hope this helps 

Mark my answer correct if this helps you 

Thanks

[Peter Williams]

sorry to ask, i am new to this.

i created the widget here

where do i go to create the variable of type custom?

[Mohith Devatte]

@Peter Williams No problem i will guide you 

First thing you need to do is delete the widget that you have created and create a new widget under service portal module.You have created it under system widget which will not work 

Open the widget module under service portal and click on new and then place the entire script in the client controller field .Remove the existing script in the client controller and copy the script that you wrote in the system widget

Just type in maintain items in the left navigator and open your catalog item 

Then open your catalog item by searching your catalog item name and then scroll down to variables related list 

Then click on new button to create a new variable and then select the type as custom as shown below and add your widget in the widget field under type specifications tab

hope this helps 

[Mohith Devatte]

@Peter Williams edited the above answer please check 

[Peter Williams]

got it all added.

question, will this only work in the Service Portal for Catalog it or with Record Producers?