Crafting Your Project Dashboard

1. Understanding Linked Databases

Before we start building, we need to grasp the concept of a "Linked Database."

A linked database is not a copy of your database. It's a view—a live, interactive portal to your original master database. Imagine you have a single, massive 'Tasks' database. You can create linked views of it on your project pages, your main dashboard, or anywhere else.

• Any change you make in a linked view (like checking off a task) instantly updates the original database.
• Any change in the original database (like adding a new task) instantly appears in the relevant linked views.

This allows you to maintain a single source of truth for your data while creating countless customized views of it throughout your workspace. This principle is fundamental to creating efficient, professional-grade Notion systems.

To create a linked database, you use the slash command /linked view of database.

2. The Core Technique: Self-Referential Filtering

Here's where the real power comes in. We want our project page to show only the tasks for that specific project. We achieve this through a technique called self-referential filtering.

It sounds complex, but the idea is simple: We will create a template for our projects. Inside this template, we'll place a linked view of our 'Tasks' database. Then, we will add a filter to that view telling it: "Only show tasks where the 'Project' property is related to this very template."

When you create a new project using this template, Notion automatically understands that the filter should apply to the newly created project page.

This is arguably one of the most important techniques for creating advanced Notion templates.

3. Building the Project Dashboard Template

Now, let's combine these concepts to build the dashboard. We'll do this inside a database template so that every new project we create will automatically have this focused dashboard built-in.

The goal is to create separate, organized views for tasks that are "Open" and tasks that are "Completed."

✍️ Exercise: Build Your Project Dashboard

It's time to apply what you've learned to your system. Follow these steps carefully.

Your Tasks:

• 1. Create a New Project Template.

  • Navigate to your Projects database.
  • Click the small down-arrow next to the blue New button in the top-right.
  • Click + New template. Name this template New Project.

• 2. Add a Linked View of 'Tasks'.

  • On the new, blank template page, type /linked view of database.
  • Select your Tasks database from the list. A table view of all your tasks will appear.

• 3. Apply the Self-Referential Filter.

  • In the top-right of the linked database you just created, click Filter.
  • Select the Project property (the relation you created in the last lesson).
  • In the filter options, select your template name, New Project. The filter should read: Project Contains New Project.

• 4. Create an "Open Tasks" View.

  • Now, let's refine this view. Add a second filter rule by clicking + Add filter.
  • Set this filter to Status Is not Done.
  • Click the three dots (...) in the top-right of the linked view and select Rename. Call this view Open Tasks.

• 5. Create a "Completed Tasks" View.

  • Click on the Open Tasks view tab you just renamed. In the menu that appears, click Duplicate.
  • Rename this new, duplicated view to Completed Tasks.
  • Adjust the filter for this view: change the Status filter from Is not Done to Is Done.

• 6. Clean Up the Views.

  • In both the Open Tasks and Completed Tasks views, the Project column is now redundant (we already know what project we're in).
  • Click the three dots (...), go to Properties, and click the eye icon next to Project to hide it.

• 7. Set the Template as Default.

  • Go back out of the template editor.
  • Click the down-arrow next to New again. Find your New Project template, click the three dots (...) next to it, and select Set as default.

• 8. Test Your Dashboard!

  • Create a brand new project in your Projects database. It should automatically load with your "Open Tasks" and "Completed Tasks" views.
  • Add a new task directly into the Open Tasks view. Then, change its status to Done. Watch it disappear from the "Open" view and appear in the "Completed" view.

Conclusion

Excellent work! You have now built a truly dynamic and context-aware component in your Notion system. By mastering linked databases and self-referential filtering within templates, you've unlocked a professional workflow that is essential for creating clean, valuable, and sellable Notion templates.

Key Takeaways:

• Linked Databases are live, filtered portals to a master database, not copies.
• Self-referential filtering is the key to creating context-aware dashboards inside templates.
• Building functionality inside a default template automates your workflow and ensures consistency for every new project.

Preview of the Next Lesson:
Now that each project has its own dashboard, our next step is to zoom out. We need a way to see the status of tasks across all projects. In the next lesson, we will create a Kanban board view of our master 'Tasks' database. This will be the centerpiece of our main project management dashboard, allowing you to visually track task progression from "To Do" to "Done."