Help needed with accessing multi row variable set in client script

[Bruler1230]

sorry for the cross post, this was posted in the developer community as well, I just really need to get some traction on this  

I am using a multi row variable set and I need to autopopulate fields based on what is selected in a reference field within the mrvs. I want to do this by using a onChange catalog client script. It looks like that is a little more complicated to do with multi row variable sets. I have found the below but i am looking for some help on how to implement it. The mrvs allows a user to select a name from the reference field (multiple names, not just the current user) and then based on the name they pick, all the following fields will autopopulate. the user name field is referencing the user table.

Step 1 : Create a script include and write your logic for gathering the data from table and push the data into array of objects. Return the array as return JSON.stringify(array); 

Step 2: In your catalog client script, Write the GlideAjax and call the function in the script include creatd in step 1, In the callback function, write below code :

var answer = response.responseXML.documentElement.getAttribute("answer");
answer = JSON.parse(answer);

g_form.setValue('the  name of the multi row variable list',JSON.stringify(answer));

Please let me know if any additional info is needed.

Thanks

[Prateek kumar]

How about you change this line??

g_form.setValue('the  name of the multi row variable list',JSON.stringify(answer));

to

var answer = response.responseXML.documentElement.getAttribute("answer");
returnedData= JSON.parse(answer);

g_form.setValue('the  name of the multi row variable list',returnedData.YourVaribleNameHere);

[Bruler1230]

Thank you for your response. So, one of the things that i am still trying to figure out is what I need to put in the script include (step 1 above). Most of this all new to me, so any help you can provide is appreciated. 

[Prateek kumar]

I replied with all the script you would need in the below thread. Please take a look

https://community.servicenow.com/community?id=community_question&sys_id=52630b25dbd8dbc01dcaf3231f96...

[Bruler1230]

Thank you, i will take a look.