Hello,
We have a custom field users and also we have new email address. If we enter any external email address and if we select any users in watch list need to send notification and add these users as ''CC'' in email notification.
I have written below mail script and not working. I have added screenshots please check and give suggestions
Hey @Rakesh50, here's a full blown script block you can insert inside of your mails script to add both users, as well as external email address to the CC field. I have broken it up to sections and added comments so you can follow what it does,, and change it to your needs as required.
I have tested and it's working as expected (make sure the list field name, e.g. u_users is correct!).
try {
/* Create an array from the user list values */
var getListusers = current.u_users.split(',');
/* Create a separate array with email addresses using RegEx */
var r = new RegExp('([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.[a-zA-Z0-9_-]+)', 'jgi');
var emailArr = getListusers.filter(function(x) {
return x.match(r) ? true : false;
});
/* Reduce the original array to users only */
var arrayUtil = new ArrayUtil();
var userArr = arrayUtil.diff(getListusers, emailArr);
/* Add users to CC */
var userGr = new GlideRecord('sys_user');
userGr.addEncodedQuery('sys_idIN' + userArr + '^notification=2^emailISNOTEMPTY');
userGr.query();
while (userGr.next()) {
email.addAddress('cc', userGr.email, userGr.getDisplayValue());
}
/* Add email addresses to CC */
var emailAddress = '';
for(i = 0; i < emailArr.length; i++) {
emailAddress = emailArr[i].toString();
email.addAddress('cc', emailAddress);
}
} catch(err) {
gs.log('users_to_cc mail script failed: ' + err);
}
Here are some screenshots too.
- Calling the mail script from the notification records body (inn may case, the mail script is called 'users_to_cc', make sure you use the correct name):
- Populated CC field in the email record:
@Siddhesh Gawade Yes you are correct. I have tried same code which is similar to your code. But not works. Because users list type field returning sys_id. I have noticed that in logs. Tried below code
if(!current.u_users.nil()){
var watcherIds = current.u_users.split(",");
gs.log("watcherIds-->"+watcherIds);
var user = new GlideRecord("sys_user");
user.addQuery("sys_id", watcherIds);
user.addQuery("notification",2);
user.addQuery("email","!=","");
user.query();
while(user.next()){
email.addAddress("cc", user.email, user.getDisplayValue());}}
