Goal
Use Countdown ShortPoint to show how many days left for the upcoming event in SharePoint calendar.
Use Case
- We have created calendar list called: Maintenance Schedule
- This list contains the schedule for upcoming maintenance events.
- We want to show how many days left for the upcoming maintenance event
Let's Start
Step 1:
Prepare the Calendar List
- Create new calendar app in your site
- Create the following three columns
Column 1
Name: Day
Type: Calculated (calculation based on other columns)
Formula: =DAY([Start Time])
Start Time is the event start time column
Column 2
Name: Month
Type: Calculated (calculation based on other columns)
Formula: =Month([Start Time])
Column 3
Name: Year
Type: Calculated (calculation based on other columns)
Formula: =CONCATENATE(YEAR([Start Time]))
Step 2:
Create the new view
We need to create new view that will show one upcoming maintenance event- Create new view
- Start from an existing view - All Event
- Give the new view a name: Upcoming Maintenance Event
- Check the box next to the newly created columns: Day, Month and Year
- Sorting: sort by Start Time
- Filter: Start Time is greater than or equal to [Today]
- Item Limit: Set the value to be (1)
- Mobile: Set the value to be (1)
Step 3:
Add new events for testing
Add two upcoming events and one old even
Step 4:
Add Countdown ShortPoint
It's time to see the work in action
- Edit any page
- Add Countdown ShortPoint
- Open Connect tab
- Connect to the new calendar list
- Choose the newly created view
- Open settings tab
- Map Countdown Day with Day Column
- Map Countdown Month with Month Column
- Map Countdown Year with Year Column
Results:
Countdown ShortPoint will be displayed and it will show how many days left for the upcoming maintenance schedule.
How about we show at the top of the calendar a dynamic text that will display the upcoming maintenance event Title?
At the top of countdown shortpoint, insert new ShortPoint and select Templates
Connect the Templates to the same calendar and view
In the Templates Item, add the Event Title with any text you like
Insert to the page
New Results: