Skip to main content
A Record value reached workflow trigger watching a Children table's Age column for at least 6 years A Record value reached workflow trigger watching a Children table's Age column for at least 6 years A table document can warn you before a date on a record, such as a licence expiring, or when a value on it is reached, such as a child turning 6. The dates and values can be typed or worked out by a formula column. The reminder itself is a workflow, so you choose who hears about it and how.
Beta
Reminders on formula columns and the Record value reached trigger are rolling out gradually with formula columns. If a workflow’s triggers have no Record value reached, ask us to turn formula columns on.

Track an expiry date

With Full access to the table, open a date column’s menu and turn on Track expiry. Each record then shows Valid, Expiring soon or Expired for that date, and a Record date approaching workflow that names no date column watches it. A table tracks one expiry date. While another column tracks it, Track expiry says which one; turn it off there first. Turning it off keeps the dates.

Remind before a date

1

Start a workflow with Record date approaching

2

Choose the table and the date

Pick the Record type, then the Date column to watch. Beta A formula column that returns a date is listed too, such as a renewal date worked out from a completion date.
3

Set the notice

Enter Days before the date. Left blank, it is 30 days. Activate the workflow.
The workflow fires once for each record, on the morning that many days before its date. If someone edits a record so its date moves, it fires again for the new date, including when the date is worked out by a formula.

Remind when a value is reached Beta

Use Record value reached to hear about a record the day it starts to meet a condition, such as an Age of at least 6 years or a dropdown set to Returned.
1

Start a workflow with Record value reached

Pick the Record type and the Column to watch. Number, dropdown, checkbox and text columns work, and so do formula columns that return one of those.
2

Set the condition

Choose Is at least, Is at most or Is for a number, then the Value. A checkbox takes Ticked or Not ticked. For a formula returning years, months or days, the value is in that unit.
3

Activate the workflow

It checks the table every day at 09:00 and fires for each record that has started to match.
Activating it sends one notice for every record that already matches. After that, a record fires again only once it has stopped matching and then matches again.

Next

Adding a formula column

Work out a date or value to remind on.

Triggers and conditions

Narrow which records a workflow acts on.

Still need help?

Contact support

Email the Begin team and we’ll get back to you.

Ask Begin AI

Open the AI assistant and get instant answers based on these docs.