5. Databases

In this Chapter

Databases help you structure information in a variety of ways. With a choice of six unique database views, you control how to display content - letting you organize, categorize, label, filter, search, view, and utilize Notion to get your work done.

Articles

Intro to databases

Databases in Notion are collections of pages. Here, we'll introduce you to the general structure of a database, walk you through the different menus and options, and deep dive into how to open and edit pages within a database. 🗃

Database properties

Add properties to your database items to give them all kinds of context — due dates, task owners, relevant URLs, last edited timestamps, etc. Then use these properties to filter, sort, and search your data 🧩

Views, filters & sorts

You can view the same database in multiple ways, and switch back and forth between them depending on your needs in the moment. Within a view, you can add filters and sorts to easily categorize your content 📁

Tables

A table is the classic database view, but tables in Notion are more than just rows and columns. Each row opens up into its own page, and can contain whatever properties you want 📊

Lists

Lists are simple and minimalist database views. They're ideal for storing notes, articles, and documents that don't need too many properties. Every item in a list is a page that can be opened with one click and store as much content as you need 📜

Boards

Boards are helpful for showing items in a database moving through stages of a process, or grouped by property. Use them for project management and visualizing your data 📋

Calendars

Calendars let you visualize how database items connect to certain dates. Use one when you want a bird's-eye view for important launch dates, multi-day events, or even projects spanning multiple months 🗓️

Galleries

Gallery view is the best way to display databases with visual components, like mood boards, office directories, virtual recipe boxes, and more 🖼️

Timelines

For anyone who needs to visualize their projects plotted chronologically - whether it's hours, years, or anything in between - Notion's timeline is a type of database that keeps you on task and on track ⏳

Relations & rollups

Have you ever wanted to connect the data between two tables? You're in luck! Notion's relation property is designed to help you express useful relationships between items in different databases 🛠

Linked databases

Need to reference database content somewhere else in your workspace? Linked databases let you show, filter, and sort the same source data across multiple locations ⛓

Database templates

Most databases contain the same types of pages created over and over again. Think of weekly meeting notes, bug reports, or design specs. To make this easy, database templates let you define and replicate certain page structures with one click 🖨

Formulas

In a Notion database, you can add a formula property that lets you run all kinds of calculations and functions based on other properties. You can use formulas to manipulate existing data and arrive at many other helpful values 🔮

Still have questions?

We’re here to help. Get in touch with our support team.

📬