How to do Map to field on MRVS

[Saridha_L1]

Hi Team,

Can anyone please help , How to do Map to  field on  MRVS ,there is no direct option, is there anyway to achieve.

Regards,

Saridha.L.

[Mark Roethof]

Here is example code which with correct MRVS name + correct field names + correct variable names would work.

Obviously I don't know your table/field/variable names, so you need to set this yourself.

Script can be used within Script field on Record Producer.

var mrvs = producer.your_mrvs_internal_name;

var rowCount = mrvs.getRowCount();
for (var i = 0; i < rowCount; i++) {
	var gr = new GlideRecord('your_custom_table');
	gr.initialize();
	gr.setValue('field_abc', row.variable_from_mrvs_abc);
	gr.setValue('field_xyz', row.variable_from_mrvs_abc);
	gr.insert();
}

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Saridha_L1]

I am sorry, could you please tell me which script, is that OnLoad.

[Mark Roethof]

Script field on the Record Producer.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Saridha_L1]

Sure,Thank you. Will do it now and update,Thank you.

[Saridha_L1]

I have tried it, its not working. 

var mrvs = producer.journal_entry_line_items;

var rowCount = mrvs.getRowCount();
for (var i = 0; i < rowCount; i++) {
var gr = new GlideRecord('x_journal_entr_journal_entry');
gr.initialize();
gr.setValue('u_account', row.u_account);
gr.setValue('u_cost_center', row.u_cost_center);
gr.insert();
}

Field name and variable name both are same.