Weekly Schedule / Time-Block Planner: Add a Block That Overlaps an Existing One and Watch the Double-Booked View Light Up

Target Keyword: weekly planner template Secondary Keywords: time-block planner, weekly schedule template, time blocking template, schedule planner Vertical: HR & People Ops / Productivity Word Count: ~1,050

Time blocking works — until you accidentally schedule a client call over your deep work session and do not realize it until the calendar notification fires for both at 2pm. Most weekly planner templates are grids where you type activities into time slots. They show you what you planned. They never tell you when your plan contradicts itself.

The OpenSource AI Pro Weekly Schedule / Time-Block Planner adds a layer most planners lack: conflict detection. A Double_Booked formula flag uses a self-referencing link to compare every time block against every other block on the same day. If two blocks overlap, both are flagged instantly. A filtered "Double-Booked" view shows only the conflicts, so you resolve them before they become a problem. Add a category breakdown that shows how many hours per week go to deep work, meetings, admin, and personal time — and you have a planner that does not just display your week but analyzes it.

Key Features

• Double_Booked Flag via Self-Link — Each time block record links to the same table (a self-referencing relationship). A lookup formula compares start and end times across blocks on the same day. If any two blocks overlap, the Double_Booked flag fires on both records. This is not a visual cue you might miss — it is a formula-driven, filterable, alertable data point.

• Category Breakdown — Every block is tagged with a category: Deep Work, Meeting, Admin, Personal, Exercise, Learning, etc. A rollup calculates total hours per category per week. See immediately whether your "4 hours of deep work daily" intention matches your actual schedule.

• Weekly Hours Summary — A rollup at the week level totals all scheduled hours, shows gaps (unscheduled time), and calculates the ratio of focused work to reactive work. Your schedule becomes measurable.

• Conflict Resolution View — A filtered view shows only blocks where Double_Booked = true. Open this view before your week starts to catch and resolve every overlap.

• Event-Triggered Conflict Alert — When a new block is created that triggers a double-booking, an automation sends you an email identifying both conflicting blocks. You can fix the overlap before it matters.

• Recurring Block Templates — Create template blocks (e.g., "Monday 9-11am: Deep Work") and duplicate them across weeks. Consistent time-blocking without re-entering the same blocks every Sunday.

How It Works

1. Create your time blocks. Each row represents one block: day, start time, end time, category, and description. The template includes a clean weekly grid view for visual planning.

2. Self-link detects conflicts. The Same_Day_Blocks field is a self-referencing link filtered to blocks on the same date. A formula compares time ranges: if(and(field('Start_Time') < lookup('Same_Day_Blocks', 'End_Time'), field('End_Time') > lookup('Same_Day_Blocks', 'Start_Time')), true, false). If any overlap exists, both blocks are flagged.

3. Category rollups analyze your time. As you add blocks, the weekly summary updates: 12 hours in meetings, 8 hours deep work, 3 hours admin. You see where your time actually goes — not where you think it goes.

4. Alerts catch mistakes immediately. The event-triggered automation fires when Double_Booked flips to true, sending you a quick email with the conflicting blocks. The weekly digest summarizes your planned schedule and any unresolved conflicts every Sunday evening.

Who It's For

• Knowledge workers and managers who use time-blocking but lack a tool that enforces conflict-free scheduling.
• Freelancers and consultants juggling multiple clients and needing category-level time tracking without a separate tool.
• Students managing class schedules, study blocks, and extracurriculars with zero budget for premium planning apps.
• Anyone who has tried Sunsama, Reclaim.ai, or Motion and liked the concept but not the monthly subscription.

vs the Alternatives

| Feature | OpenSource AI Pro | Sunsama | Reclaim.ai | Motion | |---|---|---|---|---| | Double-booking detection | Formula flag, instant | Calendar sync detects conflicts | AI auto-schedules around conflicts | AI auto-schedules | | Category time breakdown | Rollup, live | Manual tags | Limited | Task-based tracking | | Pricing | Free, self-hosted | $16/month | $8-12/month | $19/month | | Data ownership | Your server, open source | Vendor cloud | Vendor cloud | Vendor cloud |

Sunsama, Reclaim.ai, and Motion are excellent products — if you want AI-driven scheduling and are comfortable with the monthly cost. This template takes a different approach: you stay in control of the schedule, and the system catches your mistakes and shows you the data. No AI rearranging your day. No subscription. Just a formula-driven planner that is smarter than a spreadsheet.

What's Included

• Tables: Time Blocks, Week Summary, Categories
• Key Fields: Double_Booked (formula flag via self-link), Category (single select), Duration_Hours (formula), Weekly_Category_Hours (rollup), Unscheduled_Hours (formula), Same_Day_Blocks (self-referencing link)
• Automations: (1) Event-triggered alert on double-booked block creation, (2) Scheduled Sunday evening weekly schedule summary
• Views: Weekly Grid, Double-Booked Conflicts, Category Breakdown, Daily Detail

Get Started Free

Download the Weekly Schedule / Time-Block Planner and deploy it on your own Baserow instance. No subscription. No seat fees. No AI rearranging your calendar without asking.

Download Free Template | View Live Demo | Self-Hosting Guide

Related Templates

• Employee & Work Schedule Tracker — For team shift scheduling with unfilled-shift detection.
• Request Intake & Triage — Time-block your week, then route incoming requests through an SLA-tracked intake system.
• Creative Brief Tracker — Plan your creative production week with time blocks and track brief approvals alongside.