Help with notification

RudhraKAM · ‎07-07-2018

I have a requirement where we created a table XYZ and a record producer , when the record producer is submitted the record will be inserted in the the table XYZ , when ever a new record is inserted, we need to send a notification to a group ,

if user is John who submitted the record producer , we need to get john's email address and send message from that, not from default ServiceNow address. and cc the user too

and If a record has an attachment, send the attachment along with the outbound message.

How do we achieve this ?

Thanks in advance

Arindam Ghosh · ‎07-09-2018

It worked for me. Here is the Code I tested:

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
 /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
 /* Optional GlideRecord */ event) {


email.setFrom(current.opened_by.name+" <"+current.opened_by.email+">");

printattachments();
 
function printattachments(){
 var gr =new GlideRecord('sys_attachment');
 gr.addQuery('table_sys_id',current.sys_id);
 gr.query();
 while(gr.next()){
 template.print('Attachment: <a href="http://'+gs.getProperty("instance_name")+'.service-now.com/sys_attachment.do?sys_id='+ gr.sys_id+'">'+ gr.file_name+'</a>');}
}


})(current, template, email, email_action, event);

View solution in original post

pradeep37 · ‎05-12-2022

Hi Arindam,

this answer is relevant , but my requirement is to attach excel in the notification (so the user can download the excel and make some appropriate changes and revert back), not the link attachment(by link it redirect user to instance).

please suggest.

Thanks

Pradeep sharma