The DesignLab Daily Task Tracker began as a personal solution to a simple problem: I had too many responsibilities stored in too many places.
Some tasks were written in notes. Others were sent to myself through messages. Work responsibilities, DesignLab content, business ideas, personal errands, and leisure plans were mixed together. I did not need another complicated productivity platform. I needed one clear daily view built around the way I actually work.
Defining the categories
I started by identifying the areas that regularly appeared in my routine. The tracker uses five main categories: Personal, Page, Business, Work, and Leisure.
These categories are simple, but they create an important separation. A university task should not disappear between personal reminders. A DesignLab post should not be treated the same way as a business deadline. Categorization makes the dashboard easier to scan and helps me understand where my time is going.
I then added urgency levels and time slots. Urgency helps identify what needs immediate attention, while time slots organize tasks according to the expected part of the day. Together, they provide more context than a basic checklist.
Moving beyond a daily checklist
An early version focused only on tasks assigned to the current date. That created another problem: unfinished tasks from previous days could become invisible.
To solve this, I added a pending-task notification area. The system surfaces incomplete tasks even when their original date has passed. This makes overdue responsibilities visible without forcing them into the main daily list permanently.
I also added a searchable and collapsible archive. Completed and older tasks can still be reviewed, but they no longer overcrowd the current workspace. The goal was to balance visibility with focus.
Other updates included clearer task statuses, prioritization, a live date and time display, responsive layouts, and quick-access links to related DesignLab tools.
Designing it as a product
Once the tracker became useful in my own routine, I started thinking about how it could work for other people.
A personal tool can rely on assumptions because the creator already understands how it works. A product cannot. Labels need to be clearer. Setup needs to be easier. Categories may need to be customizable. Instructions, version records, and maintenance documentation become part of the product—not optional extras.
This changed how I approached the interface. I began treating each feature as something a first-time user should understand without explanation. I reviewed the hierarchy, spacing, form controls, mobile behavior, and feedback messages. I also documented the setup process and version history.
The role of Google Apps Script and Sheets
Google Sheets stores the task data, while Google Apps Script connects the database to the web interface. HTML, CSS, and JavaScript manage the visual layout and user interactions.
This combination made it possible to build a lightweight system without setting up a separate server or paid database. It also created a familiar backend that can be inspected and maintained directly.
The limitation is that a product built on this stack must be packaged carefully. Users need clear instructions, permissions must be handled properly, and the system should avoid requiring technical edits whenever possible. These are now part of the product-development plan.
What the project taught me
The project reinforced that good digital products often begin with a real personal problem. Because I use the tracker myself, I notice friction quickly. Every missed task, confusing label, or unnecessary step becomes direct product feedback.
It also taught me that product development is continuous. A working first version is not the finish line. The next stage is improving onboarding, customization, reliability, and the overall experience for users with different routines.
What comes next
The Daily Task Tracker now works as a personal productivity system and a product prototype. The next steps may include editable categories, configurable time slots, better summaries, packaged setup options, and a cleaner onboarding process.
My goal is not to recreate every feature found in large task-management platforms. The value of this product is its focus: a simple, visual daily dashboard that helps users see what matters without adding more complexity to their day.