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.

[Janu sree]

@Ankur Bawiskar Kindly assist here

[Ahmmed Ali]

Hello @Janu sree 

Try below script:

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(parsedData[i].name_var_set + "");

}

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

[Janu sree]

Thanks for the reply,

I tried its working but Is there any possibility to get the value into the table with numbers.

like    1.english

           2.British

          3. Spanish

[Ahmmed Ali]

You can prefix array index before pushing the string value to the array as below:

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