Hi Folks,
This article explains how to generate iCalendar attachments in Service Now and send it over as an attachment in email notifications. I came across this requirement and could find any solution over the internet, so I decided to build my own solution.
The actions begins below.....
iCalendar attachments are basically outlook meeting invites attachment that contains details for meeting such as "Meeting Start Date Time", "Meeting End Date Time", "Meeting URL for Joining meeting", "Location" , "Description", etc.
Below is the screenshot of the icalendar attachment in an Email.
When the attachment is opened it contains meeting details as shown below.
I am able to generate the ICS attachment using a script include. I am also maintaining a table that contains the meeting the details specific for the meeting. The snapshot of a record in the table along with the generated attachment is below.
The Script that generates the attachment is below
var ICS_SNOW_AttachmentGenerator = Class.create();
ICS_SNOW_AttachmentGenerator.prototype = {
initialize: function() {
},
_formatDate: function(dateunformatted){
var formDate = dateunformatted+"";
formDate = formDate.replace(/\-/g,"");
formDate = formDate.replace(/\s+/g,"T");
formDate = formDate.replace(/\:/g,"");
formDate = formDate + "Z";
return formDate;
},
/*
GRObj is the GlideRecord Object of the record in my custom table containing the details of the meeting.
*/
payloadGen: function(GRObj){
var startDate = this._formatDate(GRObj.meeting_start_date_time);
var endDate = this._formatDate(GRObj.meeting_end_date_time);
var payload = "";
payload += "BEGIN:VCALENDAR\r\n";
payload += "VERSION:2.0\r\n";
payload += "PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN\r\n";
payload += "METHOD:REQUEST\r\n";
payload += "BEGIN:VEVENT\r\n";
var attendees = GRObj.meeting_attendees;
var attendees_list = attendees.split(',');
if(attendees_list.length > 0){
for(var i = 0; i < attendees_list.length; i++){
payload += "ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:" + attendees_list[i] + "\r\n";
}
}
payload += "ORGANIZER:MAILTO:teamXYZ@example.com" + "\r\n"; // The ORGANISER tag is generally used to override the email address where the responses will be send, when replied by the attendees for the invites received by them. Moreover, if the value of ORGANISER tag is set then the recipients will receive mails fromm the value mentioned in the organizer tag.
payload += "DTSTART:" + startDate + "\r\n";
payload += "DTEND:" + endDate + "\r\n";
payload += "LOCATION:India VRoom" + "\r\n"; // you can use variable, if you are maintaining VRooms for your meetings;
payload += "TRANSP:OPAQUE" + "\r\n";
payload += "UID:" + new GlideEmailWatermark().optionallyRandomize(GRObj.u_number) + "\r\n";
payload += "DTSTAMP:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
payload += "DESCRIPTION:You are requested to join the meeting for the discussion of XYZ Request\r\n"; //provide your own mwssage or populate using variables.
payload += "SUMMARY:Meeting Invite for XYZ Request\r\n";
payload += "PRIORITY:5\r\n"; // can take values from 0 to 9 "0 to 4 HIGH Priority, 5 MODERATE PRIORITY, 6 to 10 LOW PRIORITY".
payload += "X-MICROSOFT-CDO-IMPORTANCE:1\r\n"; //can take values from 0 to 2. Specifies the importance of an appointment.
payload += "CLASS:PUBLIC\r\n";
payload += "BEGIN:VALARM\r\n";
var alarm_time = 10;
payload += "TRIGGER:-PT" + alarm_time +"M\r\n"; // The TRIGGER take values in MINUTES and the VALARM EEVENT triggers a reminder message on the recipients screen 10 minutes before meeting start.
payload += "ACTION:DISPLAY\r\n";
payload += "DESCRIPTION:Reminder\r\nEND:VALARM\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
gs.info(payload);
var gAttach = new GlideSysAttachment();
gAttach.write(GRObj, "Meeting_Invite[" + new GlideDateTime().getValue() + "].ics", 'text/calendar', payload);
},
type: 'ICS_SNOW_AttachmentGenerator'
};
Once the attachment is generated and attached to your meeting record the road is simple and easy. In order to send the attachment on an email, go to Notification Module > Create a Notification and in "What it will Contain" tab, check the "Include Attachment" checkbox. Show your creativity in HTML box for your email and give it a personalize touch.
Enjoy....
This solution doesn't make use of Service Now ICS field maps templates and being restricted to plain text only. It allows you to freely include HTML in your meeting invites and build your custom meeting invites attachments.
Hi,
here i have same kind of request.
we have created TimeOff request(catalog item) with Planned StartDate: 20-03-2019 Planed EndDate : 27-03-2019
iCalender should be like invitation attachment in Mail with Start and End Dates
if I requested Monday the 18th off
coming to attachment level just thinking about that one only
the ics file should be for 8-5 eastern time that I can just add to my calendar
or if it's half day or whatever
Any suggestions please
Catalog item
Notification:
How to do same kind of customisation on my customisation table. How to send meeting invitation from servicenow to Outlook mail.
My customisation table : Sales (u_saled)
Fields Requesting for, startDate(u_start_date) EndDate(u_end_date) Short Description
When record was created with all fields information send mail to Request for Outlook mail id with a iCalendar invitation attachment
So How can we generate ICS attachment which is nothing but a meeting invite attachment that in "OUTLOOK".
I have used your script like this, where I need to call table name in script?
Where I need to call script include??
Script Include:
var ICS_SNOW_AttachmentGenerator = Class.create();
ICS_SNOW_AttachmentGenerator .prototype = {
initialize: function() {
},
_formatDate: function(dateunformatted){
var formDate = dateunformatted+"";
formDate = formDate.replace(/\-/g,"");
formDate = formDate.replace(/\s+/g,"T");
formDate = formDate.replace(/\:/g,"");
formDate = formDate + "Z";
return formDate;
},
/*
GRObj is the GlideRecord Object of the record in my custom table containing the details of the meeting.
*/
payloadGen: function(GRObj){
var startDate = this._formatDate(GRObj.u_start_date);
var endDate = this._formatDate(GRObj.u_end_date);
var payload = "";
payload += "BEGIN:VCALENDAR\r\n";
payload += "VERSION:2.0\r\n";
payload += "PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN\r\n";
payload += "METHOD:REQUEST\r\n";
payload += "BEGIN:VEVENT\r\n";
var attendees = GRObj.meeting_attendees;
var attendees_list = attendees.split(',');
if(attendees_list.length > 0){
for(var i = 0; i < attendees_list.length; i++){
payload += "ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:" + attendees_list[i] + "\r\n";
}
}
payload += "ORGANIZER:MAILTO:teamXYZ@example.com" + "\r\n"; // The ORGANISER tag is generally used to override the email address where the responses will be send, when replied by the attendees for the invites received by them. Moreover, if the value of ORGANISER tag is set then the recipients will receive mails fromm the value mentioned in the organizer tag.
payload += "DTSTART:" + startDate + "\r\n";
payload += "DTEND:" + endDate + "\r\n";
payload += "LOCATION:India VRoom" + "\r\n"; // you can use variable, if you are maintaining VRooms for your meetings;
payload += "TRANSP:OPAQUE" + "\r\n";
payload += "UID:" + new GlideEmailWatermark().optionallyRandomize(GRObj.u_number) + "\r\n";
payload += "DTSTAMP:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
payload += "DESCRIPTION:You are requested to join the meeting for the discussion of XYZ Request\r\n"; //provide your own mwssage or populate using variables.
payload += "SUMMARY:Meeting Invite for XYZ Request\r\n";
payload += "PRIORITY:5\r\n"; // can take values from 0 to 9 "0 to 4 HIGH Priority, 5 MODERATE PRIORITY, 6 to 10 LOW PRIORITY".
payload += "X-MICROSOFT-CDO-IMPORTANCE:1\r\n"; //can take values from 0 to 2. Specifies the importance of an appointment.
payload += "CLASS:PUBLIC\r\n";
payload += "BEGIN:VALARM\r\n";
var alarm_time = 10;
payload += "TRIGGER:-PT" + alarm_time +"M\r\n"; // The TRIGGER take values in MINUTES and the VALARM EEVENT triggers a reminder message on the recipients screen 10 minutes before meeting start.
payload += "ACTION:DISPLAY\r\n";
payload += "DESCRIPTION:Reminder\r\nEND:VALARM\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
gs.info(payload);
var gAttach = new GlideSysAttachment();
gAttach.write(GRObj, "Meeting_Invite[" + new GlideDateTime().getValue() + "].ics", 'text/calendar', payload);
},
type: 'ICS_SNOW_AttachmentGenerator '
};
So any suggestion here please
Script include:
var ICS_SNOW_AttachmentGenerator = Class.create();
ICS_SNOW_AttachmentGenerator .prototype = {
initialize: function() {
},
_formatDate: function(dateunformatted){
var formDate = dateunformatted+"";
formDate = formDate.replace(/\-/g,"");
formDate = formDate.replace(/\s+/g,"T");
formDate = formDate.replace(/\:/g,"");
formDate = formDate + "Z";
return formDate;
},
/*
GRObj is the GlideRecord Object of the record in my custom table containing the details of the meeting.
*/
payloadGen: function(GRObj){
var startDate = this._formatDate(GRObj.u_start_date);
var endDate = this._formatDate(GRObj.u_end_date);
var shortdescri = this.getParameter(GRObj.u_short_description);
var req=this.getParameter(GRObj.u_requested_for);
var payload = "";
payload += "BEGIN:VCALENDAR\r\n";
payload += "VERSION:2.0\r\n";
payload += "PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN\r\n";
payload += "METHOD:REQUEST\r\n";
payload += "BEGIN:VEVENT\r\n";
//var attendees_list = attendees.split(',');
// if(attendees_list.length > 0){
// for(var i = 0; i < attendees_list.length; i++){
payload += "ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:" + req + "\r\n";
// }
// }
//payload += "ORGANIZER:MAILTO:teamXYZ@example.com" + "\r\n"; // The ORGANISER tag is generally used to override the email address where the responses will be send, when replied by the attendees for the invites received by them. Moreover, if the value of ORGANISER tag is set then the recipients will receive mails fromm the value mentioned in the organizer tag.
payload += "DTSTART:" + startDate + "\r\n";
payload += "DTEND:" + endDate + "\r\n";
payload += "LOCATION:India VRoom" + "\r\n"; // you can use variable, if you are maintaining VRooms for your meetings;
payload += "TRANSP:OPAQUE" + "\r\n";
payload += "UID:" + new GlideEmailWatermark().optionallyRandomize(GRObj.u_number) + "\r\n";
payload += "DTSTAMP:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
payload += "DESCRIPTION:You are requested to join the meeting for the discussion of XYZ // Request\r\n"; //provide your own mwssage or populate using variables.
payload += "SUMMARY:"+ shortdescri +"\r\n";
payload += "PRIORITY:5\r\n"; // can take values from 0 to 9 "0 to 4 HIGH Priority, 5 MODERATE PRIORITY, 6 to 10 LOW PRIORITY".
payload += "X-MICROSOFT-CDO-IMPORTANCE:1\r\n"; //can take values from 0 to 2. Specifies the importance of an appointment.
payload += "CLASS:PUBLIC\r\n";
payload += "BEGIN:VALARM\r\n";
var alarm_time = 10;
payload += "TRIGGER:-PT" + alarm_time +"M\r\n"; // The TRIGGER take values in MINUTES and the VALARM EEVENT triggers a reminder message on the recipients screen 10 minutes before meeting start.
payload += "ACTION:DISPLAY\r\n";
payload += "DESCRIPTION:Reminder\r\nEND:VALARM\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n";
gs.info(payload);
var gAttach = new GlideSysAttachment();
gAttach.write(GRObj, "Meeting_Invite[" + new GlideDateTime().getValue() + "].ics", 'text/calendar', payload);
},
type: 'ICS_SNOW_AttachmentGenerator '
};
Suggest me please where i am doing wrong here.
could you like to check in my instance, i can provide credentials
dev49888 - abel.tuter / 1234
From UI Action
Not showing any meeting name here, So to achieve this what we do?
For Example:i would like to see as below screenshot
before coming to check your article , i seen this link
i got errors , for this i raised
https://community.servicenow.com/community?id=community_question&sys_id=f604ae0cdb5cf7c05129a851ca961993
Result is below:
Pic in my Gmail account:
Pic from : Outlook
i think we need to add Template in Email Template field.am i right please?
what are the steps we are following here
1.Script Include
2. UI Action
3.Event Registry
4. Meeting Invites for Sales (notification)
am i right please?
Of course, if you are using the method which ServiceNow describes in docs, then definitely you need to include the meeting template in your Notifications, and your notification type should be also Meeting Invitation
Hi Pooja,
The "Add to Calendar" button is already there in Outlook Web Clients, and for Outlook app it shows when you double click on the attachment. For me, it does ask for "Add to Calendar". I tried using both outlook web client and outlook app. Below are the screenshots of the same
In OUTLOOK WEB CLIENT hover over the icon, in left of the drop down icon, as shown in the highlighted part of the image below. It says "Add to Calendar".
OUTLOOK WEB CLIENT: WHEN DOUBLE CLICKED on the Meeting Invite attachment file, a popup opens providing a button on top to add it to the calendar.
OUTLOOK APP: POPUP when double-clicked on attachment file
Also confirm, whether the "Include Attachments" checkbox is checked in your notification or not.
Hi Pooja,
The notification record wasn't properly configured. It should be of TYPE: EMAIL as it is bearing an attachment and Content Type: HTML and Plain Text as shown below in the screenshot.
It worked properly after this and no change in code was made. See the screenshot below and check your mail as well. Also ensure that your record on wu_appointment table has no duplicate attachments.
Once confirmed with the solution, don't forget to edit your personal dev password.
Thanks & Regards,
Rupam
