---
title: Creating an Automated Email Reminder – When a Record is Overdue (Scheduler)
description: "This article shows you how to build a schedule that emails a reminder when something on a record is overdue, for example a risk review that has passed its date, copying in the Risk Admins. > **Applies to:** System administrators…"
url: "https://support.symbiant.co.uk/kb/creating-an-automated-email-reminder-when-a-record-is-overdue-scheduler/"
updated: "2026-10-30"
category: Automated Email Reminders (Time Based)
tags:
  - Add
  - Schedules
---

# Creating an Automated Email Reminder – When a Record is Overdue (Scheduler)

This article shows you how to build a schedule that emails a reminder when something on a record is overdue, for example a risk review that has passed its date, copying in the Risk Admins.

> **Applies to:** System administrators (`admin` role) · **Module:** Set up > Schedules

## Before you start

- Most modules already have shipped overdue reminders named `<module>-...-overdue-generic` (overdue, and overdue by 3, 7, 14 days and 1 month). They arrive inactive. Activating one is often all you need: see [Activating and Deactivating an Automated Email](https://support.symbiant.co.uk/kb/activating-and-deactivating-an-automated-email/).
- The example below matches the shipped `register-risks-risk-review-overdue-generic`.

## Accessing Schedules

1. Click the **Set up** spanner at the bottom left of the screen.
   ![The Set up spanner at the bottom left](https://support.symbiant.co.uk/wp-content/uploads/2026/10/kb-common-setup-spanner-c03de5.png)
2. In the Set up menu, under **Events**, click **Schedules**.
   ![Schedules in the Set up menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/em-schedules-menu-29551b.png)
3. Click the **+** icon at the top right.
   ![The plus icon](https://support.symbiant.co.uk/wp-content/uploads/2026/10/em-add-plus-4d53a9.png)

## Schedule Details

1. In **Name**, enter a name with no spaces, for example `register-risks-review-overdue-company`.
   ![Naming the schedule](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-new-name-6cb9d4.png)
2. Leave **Start** and **End** as they are (both today's date). Changing them can stop the schedule running.
   ![The Start and End dates](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-start-end-5ead84.png)
3. Leave **Active?** unticked while you build and test.

## Setting When the Schedule Runs (Recurring)

The **Recurring** grid sets when the schedule runs. Tick values in the columns **Month**, **Day of Month**, **Day of Week**, **Hour** and **Minute**. Columns left empty mean "every".

> **Critical:** Times are in **UTC** (Coordinated Universal Time), not your local time. Tick at least one **Hour** and/or **Minute**, or the schedule won't run.

### Example 1: The 1st of Every Month at 08:00

Tick **01** under **Day of Month**, **08** under **Hour** and **00** under **Minute**.

![Recurring example: 1st of the month at 08:00](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-recurring-ex1-fd495e.png)

### Example 2: Every Wednesday in September at 10:30

Tick **September** under **Month**, **Wednesday** under **Day of Week**, **10** under **Hour** and **30** under **Minute**.

![Recurring example: Wednesdays in September at 10:30](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-recurring-ex2-de2351.png)

### Example 3: Every 30 Minutes

Tick **00** and **30** under **Minute** and leave the other columns empty.

![Recurring example: every 30 minutes](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-recurring-ex3-27b30e.png)

> **Note:** The shipped due and overdue reminders run once a day at 09:00 UTC (**09** under Hour, **00** under Minute).

## The Function Chain

A schedule's **ƒ chain** works like a trigger's: interceptors run from top to bottom. Click the **+** at the top of the **ƒ chain** panel to add one.

![Adding an interceptor](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-chain-add-545041.png)

The shipped reminder schedules all use this chain, and the steps below follow it:

`query` → `template` (reminder tag) → `tag-filter` → `manager` (optional) → `format-date` → `template` (the email) → `email` → `log` → `tag-record`

## Adding the Query Interceptor

The **query** interceptor finds the records the reminder is about each time the schedule runs. If it finds none, the schedule stops until next time.

1. Add a **query** interceptor and choose the module in **Model**, for example **Register-Risks**.
2. Under **Where**, click **AND** to add a condition, then click the field name to choose the field, for example **Review Date**.
   ![Choosing the field for the condition](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-query-field-8ef6d0.png)
3. Click the operator (for example **equals**) to change it. Options include **date equals**, **is less than**, **is greater than**, **exists?** and **doesn't exist?**.
   ![The operator list](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-query-operator-dcacea.png)
4. Click the value to set the date to compare against.
   ![Setting the date value](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-query-date-621ca0.png)

For an overdue reminder the condition reads **Review Date equals Yesterday**: the day after the date passes, the record is emailed once. For "overdue by 7 days", compare with the date 7 days ago.

![An overdue query](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-query-overdue-439285.png)

For actions, add a second condition so implemented actions are left out. The shipped action reminder checks **Due Date equals Yesterday** AND **Implemented equals false**.

![An overdue action query with two conditions](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-query-action-overdue-dc3848.png)

## Adding the Reminder Tag (template and tag-filter)

A schedule runs again and again, so it needs to remember which records it has already emailed. It does this with a tag.

1. Add a **template** interceptor whose content is a unique tag for each record and day: the opening `{{<query}}`, a name for the reminder, the record reference, `{{date}}` and the closing `{{>query}}`.
   ![The reminder tag template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-tag-template-583108.png)
2. Add a **tag-filter** interceptor and set **Filter data in tag** to that template. Records already tagged are skipped.
   ![The tag-filter interceptor](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-tag-filter-877b36.png)

## Adding the Manager Interceptor (Optional)

To copy in users with a role, such as the Risk Admins, add a **manager** interceptor: **Data source** = **query**, **Attribute** = **generic/owners**, **Role** = for example **risk_admin**. Then add `Cc: {{<generic/owners}}{{<manager}}{{sm.user/name}}, {{>manager}}{{>generic/owners}}` to the email template.

![The manager interceptor in an overdue schedule](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-manager-bbaf25.png)

> **Critical:** Don't choose the plain `admin` role. Use the module role (for example `risk_admin`).

## Adding the Date Format (format-date)

1. Add a **format-date** interceptor so dates in the email read well, for example `dd MMMM yyyy` (21 October 2026).
   ![The format-date interceptor](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-format-date-593732.png)

## Adding the Email Template

1. Add a second **template** interceptor for the email itself: `From:`, `To:`, optional `Cc:`, `Subject:`, a blank line and the body. Wrap it in the data source above it, here `{{<format-date}}` … `{{>format-date}}`.
   ![The email template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-email-template-overdue-a395f0.png)
2. Use the recipient codes from [Editing an Automated Email Reminder – Sending to a Record User (Scheduler)](https://support.symbiant.co.uk/kb/editing-an-automated-email-reminder-sending-to-a-record-user-scheduler/), and markers such as `{{risk/reference}}`, `{{generic/summary}}` and `{{risk/review}}` for record data.

> **Note:** The query returns every matching record. Each record gets its own email when the template is wrapped in the query's data block as above. If you build a template that lists records in one message, end each record's section with `<EOM>` (end of message) to split them into separate emails.

## Adding the Email, Log and tag-record Interceptors

1. Add an **email** interceptor: **Send Email** = the email template, **Send as** = **HTML**.
   ![The email interceptor](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-email-0eb366.png)
2. Add a **log** interceptor: **Log** = **Emails**, a **Log Group** with no spaces (for example `Register-Risks`), and the email template as **Info line template**.
3. Add a **tag-record** interceptor last and set it to the tag template. This records the tag so tomorrow's run doesn't email the same record again.
   ![The tag-record interceptor](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-tag-record-d20ae1.png)

## Saving and Testing

1. Click **Save** at the top right.
   ![The Save button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/translators-save-f3437f.png)
2. To test, make a test record that matches the query, tick **Active?** and save. The schedule runs at its next recurring time.
3. The ▶ (play) button at the top of the **ƒ chain** runs the schedule straight away.
   ![The run button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/sch-run-button-998656.png)

> **Critical:** The ▶ button and an active schedule send real emails to every matching record's recipients, not only your test record. Check the query and the recipients first. Sent emails appear in Set up > **Log viewer**.

## Related articles

- [Creating an Automated Email Reminder – When a Record is Due (Scheduler)](https://support.symbiant.co.uk/kb/creating-a-schedule-record-due-scheduler/)
- [Setting up Recurring Schedules](https://support.symbiant.co.uk/kb/setting-up-recurring-schedules/)
- [What is DE and FA in Email Notifications?](https://support.symbiant.co.uk/kb/what-is-de-and-fa-in-email-notifications/)
