To-Do List Template — A To-Do List That Already Knows What's Overdue the Moment You Open It

You should not have to scan every row in your task list to figure out what needs attention right now. Yet every to-do list template on the internet is just a blank table with a checkbox column — a static grid that tells you nothing you did not already know.

The OpenSource AI Pro To-Do List / Personal Task Tracker is different. Formula fields evaluate every task's due date against today the moment the page loads. Overdue items flag themselves. Priority views sort your work by urgency without you dragging cards around. And if you want notifications, event-triggered alerts email you when a task crosses into overdue territory. Self-hosted on Baserow, zero per-seat fees, open source — the simplest template in the collection, but it still thinks for itself.

Key Features

• Overdue Auto-Flag — A formula compares each task's due date to today. Past due and not complete? The flag appears instantly. No manual triage, no missed deadlines hiding at the bottom of the list.

• Priority + Due Date Views — Pre-built views sort tasks by priority level and due date, so you always see what matters most first. Switch between "Today," "This Week," and "All Tasks" without building filters from scratch.

• Event-Triggered Overdue Alert — When a task crosses from on-time to overdue, an automation sends a single email notification. It fires once per task and re-arms if you extend the deadline.

• Simple Category Tagging — Organize tasks by project, context, or area of life. Filter views by tag to focus on work, personal, or any custom grouping you define.

• Completion Tracking — Check a task complete and it moves out of active views automatically. A completed-tasks archive keeps your history without cluttering your daily view.

• Zero Per-Seat, Self-Hosted — Runs on your own Baserow instance. Share with your household, your team, or keep it personal. No subscription, no row limits.

How It Works

Formula Flags

The to-do list uses a single powerful formula pattern:

• Overdue Flag: IF(AND(Due_Date < TODAY(), Status != "Complete"), TRUE, FALSE). That is all it takes. Every time the page loads, every task is evaluated. Overdue items surface immediately.
• Days_Overdue: A formula computing how many days past due a task is, adding urgency context to your daily planning.
• Priority Score: Combines user-set priority (High / Medium / Low) with days until due to create a computed sort order.

Event-Triggered Alerts

When the Overdue flag changes from false to true — either because a due date passes or because you set a due date in the past — an automation fires a one-time email. The email includes the task name, original due date, and how many days overdue it is. Clear the flag by completing the task or extending the deadline, and the system re-arms.

Views That Do the Sorting for You

• Today View: Filters to tasks due today or overdue, sorted by priority
• This Week View: Everything due within seven days
• By Priority View: High > Medium > Low, with overdue items pinned to the top
• Completed Archive: All finished tasks, sorted by completion date

Who It's For

• Individual Contributors who want a personal task system that actually surfaces what is urgent
• Freelancers and Solopreneurs managing client deliverables, admin tasks, and personal to-dos in one place
• Students tracking assignments, project deadlines, and exam prep with automatic overdue alerts
• Small Teams that need shared task visibility without paying for Asana or Todoist
• Anyone Tired of Spreadsheet To-Do Lists that require manual scanning to find overdue items

This is a funnel entry point — the simplest use case in the collection. Start here, and when your needs grow, upgrade to the Operational Project Tracker or Goals & OKR Tracker without switching platforms.

vs the Alternatives

| Feature | OpenSource AI Pro | Todoist | Microsoft To Do | Notion To-Do | |---|---|---|---|---| | Auto overdue flags | Formula-driven, instant | Due date highlighting only | Basic overdue badge | Manual property | | Email alerts | Event-triggered on state change | Push notifications (app required) | Push notifications (app required) | No native alerts | | Self-hosted | Yes — your data, your server | No | No | No | | Cost | $0 forever | $4-6/user/month (Pro) | Free (Microsoft ecosystem) | $8-15/user/month | | Customization | Full — open source | Limited | Limited | Moderate | | Scales to project tracking | Same platform, bigger template | Different tool needed | Different tool needed | Rebuild from scratch |

What's Included

Tables

• Tasks — Name, description, due date, priority, status, category/tag, Overdue flag, Days_Overdue, assignee (optional)

Formula Fields

• Overdue — Automatic date comparison against today
• Days_Overdue — Count of days past due date
• Priority_Score — Computed sort order combining priority and urgency

Views

• Today, This Week, By Priority, Completed Archive

Automations

• Event Alert: Fires when a task becomes overdue, emails the assignee
• Daily Digest (optional): Morning summary of all overdue and due-today tasks

Get Started Free

Download the To-Do List template and deploy it on your own Baserow instance. Your simplest path to task tracking that actually works. No sign-up, no seat fees, no data leaving your server.

Download Template — Free, Self-Hosted

Related Templates

• Operational Project Tracker — When your to-do list grows into multi-phase projects with team assignments
• Meeting Agenda & Minutes — Turn meeting action items into tracked tasks with overdue flags
• Goals & OKR Tracker — Connect daily tasks to quarterly objectives with auto-computed progress