Role System Designer Timeline 3+ months Platform Notion

Building a Job Search System That Makes Progress Visible

A Notion-based job tracking system with automated progress counters, status-driven views, and visual dashboards that make effort observable — reducing mental burden and sustaining motivation.

1 core database — single source of truth for all applications
6 custom views — different interfaces for different mental states
5 automated formulas — zero manual calculation required
0 manual tallying — all stats auto-update in real time

This dashboard is interactive

Click any pipeline stage to see how the dashboard updates with stage-specific metrics and next actions.

Job Tracker — Dashboard
LIVE SYSTEM
Application Pipeline
Applied
Waiting
Interviewing
Offer
This Week
12
Applications Sent
3 responses received
1 interview scheduled
All Time
47
Total Applications
2 active interviews
23% response rate
Next Actions
5
Follow-ups Needed
2 interviews this week
3 new postings to review
The Challenge

The real problem isn't disorganization — it's invisible progress

Job searching involves operational complexity and emotional strain. Most trackers frame this as an organization problem — but the real issue is visibility. When progress stays hidden, your brain concludes nothing is happening.

For job seekers — especially those with ADHD or anxiety — the lack of visibility creates constant stress and genuine missed opportunities.

Fragmented information — details scattered across email, spreadsheets, tabs, and mental notes
Invisible progress — no tangible proof that effort translates into forward movement
Manual overhead — constant mental load of remembering what to do next
System abandonment — complex trackers feel like homework and get dropped
Before
After
← toggle to compare
Job Search — Scattered Tracking
??? records
Source
Info
Status
Days
Next
SHEET
Acme Corp — PM Role
Applied?
???
???
Reply from TechCo recruiter
Somewhere
14?
Check inbox
TABS
DataFlow — bookmarked listing
Not applied
Apply?
NOTES
Mental note: follow up w/ Sarah
Unknown
21?
Remember?
Meridian Labs — interview invite?
Buried
7?
Check spam
TABS
3 open job listings — browser tabs
Unsaved
Don't close
?How many total applications?
?What needs follow-up today?
?Is effort producing results?
?Where does each application stand?
Jobs Database — 47 Records
Notion
Company
Position
Status
Days
Flag
Acme Corp
Product Manager
Interviewing
8
✓ On track
TechCo
Operations Lead
Waiting
16
⚠ Follow up
DataFlow
Systems Designer
Applied
3
✓ Recent
Meridian Labs
Ops Analyst
Waiting
22
⚠ Follow up
Brightpath
Project Coordinator
Offer
31
★ Received
Nova Systems
Business Ops
Applied
1
✓ New
My Approach

Designing for emotional usability, not just organization

Observation of personal job search behavior and interviews with other job seekers identified core pain points. The central finding: visibility drives motivation more than organization ever could. Any system requiring manual tallies gets abandoned. Status clarity matters more than detail. And the system must tolerate gaps.

Existing Tracker Failures
Manual maintenance breaks down with low motivation. Fragmentation increases stress. Complex pipelines are hard to scan. No visibility reduces satisfaction. Inconsistent use causes data gaps.
Key Research Insights
Users who could see their application count reported higher satisfaction. Progress must be automatic. Status clarity matters more than detail. Fragmentation creates anxiety. System must tolerate gaps.
Single Source of Truth
All job search info consolidated in one place with automatic tracking
Visibility Infrastructure
Automated counters providing tangible evidence of effort
Emotional Usability
Designed to be opened even on low-motivation days
Status-Driven Views
Databases organize themselves based on application state
Cognitive Scaffolding
Clear next actions, obvious organization, visual progress
What I Built

One database, 15 properties, zero friction

An integrated Notion system with 1 core database, 6 custom views, and automated progress tracking. No required fields, no shame for gaps — just gentle structure that rewards consistent use.

Automated properties do the heavy lifting: Days Since Application calculates elapsed time, Needs Follow-up flags stale applications, and Status Color enables visual scanning. Click any row below.

Core identification — company, position, status, source, salary range, location
Dates and timeline — application date, follow-up date, last contact, interview date
Automated formulas — days elapsed, follow-up flags, status color indicators
Materials tracking — resume variant, cover letter, portfolio, writing samples submitted
Jobs Database
47 RECORDS
Company
Position
Status
Days
Flag
Acme Corp
Product Manager
Interviewing
8
Application Details
Applied: Mar 14, 2026
Contact: Sarah Miller (Recruiter)
Source: LinkedIn
Materials Sent
✓ Resume (Standard)
✓ Cover Letter
✓ Portfolio
TechCo
Operations Lead
Waiting
16
Application Details
Applied: Mar 6, 2026
Contact: James Chen (HM)
Source: Company Site
Follow-up
⚠ 16 days — needs follow-up
Last contact: Application confirmation email
DataFlow
Systems Designer
Applied
3
Application Details
Applied: Mar 19, 2026
Source: Referral (Mike T.)
Salary: $85K-$105K
Materials Sent
✓ Resume (Technical)
✓ Writing Samples
Meridian Labs
Ops Analyst
Waiting
22
Application Details
Applied: Feb 28, 2026
Location: Remote
Source: Indeed
Follow-up
⚠ 22 days — no response
Consider archiving or re-contacting
Brightpath
Project Coordinator
Offer
31
Offer Details
Offer received: Mar 18, 2026
Salary: $92K + benefits
Start date: Apr 7, 2026
Interview Notes
3 rounds completed
Strong culture fit
Negotiation pending
Nova Systems
Business Ops
Applied
1
Application Details
Applied: Mar 21, 2026
Source: LinkedIn
Location: Hybrid
Materials Sent
✓ Resume (Standard)
✓ Cover Letter
Clearview
Program Manager
Interviewing
12
Application Details
Applied: Mar 10, 2026
Contact: Lisa Park (HR)
Source: Referral
Interview Progress
✓ Phone screen completed
→ Panel interview scheduled Fri
Orbit Tech
Systems Analyst
Waiting
18
Application Details
Applied: Mar 4, 2026
Contact: Recruiting Team
Source: Indeed
Follow-up
⚠ 18 days — no response
Follow-up date was Mar 15 (overdue)
Pinnacle Group
Ops Coordinator
Applied
5
Application Details
Applied: Mar 17, 2026
Location: Remote
Salary: $70K-$85K
Materials Sent
✓ Resume (Standard)
✓ Cover Letter
✓ Portfolio
Crestline
Project Analyst
Waiting
15
Application Details
Applied: Mar 7, 2026
Source: Company Site
Location: On-site
Follow-up
⚠ Just crossed 14-day threshold
Send polite follow-up email
Status-Driven Views

Views that organize themselves based on application state

No manual sorting required. When a status changes, the application automatically appears in the right view. Move a card to "Interviewing" and it vanishes from "Waiting." The kinetic interaction of dragging cards increases engagement — people want to move cards, not just update fields. Same data, different interfaces: board view for high-engagement days, table view for admin tasks, calendar for planning, dashboard for low-motivation check-ins.

Board View — Visual Pipeline
Applied 4
DataFlow
Systems Designer
3 days ago
Nova Systems
Business Ops
1 day ago
Pinnacle Group
Ops Coordinator
5 days ago
Lumina Health
Ops Specialist
2 days ago
Waiting 4
TechCo
Operations Lead
16 days ⚠
Meridian Labs
Ops Analyst
22 days ⚠
Orbit Tech
Systems Analyst
18 days ⚠
Crestline
Project Analyst
15 days ⚠
Interviewing 3
Acme Corp
Product Manager
Round 2 — Thu
Clearview
Program Manager
Phone screen — Fri
Vertex Inc
Business Analyst
Final round — Mon
Offer 1
Brightpath
Project Coordinator
$92K — negotiating
Rejected 3
Zenith Co
PM Associate
After round 1
Apex Digital
Ops Manager
No response
Redstone
Coordinator
Position filled
Automated Tracking

Making effort tangible without manual work

Real-time counters automatically calculate application volume, response rates, and interview activity using rollup properties linked to a dashboard database. When motivation is low, users can see proof that work is happening — not through discipline, but through automatic visibility. Zero manual tallying required.

This Week
12
Applications Sent
✓ 3 responses received
✓ 1 interview scheduled
Rollup: count where date > 7 days ago
All Time
47
Total Applications
→ 2 active interviews
→ 1 offer received
Rollup: count of all non-archived
Response Rate
23%
Interviews + Offers / Total
→ 8.5% interview rate
→ 2.1% offer rate
Formula: auto-calculated from status
Action Required
5
Need Follow-up
⚠ 3 over 14 days
⚠ 2 overdue dates
Formula: days > 14 AND status = waiting
Action Required — Follow-up Queue
AUTO-FLAGGED
Company
Status
Days
Flag
TechCo
Waiting
16
Why Flagged
Status = "Waiting" AND Days > 14
No response since application confirmation
Suggested Action
→ Send follow-up email to recruiter
→ Reference original application date
Meridian Labs
Waiting
22
Why Flagged
Status = "Waiting" AND Days > 14
No contact since initial application
Suggested Action
→ Consider archiving or sending final follow-up
→ 22 days with no response
Orbit Tech
Applied
18
Why Flagged
Status = "Applied" AND Days > 14
Follow-up date was Mar 15 (overdue)
Suggested Action
→ Check if position is still open
→ Send brief check-in email
Crestline
Waiting
15
Why Flagged
Status = "Waiting" AND Days > 14
Just crossed the 14-day threshold
Suggested Action
→ Send polite follow-up
→ Express continued interest
Lumina Health
Interviewing
Why Flagged
Follow-up date = Today
Send thank-you after yesterday's interview
Suggested Action
→ Send thank-you email to panel
→ Reference specific discussion points
Follow-up Automation

External memory so you never forget to follow up

Formula-based flagging surfaces applications that need attention. The system remembers who to follow up with so you don't have to — flagged items appear in a dedicated "Action Required" view.

Two conditions trigger flags: status = "Waiting" with days exceeding 14, or a follow-up date that has passed. Click any row to see why it was flagged and the suggested action.

Auto-flag at 14 days — "Waiting" applications get flagged automatically
Overdue follow-ups — flags when follow-up date passes today
Exception-driven view — shows only what needs attention now
Zero missed opportunities — system catches what memory can't
Results & Impact

From scattered effort to visible progress

When progress becomes visible, behavior changes naturally — not through discipline, but through satisfaction. The system provides tangible evidence of effort, especially on days when motivation is low.

5 places
Scattered across
1 system
Single source of truth
0
Custom Views
0
Database Properties
0
Automated Formulas
0
Rollup Properties
0
Source of Truth
0
Manual Tallying

Why This Matters

This project demonstrates how operations thinking and emotional usability create systems people actually sustain.

Visibility > Organization
Making progress tangible solves motivation problems that organization never could
Automatic > Manual
Systems that require manual maintenance get abandoned during low-motivation periods
Emotional > Efficient
Designing for how people actually feel matters more than optimizing for throughput
Exception > Comprehensive
Show what needs attention now, not everything — exception-driven dashboards reduce overwhelm
Database Schema Design Formula Logic Rollup Aggregation View Design Information Architecture User Psychology Notion Behavioral Design