When a date field arrives is a trigger that starts an automation when a date in a record is reached, on the day itself or a number of days, weeks, or months before or after (the trigger decides when an automation starts, and the filter decides whether it continues). It's meant to help you remind people of deadlines without checking dates by hand.
You can use this trigger for many things, including:
Reminding the assignee three days before a task's due date.
Emailing a tenant a week before a lease ends.
Note:
It runs once for every record whose date arrives. Each record keeps its own date, so one automation covers all records in the database app.
You choose the time of day. The automation runs at the time you set, for example 8:00 AM.
A manual run doesn't wait for the date. It runs the automation right away on the records you choose.
A month counts as 30 days.
Months beforeandMonths afteradd or subtract 30 days per month, not calendar months.Records that are still being created don't count. A record starts the automation only once it has been created.
Who can use the When a date field arrives trigger?
Automations are available on the Free, Plus, and Premium plans. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.
To create, edit, pause, run, or delete automations, you need to be a
Workspace adminin the workspace the database app belongs to. Only workspace admins see the automations icon in a database app.
Set up the When a date field arrives trigger
To set up the trigger:
Open the database app on desktop or web and click the automations icon in the top bar (tooltip
Create and view automations).Select
New automation.Select
When a date field arrivesfrom the list of events.Select the parts of the trigger to choose when it runs, the date to watch, and the time of day. Learn more about the date and the time below →
Add a filter if the automation should only continue for certain values. Learn more about filters below →
Select
Add actionand choose what should happen.Select
Create automation.
Choose the date and the time
The trigger reads like a sentence: On day when Date arrives at 8:00 AM in {app}. Select each part to change it:
On daysets when the automation runs. ChooseOn dayto run on the date itself, orDays before,Days after,Weeks before,Weeks after,Months before, orMonths after. Then pick the number from the list, for example3 days. You can choose 1 to 30 days, 1 to 10 weeks, or 1 to 12 months. The trigger then reads, for example,3 days before.Date(the field name) sets the date to watch. You can watch:a date field,
the start date or the end date of a date range field,
a calculation field that results in a date,
the date the record was created (
Created at),the date the record was last changed (
Last modified at).8:00 AMsets the time of day. You can choose any time in 15-minute steps, from 12:00 AM to 11:45 PM.
Tip: For a reminder, use a few days before the date. To follow up on something overdue, use a few days after it.
Filter the When a date field arrives trigger
The filter decides whether the automation continues after it's been triggered. Under And if the following conditions are met, select Add filter and build a condition, for example Status Is not Done, so people aren't reminded of finished tasks. Learn more about filters →
Let's look at an example
Let's say you want to remind the team three days before a task is due. Here's how:
Set the trigger to
When a date field arriveswith theDue datefield,Days before→3 days, at8:00 AM, inTasks.Add the filter
WhereStatusIs notDone.Select
Add action→Add comment, then enter "This task is due in three days: " and insert theTitlefield.Select
Create automation.
Three days before each due date at 8:00 AM, you should see the comment on the task!
Dates and time zones
The automation runs at the time you set. Each automation has its own time zone. It starts with the time zone of the person who creates the automation. To change it, hover over the automation's name in the editor and select Time zone above it. Learn more about dates and time zones →
When a date field arrives errors
If the date field is empty for a record, the automation doesn't run for that record. There's no error.
If you change the date of a record later, Tape plans the run for the new date instead. If the new date is already in the past, the automation doesn't run for it.
If the status below the automation's name shows
Brokenin red, part of the automation doesn't fit the trigger, often an action that needs a current record. The part that doesn't fit is shown in red. While the automation isBroken, it doesn't run and you can't start a manual run. Tape then showsTrigger runs manually not possible because of broken automation.If a run fails, you can see each step and its message in the automation's runs. To see the runs of an automation, click
▷next toManual runat the top right of the editor (tooltipView all runs), or presscmd/ctrl+1. TheRunspanel lists the runs of the last 30 days. Select a run to see each step and its message. To see the runs of all automations, selectRunsin the sidebar of the Automation Center.Lots of automation activity in a short time can delay automations across your organization. The delay is temporary. Tape checks the load again shortly and runs waiting automations automatically. Learn more about limits and throttling →
Test, pause, edit, or delete an automation with this trigger
Manual runruns the automation once on the records you choose, no matter what their date is. It has real effects, so the comment from the example is posted. Learn more about testing →New automations you create in the editor are
Activeright away. To pause one, selectActivebelow the automation's name, then selectSave changes. The status switches toPaused. Select it again and save to turn the automation back on.To edit an automation, open the database app, click the automations icon in the top bar (tooltip
Create and view automations), then select the automation. SelectSave changeswhen you're done.To delete an automation, open it and click
•••at the top right, then selectDelete. Confirm withDelete. You can also click•••on the automation's card in the list of automations, then selectDelete. Deleting can't be undone.To switch to another trigger, hover over the trigger and click
•••to the right of it, then selectTurn intoand choose a trigger. The filter and the actions stay. If an action or a filter condition doesn't fit the new trigger, for exampleUpdate recordafter switching to a schedule, orHas changedafter switching away fromWhen a record is updated, the status below the automation's name turns red and showsBrokenuntil you change or remove it.
Learn more
FAQs
How do I send a reminder before a deadline?
How do I send a reminder before a deadline?
Choose the deadline field, choose Days before with a number of days, and pick the time of day. Then add an action such as Add comment or Send email.
Can I run the automation on the date itself?
Can I run the automation on the date itself?
Yes! Choose On day.
Can I run it again every week or month?
Can I run it again every week or month?
No, this trigger runs once per date and record. For a report that repeats, use Trigger on a schedule →.
Can I use a date range?
Can I use a date range?
Yes! Choose a date range field, then choose whether the start date or the end date counts.
Can I run it at a certain time of day?
Can I run it at a certain time of day?
Yes! Select the time in the trigger, in 15-minute steps.
Are there other triggers I can use?
Are there other triggers I can use?
Yes! An automation can start when a record is created, updated, or deleted, when a comment is added, when a date arrives, on a schedule, and more. See every trigger in Automation triggers →
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: Triggers in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
