Mapping the MRVS field value to the custom table field

[Janu sree]

Hello Community,

We have a requirement to map the field of Multi Row Variable set values to the custom table fields.

I am using the below code in record producer to map the multi-row variable set field 'Name and Number' to the field of a table extended from case.

Code is working but i am getting the field name as well along with value. and also how to get the Only values mapped to the table field in row wise like if multiple entries are there

PS: I'm using string field type in custom table.

var FR = producer.please_list_all_escorts_or_persons;

var arr = [];

var parsedData = JSON.parse(FR);

for (var i = 0; i < parsedData.length; i++) {

    var obj = {};

    obj['Name and Number'] = parsedData[i].name_var_set;

    arr.push(obj);

}

current.setValue('nam0', JSON.stringify(arr)); 

[jaheerhattiwale · Accepted solution]

@Janu sree Tried and tested solution. Please use below code

var FR = producer.please_list_all_escorts_or_persons;

var arr = [];

var parsedData = JSON.parse(FR);

for (var i = 0; i < parsedData.length; i++) {

    var bulletNumber = i+1;

    arr.push(bulletNumber+". "+parsedData[i].name_var_set);

}

arr = arr.toString();

arr = arr.replaceAll(",","\n");

current.setValue('nam0', arr);

Please mark as correct answer if this solves your issue.

[Ahmmed Ali · Accepted solution]

This should work

var FR = producer.please_list_all_escorts_or_persons;

var arr = [];

var parsedData = JSON.parse(FR);

for (var i = 0; i < parsedData.length; i++) {

    var count = i+1;

    arr.push(count  + ". " + parsedData[i].name_var_set + "");

}

current.setValue('nam0', arr.join("\n")); 

[jaheerhattiwale · Accepted solution]

@Janu sree Tried and tested solution. Please use below code

var FR = producer.please_list_all_escorts_or_persons;

var arr = [];

var parsedData = JSON.parse(FR);

for (var i = 0; i < parsedData.length; i++) {

    var bulletNumber = i+1;

    arr.push(bulletNumber+". "+parsedData[i].name_var_set);

}

arr = arr.toString();

arr = arr.replaceAll(",","\n");

current.setValue('nam0', arr);

Please mark as correct answer if this solves your issue.

[jaheerhattiwale]

@Janu sree Did you try this?

[Janu sree]

Its working.. Thanks