Notion Linked Databases: A Complete Guide

If you're a Notion user looking to take your productivity to the next level, you might have heard of linked databases. But what are they, exactly, and how can they help you get more organized? In this complete guide, we'll explore everything you need to know about Notion linked databases & self-referential filtering.

What are Notion Linked Databases?

At their core, linked databases are a way to connect different databases within Notion. This means that you can create a database in one page or workspace, and then link to it from another page or workspace. This can be incredibly useful if you're trying to organize a large amount of information across different areas of your life or work.

Benefits of Using Linked Databases

There are a few key benefits to using linked databases in Notion. First and foremost, linked databases can help you save time and reduce errors. Instead of having to copy and paste information between different databases, you can simply link to the original database and access the information directly. This can be especially useful if you're working with large amounts of data or if you need to update information frequently.

Notion linked databases are useful for creating efficient Notion templates because you can store all the databases in one place and use linked views wherever necessary. This can significantly improve your organization.

In addition, Notion linked databases provide a great way to consolidate multiple databases in one location. By creating a "Linked Database" block, you can add different views from various databases in the same place. More information on this feature is provided below.

Notion Linked Database: A Complete Guide

How to create a linked database

To create a Notion linked database, the first step is obviously to create your main database if you don’t have already. Then, go to the page or workspace where you want to link to the database, and add a "Linked Database" block. This can be done using /linked shortcut. From there, you can select the database you want to link to and choose the view you want to display.

When you select an already existing view, it will duplicate this view from the original database. So any changes you’ll make to this view won’t change the original view: they are now distinct views.

Using different databases on the same view

One thing that is super useful with linked databases is the ability to add different databases at the same location. Let's say you have a “Tasks” & a “Projects” database, and you want to see them both quickly on your main dashboard.

First, you need to add a linked view of your “Tasks” database. Select the view that is most relevant to your case, and name that view “Tasks”. Then, click the “+” button next to the “Tasks” view.

Notion Linked Databases | Add a new view

You can now select a new database. In our case we select our “Projects” database. Choose the view that you prefer & name it Projects.

Notion Linked Databases | Tasks & Projects views switch

That’s it! You now have two distinct databases at the same exact location.

Where to create linked databases?

As I said earlier, using linked databases is super useful to stay organized. Why? Because you can store all your databases in the same spot & use linked views wherever you need.

I suggest you store all your main databases in a callout block as I do on my Home dashboard.

Notion Linked Databases | Databases in callout

Then, use those linked databases on other pages that necessitate them.

Notion Linked Databases | Projects linked view

Linked databases for teams

If you work as a team, you may want to create personal dashboards for each team member. If you have a master database of all tasks, you can create linked views to this master database in each member’s personal dashboard. Then, simply filter the database by “Assigned to” or “Owner” (person property) by the corresponding member.

Notion Linked Databases | Personal Dashboard

Self-referential filtering in Notion

One of the most important features that Notion linked databases enable is the use of self-referential filters.

Self-referential filtering is a feature that allows users to filter data within a database based on the contents of a specific property. This means that you can create a view of a database that only shows items where a certain property matches the name of the current page, for example.

If you still haven’t got it, let me show you an example.

Let’s use our Tasks & Projects databases again. We need to link these 2 databases together. To do that, we add a two-way relation property.

Now that our databases are linked, we want to build a template in the “Projects” database. Simply click the down arrow next to the blue “New” button, then select “New template”.

We need to add a linked view of our tasks database in this template.

Notion Linked Databases | Linked Tasks Database in Projects

Then, and this is where the self-referential filtering shows up, you need to filter your Project property from your linked Tasks view by Project = Name of your template. In our case, the template is still “Untitled”, so I filter the Project property by “Untitled”.

Notion Linked Databases | Self-referential Filtering

Now get out of the template view, go back to your templates list (down arrow next to “New” blue button) & select your newly created template to be used by default.

Notion Linked Databases | Template by default

The setup is finished. So now, each time you’ll create a new project, it will automatically add a linked view of your Tasks inside the project card, and this linked view will only show the tasks related to the current project. I use this feature all the time, especially on client projects that involve project & ops management.

Conclusion

Notion linked databases provide an efficient way to connect different databases within Notion, which can help you save time and reduce errors. By using linked views, you can consolidate multiple databases in one location, making it easier to stay organized. Self-referential filtering is a particularly useful feature that allows you to filter data within a database based on the contents of a specific property. Notion linked databases are a powerful tool for anyone looking to get more organized and productive, and they are definitely worth exploring.

So go ahead and give Notion linked databases a try - you might just be surprised at how much they can help you streamline your work and get more done!

Start now & create your Notion account 🙃
(#NotionPartner)

3-2-1: Notion!

Want to be in the loop with everything Notion? Join the 4000+ Notioneers on the #1 Notion-focused newsletter.
Every Tuesday, I’ll hit you up with an email, giving you 3 tips on how to make the most of Notion, 2 (awesome) resources, and 1 Tweet of the Week.

Access previous newsletters

Check other posts

Monkey-minded, I like to build stuff that inspires me.

Living remotely, currently open for collabs.

Other projects

2023—Today
Repertory of Indie Hackers / Solopreneurs / Bootstrappers affiliate programs.
Indiefilliates
2022—Today
The best Notion templates on the market, curated by a Certified Notion Consultant.
The Notion Corner
2021—Today
The #1 newsletter that teaches you how to leverage Notion to make the best out of it.
3-2-1: Notion!
2017—Today
Music Production (House / Deep House)
Soundcloud