question Getting Values from Multi Row Variable Set Record Producer in Developer forum

Getting Values from Multi Row Variable Set Record Producer

gregrice — Sun, 17 May 2020 04:54:22 GMT

I am having trouble inserting data into my related list from a MRVS for my record producer. Any suggestions on what I am doing wrong?

MRVS name = 'other contacts';

variable name = 'name';

var contactArr = producer.other_contacts;
var contactCnt = producer.other_contacts.getRowCount();

if (contactCnt > 0) {
for (i = 0; 1 < contactCnt; i++) {
var gr = new('related_record');
gr.initialize();
gr.setValue('name',contactArr[i].name);
database.insert();
}
}

I am getting the correct row count I just cannot get the data from the array;

Re: Getting Values from Multi Row Variable Set Record Producer

Ankur Bawiskar — Sun, 17 May 2020 05:21:13 GMT

Hi,

the value you get from MRVS is json; you need to parse that

also print if you are getting proper json

correct this mistake/error; i < contactCnt

for (i = 0; i < contactCnt; i++) {

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Getting Values from Multi Row Variable Set Record Producer

gregrice — Sun, 17 May 2020 15:17:53 GMT

Thanks Ankur, I am pretty close. I added a string variable to my MRVS to test

MRVS = Other Contacts

variables = Name (reference to sys_id)

test (string variable)

var contactArr = JSON.parse(producer.other_contacts);

var contactCnt = producer.other_contacts.getRowCount();

if (contactCnt > 0) {
for (i = 0; i < contactCnt; i++) {
var gr = new('related_record');
gr.initialize();

gr.setValue('test',contactArr[i].test); <--------- this works
gr.setValue('name',contactArr[i].name); <------- this doesn't name is a reference variable?
database.insert();
}
}

Re: Getting Values from Multi Row Variable Set Record Producer

gregrice — Sun, 17 May 2020 15:48:09 GMT

It's working now. I deleted my variable and re-added not sure what the issue was.