Reminders/notifications for overdue items?

Summary

Demo Database

Example task reminders

🅰️ Button to mark an item “done”

“completing a task” should impact a handful of properties, which is a perfect job for a button property

• mark Status property Done
• record the timestamp the date was Completed
• clear the reminder

🅱️ Re-sync Notification Schedule

(paid) via two handy database automations

see free section below

When you change a due date, update the reminder accordingly.

having a second date field to store the reminder is a great way to decouple the reminder time from the due date. However, manually keeping them in sync is a pain. The Lead Time property is used to maintain a reliable difference between the due date and the reminder, and a Database Automation watches for changes to Due Date and Lead Time in order to maintain the reminder.

The “Sync Reminder to Due Date” automation will maintain the reminder for the number of days prior to the deadline

Push forward overdue reminders

If you miss your deadline, you probably want to keep getting reminders that the getting reminders. A Database automation runs every day and updates reminders that went off yesterday to notify today.

<aside> <img src="/icons/info-alternate_red.svg" alt="/icons/info-alternate_red.svg" width="40px" />

if the reminder isn’t firing on time, you may need to update the logic here a little. as in, “update tasks whose reminder fires today to tomorrow”. I’m not sure what order of operations Notion will A-runs database automations (i think between midnight and 3am) and B-fires notifications (I think around 9am daily)

</aside>

Only edit pages whose reminder fired yesterday (condition 1) and whose due date is in the paste (condition 2) and whose status is incomplete (condition 3)