Create a database

In this Article

Now we'll create a database and use it to show off essential database actions and features. You'll get to play with database properties, views, filters, and sorts - let's get into it ๐Ÿ“ˆ

Create a new table

  • Add a new page and select Table.

  • The first column is where you enter the name of your database pages. Each column in a Notion table corresponds to a property that gives your item context.

  • Click a property heading, then the menu under Property type to see all of your property choices.

Add data to your table

  • For this example, we'll create a task database.

  • Add some tasks you're working on in the Name column.

  • Now add some values to the Tags column using the multi-select property. Suggestion: P1, P2 and P3 to indicate priority of the task.

  • Add a new property using the + button to the right of the Tags heading.

  • Change its name to Due Date. And under Property type, select Date from the menu. Now when you click on a cell under Due Date, you'll see the date picker.

Open a row as a page

Every item in a Notion database is also a whole page of its own! You can add any content you want inside, including other databases.

  • In our task database example, this would let you keep all notes and content related to a task neatly bundled inside that task.

  • To open a row as a page, hover over a cell in the Name column and click โคข OPEN. It will look like this:

  • You can add or edit any properties. And you can add additional content into the body of the page, such details for the task:

Create new database views

You can create different views of the same data. Put it into a board, a calendar, a list, a gallery, or a timeline โ€” depending on your needs. Let's try one.

  • Click + Add a view at the top left of your table.

  • Give your new view a name and choose Board from the dropdown.

  • This displays rows from your table into cards on a board, grouped by tag. Clicking on a card still opens it as a page. It's all the same content, just visualized in a different way!

Tip: Different views are good for different things, and you can have as many as you need!

  • Gallery view is great if you're storing images in your database.

  • Lists are helpful for minimalist storage of documentation.

  • Calendar view displays your pages by an assigned date property.

  • Timelines are useful for visualizing project dates and length.

Filter and sort your data

Filter by property to focus on specific parts of your database.

  • Click Filter at the top of your table, then + Add a filter.

  • Choose the property you want to filter by and the criteria that needs to be met.

    • The middle dropdown will give you different options depending on the property.

    • In this case, let's choose Tags as the property, and say it must contain P1.

Add sorts to reorder your database depending on property values. Sorts are helpful for quickly ordering your data by priority, date, tags, etc.

  • Click Sort at the top of your table, then + Add a sort

  • Choose the property you want to sort your database by. For example, choose Due Date and then Ascending. This reorders tasks from closest to furthest due date.

You'll see your database change in real time based on your filter and sort criteria. You can add as many filters and sorts as you want, and each view has its own filter and sorts.

Give Feedback

Was this resource helpful?

Up Next

Start with a template

To help you take on a variety of challenges with Notion, we've created more than 50 templates that you can adopt and customize as your own โ€” including 5 "starter templates" already in your workspace! Here's how to use them ๐Ÿ’พ

Powered by Fruition