Fields are not populating after submitting record producer

[sinu2]

HI Team,

I have a record producer. Inside record producer i have created a multi row variable set name calle d as "item_list". Inside multi row variable set i had 6 variables. 

As soon as i submit the record producer from portal,  A record is creating to that table but fields are showing empty.

So how can i map those MRVS variable content inside native view table fields?

\

I had created a before Business rule to map MRVS to table fields but not working

the MRVS log is showing error like below

(function executeRule(current, previous /*null when async*/) {

var value = current.variables.items_list; //  MRVS variable name here
	gs.log('Inside :', value);

var parser = JSON.parse(value);
gs.log(parser);
var addtable = new GlideRecord('x_pl4_move4u_item');

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

addtable.name = parser[i].name;
addtable.move_request = parser[i].move_request;
addtable.is_fragile = parser[i].is_fragile;
addtable.category = parser[i].category;
addtable.short_description = parser[i].short_description;
addtable.volume = parser[i].volume;
addtable.insert();

}

})(current, previous);

[Sai Kumar B]

In "What it will contain" tab you can see the Script field

[sinu2]

Hi SAi.

I wrote the record producer script like below to map record producer MRVS variables in to same table fields

var parserList = JSON.parse(producer.items_list);
gs.info('move information MRVS---'+parserList);
var addtable = new GlideRecord('x_pl4_move4u_item');

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

addtable.name = parserList[i].name;
addtable.move_request = parserList[i].move_request;
addtable.is_fragile = parserList[i].is_fragile;
addtable.category = parserList[i].category;
addtable.short_description = parserList[i].short_description;
addtable.volume = parserList[i].volume;
addtable.insert();

}

By adding the above script duplicate records are creating and all fields are not mapping.

Note: my record producer and gliding table both are same

[Mahesh23]

Hi Sinu,

Write the below code under Record producer script

var mrvsData = producer.items_list;

var mrvsDataObj = JSON.parse(mrvsData);

for (i = 0; i < mrvsDataObj.length; i++) {
	addtable.name = mrvsDataObj[i].name;
	addtable.move_request = mrvsDataObj.move_request;
	addtable.is_fragile = mrvsDataObj.is_fragile;
	addtable.category = mrvsDataObj.category;
	addtable.short_description = mrvsDataObj.short_description;
	addtable.volume = mrvsDataObj.volume;
}