Add Multiple Event Fields on a Calendar Report

Dan R
Kilo Expert

I have a request to set up 2 date/time fields on a catalog item request form, 1 for "Start Date" and 1 for "End Date" for a particular type of "outage/maintenance/work window".

The business would like this displayed on a "Calendar" so they can view all the requests and "windows" in 1 view.

 

The change calendar seems like it could work but would need a bit of configuration on my part to make work. I noticed that the Reporting section allows you to create a Calendar Report and specify an "Event field to use" to show a timespan of the event.  This seems like it would be a wonderful location to allow someone to enter a "Start Time" field and an "End Time" field and build the "window" to show on the calendar accordingly.

 

My issue here is that when I go to the report and try to create a calendar report, I'm only given the option to add a single Event field to the report and not the start and end date that I was hoping for.

 

Anyone have any thoughts or suggestions on how to get a calendar populated with more than 1 event?

 

 

Thanks in advance for any advice or attempts at this one.

 

DR

 

 

 

 

3 REPLIES 3

YT
Kilo Contributor

Hi Dan R - Was wondering if you found a solution/workaround to this? 

 

Thanks!

Dan R
Kilo Expert

you can add additional related definitions for the change calendar as well as define style rules. It was an annoying process to set up but it eventually showed the information I wanted.

Andrew Marmara
Giga Contributor

I realise this is an old post but this should help:

https://docs.servicenow.com/bundle/quebec-now-intelligence/page/use/reporting/task/t_CustomizeAStartAndEndDate.html