question Re: Get values from MRVS in Developer forum

Get values from MRVS

miyu — Wed, 02 Feb 2022 10:30:06 GMT

Is there any way to get values from MRVS?
Specifically, I would like to have a record producer variable automatically populated with the result of a calculation based on the following MRVS values.
In the screenshot below, I want to multiply the "金額" and "課金単位数" and set the result of adding each to the "利用料金" variable.
In this screenshot, we see
In this screenshot, 500 x 1 + 600 x 2 = 1,700, so we need to set 1,700 to the "利用料金" variable.
Can I do it?

Re: Get values from MRVS

Anil Lande — Wed, 02 Feb 2022 10:48:20 GMT

Hi,

Please check below links almost same issue is resolved there:

https://pathwayscg.com/accessing-multi-row-variable-sets-client-side-in-servicenow/

https://community.servicenow.com/community?id=community_article&sys_id=2a508caedbf47f48d82ffb243996198f

Thanks,
Anil Lande

Re: Get values from MRVS

Murthy Ch — Wed, 02 Feb 2022 11:04:20 GMT

Hi @miyu

Can you try this:

function onSubmit() {
    var count = 0;
    var mrvsData = g_form.getValue("u_request_data");  //replace with mrvs internal name
    var mrvsDatastr = JSON.parse(mrvsData);
    for (var i = 0; i < mrvsDatastr.length; i++) {
        count = count + parseInt(mrvsDatastr[i].u_data1) * parseInt(mrvsDatastr[i].u_data2);  //map your variable names
    }
    g_form.setValue("total_value", count);  //map variable name where you want to set
}

Tested in my PDI

Hope it helps

Thanks

Murthy

Re: Get values from MRVS

Hitoshi Ozawa — Thu, 03 Feb 2022 07:15:01 GMT

Unfortunately, this isn't possble unless a new widget is created.

There are events that will detect addition and modification of mrvs rows but there is no event to detect deletion of mrvs rows. So, deleting a row or selecting delete all can not be detected and the total will be wrong.

The only way without developing a new widget is to create a button on the main form that will update the total when it is pushed.

Re: Get values from MRVS

Vaishnavi Lathk — Thu, 03 Feb 2022 07:17:18 GMT

Hi,

You can use this

var mrvs = current.variables.multirowvs;
var totalRows = mrvs.getRowCount();
var arr = [];

for (var i = 0; i < totalRows; i++) {
	var value = mrvs.getRow(i).getCell(',mrvs_col').getCellDisplayValue();
	arr.push(value.toString());
}

current.variables.mrvs_to_string = arr.toString();

Regards
Vaishnavi

Re: Get values from MRVS

Willem — Thu, 03 Feb 2022 08:41:36 GMT

Hi Miyu,

Have a look at an article I wrote about MRVS here:

https://community.servicenow.com/community?id=community_article&sys_id=f911162e1b6e1054d2ccea89bd4bcb53

In the comments I explain your use case to, from a MRVS value change, set a value on one of the main variables:

On the Multi Row Variable Set use the following on an onChange script on the Variable you want as the trigger. In my case the employee_salary:

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

So in your case you should have an onChange for both the column that contains 500 and 600 as well as the 1 and 2. When you chage eiter of the values for those columns or add a new row you can update the total (in my code 'salary').

Hope this helps! Feel free to check out the Article and if it helped, please mark the article as helpful as well 🙂

Re: Get values from MRVS

Aman66 — Thu, 15 Sep 2022 15:00:34 GMT

hi @Vaishnavi can you also help me i want to get a value from MRVS and set the value into other variable with comma separated using of catalog client script