Notion Database Tutorial: Everything You Need to Know to Get Started

If you've opened Notion and stared at a blank page wondering what to do with it, you're not alone. The app can feel deceptively simple — but underneath the clean interface is one of the most powerful personal and team productivity tools available. The secret to unlocking that power is understanding Notion databases.

This tutorial walks you through everything a beginner needs to know: what a database is, which property types matter most, how views work, and how to build a real Task Manager from scratch — including formulas, relations, and filtered views.

---

What Is a Notion Database (and How Is It Different From a Table)?

A Notion database looks like a table on the surface, but it's much more than rows and columns. Every row in a Notion database is actually a full page — meaning each item can hold notes, images, comments, sub-tasks, or embedded files.

A plain Notion table (inserted with /table) is just a static grid. It has no views, no filters, and no formulas. A database, by contrast, is dynamic. You can:

• Switch between multiple views (Table, Board, Gallery, Calendar, Timeline, List)
• Apply filters and sorts that update in real time
• Add calculated properties with formulas
• Link records from other databases via Relations
• Roll up aggregated data across linked records

The easiest way to create a database is to type /database in any Notion page and select Database – Full page or Database – Inline.

---

The 6 Property Types Worth Knowing

When you add a new column to your database, you're adding a property. Here are the six you'll use constantly:

1. Text — Free-form notes, descriptions, or links. Use it for context that doesn't need to be categorized.

2. Number — Stores numeric values. Useful for price, hours, word count, or any quantity you might want to calculate.

3. Select — A single-choice dropdown. Perfect for Status (To Do / In Progress / Done) or Priority (High / Medium / Low). Keeps entries consistent.

4. Multi-select — Like Select, but allows multiple tags per item. Use it for categories, skills, or topic labels.

5. Date — Stores a date and optional time. Powers calendar views and enables date-based formulas.

6. Formula — Calculates a value based on other properties. This is where Notion gets genuinely powerful.

---

The 3 Must-Know Views

Views are different ways of visualizing the same underlying data. The same database can have a dozen views, each filtered or sorted differently.

• Table view — The spreadsheet-style default. Great for scanning all records and editing properties in bulk.

• Board view — A Kanban board organized by any Select property. Drag cards between columns to update their status instantly.

• Gallery view — Card-based layout that surfaces cover images and key properties. Ideal for visual content like articles, products, or portfolio items.

To add a new view, click + Add a view at the top left of any database, name it, and choose your layout.

---

Build It: A Task Manager Database

Let's build a real example. This Task Manager will handle everything from a simple to-do list to a multi-project work tracker.

Step 1: Create the Database

Type /database on a new page and select Database – Full page. Name it Tasks.

Step 2: Add Your Properties

Click the + icon in the column header row to add properties:

| Property | Type | Options | |---|---|---| | Name | Title | (default — always present) | | Status | Select | To Do, In Progress, Done | | Priority | Select | High, Medium, Low | | Due Date | Date | — | | Days Left | Formula | See below |

For the Days Left formula, click the property, select Formula, and enter:

dateBetween(prop("Due Date"), now(), "days")

This returns the number of days between today and the due date. Negative numbers mean the task is overdue. You can wrap it in an if() to show a label instead:

if(dateBetween(prop("Due Date"), now(), "days") < 0, "Overdue", format(dateBetween(prop("Due Date"), now(), "days")) + " days")

Step 3: Add a Filtered Board View

1. Click + Add a view → choose Board
2. Name it Active Work
3. Set Group by to Status
4. Click Filter → Add filter → Status → is → In Progress
5. Add another filter → Priority → is → High
6. Set the filter logic to Or if you want either condition, or And if you want both

Now your Active Work board only shows high-priority tasks that are currently in progress — no noise, just what needs attention today.

---

Going Further: Relations and Rollups

Once you have a Task Manager, the natural next step is linking it to a Projects database.

Setting Up a Relation

1. Create a new database called Projects with at least a Name (title) property
2. In your Tasks database, add a new property → select Relation → choose Projects
3. This adds a Project column to Tasks. Now you can link each task to a project.

Adding a Rollup

In your Projects database:

1. Add a new property → select Rollup
2. Set Relation to Tasks (the relation you just created)
3. Set Property to Name
4. Set Calculate to Count all

You now have a live count of tasks per project — no manual updates needed.

---

Using the Filter and Sort Toolbar

Every database view has a Filter and Sort button in the top right toolbar.

Filters narrow what records are visible. Stack multiple filters with AND/OR logic. Common use cases:

• Show only tasks due this week: Due Date → is within → the next 7 days
• Hide completed work: Status → is not → Done

Sorts order your records. Stack multiple sorts — for example, sort first by Priority (High → Low), then by Due Date (ascending) so high-priority tasks bubble to the top and are sorted by urgency within that group.

---

Skip the setup — grab a pre-built Notion system → The Ultimate Notion Productivity System ($27) includes a fully connected Task Manager, Projects DB, Goals tracker, and more — all linked together and ready to use on day one.

---

Next Steps

You've now got the core mental model for Notion databases: properties store structured data, views surface what you need, filters cut the noise, and relations connect your systems together.

The best way to go deeper is to actually use a database every day — even a simple task list. As your needs grow, you'll naturally reach for more properties, more views, and more connections.

And if you want to skip straight to a polished, production-ready system:

Start with a proven template →

The Ultimate Notion Productivity System ($27) is built on exactly the patterns covered in this tutorial — just configured, connected, and ready to open.