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
Build it as in Build and activate a workflow.
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.
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 toReturned.
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.