Intro to databases

In this Article

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. 🗃

There are three things that distinguish Notion databases from spreadsheets and databases you can build with other software:

  1. Every item is its own editable page: Every item you enter into your database can be opened as its own Notion page, where you can layer in any information you want. We'll cover this below!

  2. Customizable properties: Add properties to contextualize, label and augment any database item with more information, like dates, people, text, links, etc. Learn more about database properties here →

  3. Multiple views you can toggle between: Your data isn't stuck in a table. View the exact same database as a board, list, calendar, gallery, and timeline — whatever makes the information most useful. Learn more about views, filters & sorts here →

Databases: a tour

Every full-page database has the same menus and sets of options. Here's a quick walkthrough.

  1. View menu: Add, switch between, and edit all the different views of your database.

  2. Properties menu: Add, edit, hide and show properties.

  3. Filter and Sort menus: Specify criteria for the data you want to show. You can add as many as you want. They'll be applied in the order they're listed.

  4. Database search: Type in any word, whether it's in the name of a database item or in a property, and your database will change to only show items that fit that search.

  5. ••• menu: Located at the top right of your database, this is an odds and ends menu where you can Copy link to view, and see who edited the database last and when. It also Includes the option to Wrap cells in tables.

  6. New button: Click this to add a new item into your database that instantly opens as a page. Click the down arrow to the right of this button to access any database templates you've configured.

  7. Database Lock: Find this option in the ••• menu at the very top right of the Notion window. Switch it on to prevent anyone from changing properties and views in your database. They'll still be able to edit the data it contains.

Create a database

There are several ways to create a database inside Notion:

  • Create a new page in your workspace, then choose what type of database you want from the grayscale menu on that empty page.

  • Create a database page inside an existing page by typing / followed by the type of database you want (i.e. table, board, etc.). Choose the full-page version.

  • Create a database in-line on your page by typing / followed by the type of database you want. Choose the in-line version.

Open & edit database pages

Every item in your database, whether it's a row in a table or a card on a board or calendar, is its own Notion page that you can build, format and nest content in like any other page.

Here's how to open database items as pages:

  • In tables, hover over your first column and click the ⤢ OPEN button that appears.

  • In lists, just click on the title of the item.

  • In boards, calendars, and galleries, click anywhere on the card.

  • Pages will always open in preview mode. Click ⤢ Open as Page at the top left to view in full-page mode.

  • In this page, you'll see all your database properties at the top. Each row is one property, with a name, type, and a value. Click on the value to edit.

    • Click the ⋮⋮ that appears to the left of each property on hover in order to: drag it up or down, change the Property type, rename it, Duplicate or Delete it.

  • Underneath your properties is free page space, where you can add any type of content block, including sub-pages or an in-line database.

  • Because database items are pages, any other type of content you drag into a database (like bullets or to-do items), will automatically turn into pages.

Customize database pages

The top section of any page in a Notion database can include several things:

  1. Properties provide data about the page you're looking at, like project owner, due date, tags, and more.

  2. Comments capture conversation between you and your teammates. You can use them to tag each other, ask questions, provide feedback and more. 

  3. Backlinks indicate all the pages that link to the current page so you can easily navigate between them.

As with everything in Notion, you can customize the look and feel of these components. To access these options:

  • Click the ••• at the top right of any Notion database page and select Customize page.

  • You'll see this window pop up:

For properties, you can use this menu to choose which property fields you want to show at the top of the page, and how. For each one, select from:

  • Always show: Nothing changes, you continue to see the property field.

  • Hide when empty:  The property field will disappear from the top of your page if it has no value in it.

  • Always hide: The property field will not show up at the top of your page.

You can also access the Customize page menu by clicking the ⋮⋮ icon next to any property in the list at the top of your database page. This ⋮⋮ icon can also be clicked and dragged up or down to reorder how properties are displayed on your page.

Tip: If you have a database with dozens of properties, this is a great way to keep your pages streamlined so you don't have to scroll a ton just to get to your page content.

Note: When you hide properties, they get aggregated in a single menu item at the bottom of the list. You can click this to easily show any hidden properties.

For backlinks, you can choose:

  • Expanded: See all the pages that link to the current page listed in full.

  • Show in popover: In case you don't want to see all the pages, you can choose to see just the number of backlinks. Click to open a popup displaying all the pages.

  • Off:  Just hide all backlinks entirely.

For comments, you can choose to show them:

  • Expanded:  Show the full conversation at the top of the page.

  • Off: Hide comments on the page for a minimalist view.

Full page vs. in-line databases

All databases in Notion can exist in two formats — as a full-page, or in-line on another page that contains unstructured data too (like a table in the middle of a written document).

Full page databases

  • Create a full-page database by creating a new page in your workspace and selecting a database type from the grayscale menu.

  • Or type / followed by the type of database you want (board, list, etc.) and the word full.

  • Full page databases appear just like any other page in your sidebar.

  • You can lock a full-page database so that other people can't change properties and value options by going to the •••icon and switching on Database Lock.

  • To turn a full page database into an inline database, you can just drag the database into another page in the sidebar, which will turn it into a subpage.

  • Then navigate into the page, and click the ⋮⋮ icon, and select Turn into inline in the drop down menu to turn it into an inline database.

In-line databases

In-line databases can live alongside all other types of content. One popular use case is adding them into documents.

  • Create an in-line database by typing / followed by the type of database you want and the word inline.

  • Controls/menus for your database are hidden until you hover over it.

  • You can expand an in-line database to full-page by hitting  at the top right.

  • You can turn an in-line database into a full-page database by grabbing the ⋮⋮ and dragging into the sidebar as a top-level page.

  • The PropertiesFilter and Sort menus are all tucked within the ••• icon at the top right of your database.

  • You can DeleteDuplicate, move or copy the link to your in-line table by clicking the ⋮⋮ icon that appears on hover in the left margin.

  • Your in-line database will appear as a sub-page of the page it's on in your sidebar.

Give Feedback

Was this resource helpful?

Up Next

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 🧩

Powered by Fruition