- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 03:26 AM
Mail script:-
(function runMailScript(current, template, email, email_action, event) {
template.print(current.variables.property_authorization_card.Type+ '\n\n'+"<br/> Property card Details");
})(current, template, email, email_action, event);
here issue is it provide me the sys id of Type. How to populate name instead of sys id.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 05:08 AM
search on google , you will find plenty of reference regarding the style .
try with below code.
(function runMailScript(current, template, email, email_action, event) {
var arr =[];
var variableArray = JSON.parse(current.variables.property_authorization_card);
for(var i=0; i < variableArray.length; i++) {
var gr = new GlideRecord('table name');
gr.addQuery('sys_id','IN',variableArray[i].Type);
gr.query();
gs.log('Row count'+ gr.getRowCount());
while(gr.next()){
arr.push(gr.name);
}
}
template.print(arr+ '\n\n'+"<br/> Property card Details");
})(current, template, email, email_action, event);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 04:51 AM
If i selected multiple in the form, then how can we modify the code.
With the above code, ti displayed only one in the email notification

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 04:54 AM
give a try to add multiple and see if that is working or not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 04:55 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 04:57 AM
try now.
(function runMailScript(current, template, email, email_action, event) {
var variableArray = JSON.parse(current.variables.property_authorization_card);
for(var i=0; i < variableArray.length; i++) {
var gr = new GlideRecord('table name');
gr.addQuery('sys_id','IN',variableArray[i].Type);
gr.query();
gs.log('Row count'+ gr.getRowCount());
while(gr.next()){
template.print(gr.name+ '\n\n'+"<br/> Property card Details");
}
}
})(current, template, email, email_action, event);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2019 05:03 AM