Add Multiple Event Fields on a Calendar Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2019 01:23 PM
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
- Labels:
-
Request Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2019 11:12 AM
Hi Dan R - Was wondering if you found a solution/workaround to this?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2019 11:46 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2022 05:50 PM
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