
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2016 07:34 AM
I need to add two users to the CC field of an approval email notification template. I was told to use mail script but not sure how to write the script, any thoughts? The two field I need to add are "Primary Triage" and "Back Up Triage" which both are reference field to the sys_user table.
Thanks,
Edwin
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2016 12:07 PM
If that is the case use this script. MAke sure your field names are correct
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
var ids=current.sysapproval.<primary triage>+','+current.sysapproval.<backup triage>;
var user = new GlideRecord("sys_user");
user.addQuery("sys_id","IN",ids);
user.addQuery("email", "!=", "");
user.query();
while (user.next()) {
//add to cc list
email.addAddress("cc", user.email, user.getDisplayValue());
}
})(current, template, email, email_action, event);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2016 07:44 AM
create a mail script and put this in there
var ids=current.<primary triage>+','+current.<backup triage>;
var user = new GlideRecord("sys_user");
user.addQuery("sys_id","IN",ids);
user.addQuery("email", "!=", "");
user.query();
while (user.next()) {
//add to cc list
email.addAddress("cc", user.email, user.getDisplayValue());
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2016 07:55 AM
Thank you.. The name of the email script is "triage_users_email". Where do I need to add this is get the names in the CC field?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2016 08:06 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2016 08:45 AM
How did you add the script tag to the body? Post a screenshot of notification and email script