How to take string values from multi-row variable set to populate the Watch List on an incident

[patricklatella]

Hi all,

this should be easy I would think, but something isn't working.  I have a record producer with a mult-row variable set with one variable (single line text) for capturing email addresses to be added to the incident's Watch List when the record producer is submitted.

How do I access the values in the multi-row variable set to populate the Watch List?  In the RP script i'm going with:

current.watch_list = producer.name_of_variable_in_variable_set; //variable in the variable set

Guessing there must be more to it?

thanks!

[Brad Bowman]

See this article for some things I have been able to do to get the values from a MRVS. RP scripts behave like server scripts, so this should be on the easier side.

https://community.servicenow.com/community?id=community_article&sys_id=5ebe74c0db2f00905129a851ca961...

[patricklatella]

Thanks Brad, I'll check it out.  I would think this would be easy...just need to find the script.  

[Ankur Bawiskar]

Hi Patrick,

you can get the value; parse it and then set the value in watch_list

I assume your json looks like this:

[
{
"email": "amy.jone@example.com"
},
{
"email": "abel.tuter@example.com"
}
]

Script for this: ensure you add the proper json key and the variable name

var str = producer.name_of_variable_in_variable_set;

var parser = JSON.parse(str);

var length = parser.length;
var emailArray = [];

for(var i=0;i<length;i++){
emailArray.push(parser[i].email.toString());
}

current.watch_list = emailArray.join(',');

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

[patricklatella]

Hi Ankur,

thanks for the response.  How do I add the proper JSON key?