How can I get the value of MRVS to record producer

[Anna_Servicenow]

I have a record producer(target u_xb_business) which parse the values in a 2 column excel to a MRVS. The number of  rows can be any.
On submit,I need this to be populated in

1) our custom table u_xb_business

2) Since there can be 100+ rows , Is it possible to populate this value in column row format

[Moin Kazi]

Hi @Anna_Servicenow ,

Please store the data in the format below to facilitate easy population in the MRVS.

var response = [{"mrvsColumn1":"Adela Cervantsz","mrvsColumn2":"adela.cervantsz@example.com"},{"mrvsColumn1":"Abel Tuter","mrvsColumn2":"abel.tuter@example.com"},{"mrvsColumn1":"Aileen Mottern","mrvsColumn2":"aileen.mottern@example.com"}]

[Note: If you have data in object format, you can use JSON.stringify(object) to convert the data into the string format below.]

You can use client script to populate data.

Populate below data in MRVS - 

g_from.setValue('mrvs_internal_name', response); // please replace mrvs internal name

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you found my response **helpful**, I’d appreciate it if you could take a moment to select **"Accept as Solution"** and **"Helpful"** Your support not only benefits me but also enriches the community.

Thank you!
Moin Kazi

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Anna_Servicenow]

I am able to populate the value in MRVS , what is not working is populate in this value in target table u_xb_business.