# Use Case: One District Calendar From Every School's List

Source: [https://docs.virtosoftware.com/docs/calendar-overlay-pro/working-with-virto-calendar/use-case-district-calendar-from-school-lists/](https://docs.virtosoftware.com/docs/calendar-overlay-pro/working-with-virto-calendar/use-case-district-calendar-from-school-lists/)
Product: Virto Calendar App
Updated: 2026-10-23


This use case shows how a school district, or any organisation with several units that keep their own event lists, builds one calendar from those lists without copying them, puts it on an intranet page and emails the coming week's dates once a week.

[Open the interactive demo](https://app.storylane.io/demo/arrn4kgf4w4g)

**Interactive demo walkthrough**
1. One district, one calendar — Each school keeps its own SharePoint list. The district sees them all in one calendar, on its intranet and in a Friday email.
2. Each school keeps its own SharePoint list, and the district office keeps one more. The District calendar reads all four without copying them, each in its own colour.
3. November for the whole district: district dates in red, each school in its own colour. The grade 4 field trip falls inside the benchmark testing week.
4. The legend is the filter: with two schools switched off, Northside's principal sees the school's events next to the district dates. One more click brings them back.
5. The same calendar as a web part on a district intranet page: one calendar, Month view, no calendar picker. Audience Targeting decides who sees it.
6. Next week in the district: every Friday at 14:00, one email lists the district dates of the coming week, instead of one email per date.
7. Put every school on one calendar — Virto Calendar App and Virto Alerts & Reminder App run in your Microsoft 365 tenant; each school's events stay in its own SharePoint list.

## What you need

- **Virto Calendar App**, and **Virto Alerts & Reminder App** for the weekly email.
- One SharePoint events list per school, kept by the school, and one list for the district office's closures, board meetings and testing windows. Each list needs a title, a start and an end column.
- A SharePoint page on the district intranet.

## Step 1. Add every list as a data source

1. Create a calendar for the district and open its settings by clicking the calendar name.
2. Add each school's list and the district office's list as SharePoint data sources. See [Adding a New Data Source](https://docs.virtosoftware.com/docs/calendar-overlay-pro/data-sources/sharepoint-list-as-a-data-source/adding-a-new-data-source/index.md). A list can stay on its school's own site: the data source takes the site address.
3. Give each source its own colour, for example the district office in dark red and each school in a colour of its own.
4. Tick **Read only** for the schools' lists if the district office should see their events without editing them.

The calendar reads the lists; each event stays an item of its school's list.

## Step 2. Use the legend as a filter

The legend above the calendar names every source. Clicking a school hides or shows its events, so a principal can look at one school next to the district dates. A school that is switched off stays in the legend, and one more click brings its events back.

## Step 3. Publish the calendar on the intranet

1. Add the Virto Calendar web part to the intranet page. See [Adding Virto Calendar App to the Site Page](https://docs.virtosoftware.com/docs/calendar-overlay-pro/installation-and-configuration/adding-virto-calendar-app-to-the-site-page/index.md).
2. Set the web part to the district calendar and the view staff should see first. See [Choosing a Specific Calendar for a Site Page](https://docs.virtosoftware.com/docs/calendar-overlay-pro/installation-and-configuration/choosing-a-specific-calendar-for-a-site-page/index.md).
3. In **Audience Targeting**, pick the users or groups who should see the web part. Audience Targeting controls what the page shows, not who may open the lists.

## Step 4. Email next week's district dates every Friday

Create a reminder on the district office's list ([how to create a reminder](https://docs.virtosoftware.com/docs/alerts-and-reminders-by-virto/configuration-and-usage/creating-a-reminder/index.md)):

- **Options** → **Use condition(s)**: **Start** greater than **[Today]+1** and **Start** less than **[Today]+8**. Values counted from today are explained in [Options](https://docs.virtosoftware.com/docs/alerts-and-reminders-by-virto/configuration-and-usage/creating-an-alert/options/index.md#dates-counted-from-today).
- **When To Send Alerts**: **Send a weekly summary**, Friday, at the hour you choose.
- **Message view**: one table with the date, the event and a link to the item. See [How to merge summary alerts in one alert with a table](https://docs.virtosoftware.com/docs/alerts-and-reminders-by-virto/configuration-and-usage/special-options-for-an-alert-or-reminder-message/how-to-merge-summary-alerts-in-one-alert-with-a-table/index.md).
- **Recipients**: the people or SharePoint groups who should receive it, such as all district staff.

Staff then get one email on Friday with every matching date instead of one email per date.

## What the apps do not do

The calendar shows events and closures. Class timetables, attendance and grade books stay in the student information system, and parents booking a conference slot is a job for a booking tool such as Microsoft Bookings.