How to add a Multi-Row Variable set from a record producer to the target table.

AM24
Giga Guru

Hello, I have a record producer that contains a multi-row variable set. I want the values for this field to be copied over to the record created by the record producer. I was wondering how I can do that. Thanks.

7 REPLIES 7

sanh
Tera Contributor

Are you expecting the multi-row variables to be copied to description?

Not really. I want the field and the multirow variable set to show up on the form. Maybe under something like variables

Mahesh23
Mega Sage

Hi,

Add below code in record producer script

Note : replace "mrvs_2" with your multirow variable set name

//Type appropriate comment here, and begin script below
var mRow = producer.mrvs_2; // replace "mrvs_2" with your multirow variable set name

var mRowObj = JSON.parse(mRow);

for (i = 0; i < mRowObj.length; i++) {
   current.short_description = mRowObj[i].test; // test is name of the variable present in the MRVS
}

find_real_file.png

In my case I am updating multirow variable set data to short description

 

find_real_file.png

Multirow variable set data is copied to Short Description 

 

find_real_file.png

Hi, Did you tried the above solution..?