After using Notion for a while, you will realize that databases are its most powerful feature. Pages are great for writing notes, but databases make your notes filterable, measurable, and automatable — something few other note-taking apps can match.
That said, advanced database features like formulas, automations, and cross-database linking do have a learning curve. Over the past few years, I have written over twenty hands-on database tutorials, each solving a specific problem. Today I am compiling them into a single collection so you can find what you need quickly.
| Category | Topics Covered |
|---|---|
| Formula Basics | Formula 2.0 syntax, Rollup grouping, referencing summary values |
| Dates & Tasks | Status indicators, countdowns, date filtering, Checkbox linking |
| Data Queries | Latest record, random display, percentage stats, charts |
| Automations | Webhooks, spaced repetition, auto-titles, property inheritance, AI classification |
| Structure & Relations | Accounting system, auto-matching, sub-item management, hierarchy optimization |
Formula Basics
Notion released Formula 2.0 in late 2023, bringing a major syntax overhaul with new functions like map, filter, let, ifs, and style. Writing formulas is now a much better experience. If you are still using the old syntax, I highly recommend starting with this one:
- Formula 2.0 Deep Dive: 10+ New Features and Functions Explained — This is the foundation for all the formula tutorials that follow
Once you have the basics down, the two most common advanced needs are cross-database summaries and grouped statistics:
- How to Group Rollup Results — Use Rollup + Formula for cross-database category statistics, such as counting tasks by project
- How to Use Sum Values in Calculations — Read database summary values in formulas, such as calculating a category's percentage of the total
After reading these three articles, you will have the skills to write most Notion formulas.
Dates & Task Management
The most common use case for databases is task management, and task management revolves around dates. The following articles cover the core date-related needs:
- The Ultimate Task Status Indicator — Automatically display color-coded reminder labels (overdue, due soon, completed, etc.) based on due dates and completion status, using Formula 2.0's
let,ifs, andstylefunctions - How to Filter Last Month's Content — Two methods: grouping and formulas, perfect for monthly reviews
- How to Auto-Advance Dates Based on Multiple Checkboxes — Check off different stage checkboxes and the date automatically shifts forward, ideal for multi-step workflows
- How to Create a Birthday Countdown Reminder — A year-independent countdown formula, great for anniversaries and recurring reminders
Data Queries & Display
As your database grows, quickly finding the information you need becomes crucial:
- How to Show Only the Latest Entry — Use Relation + Formula to find and display the most recent record, ideal for dashboards
- How to Implement Random Review with Formulas — Use timestamps and modulo operations for pseudo-random sorting, seeing different content each time you refresh
- How to Build a Random Quote Database — Building on the random sorting above, display a single random quote each time
- How to Calculate Select Property Option Percentages — Use formulas to calculate the proportion of each option against the total
- Database Charts: A Complete Guide — A comprehensive guide to all 4 chart types for data visualization
Automation Workflows
Notion's automation features can drastically reduce repetitive work. From basic triggers to AI-assisted workflows, here they are from simple to advanced:
- Automation Now Supports Webhooks and Other Useful Updates — An introduction to automation basics, including Webhook triggers, button notifications, and other new features
- Building Spaced Repetition Tasks with Formula Variables — A spaced repetition solution that does not create duplicate pages, ideal for vocabulary review, periodic check-ins, and more
- Auto-Generate Titles Based on Property Values — Let database page titles generate automatically from other properties, no more manual naming
- Auto-Inherit Parent Page Relation Properties to Sub-Pages — Two methods (automation + button) to solve the hassle of manually setting relations on sub-pages
- How to Create Recurring Notification Reminders — Use automation to set up periodic reminders, filling the gaps left by the template system
- Batch-Classify Thousands of Rows with Notion AI — Use AI auto-fill to batch-classify data, solving the problem other AI tools struggle with due to context length limits
Structure & Relations
As your Notion system grows more complex, the way you design database relationships and structure becomes critical:
- Database Accounting: How to Auto-Update Account Balances — Build a complete accounting system with Relation + Formula where every transaction automatically updates the balance
- How to Auto-Match Text Properties to Related Pages — Enter text and automatically link to the corresponding page, no manual selection needed
- How to Track Sub-Item Time Ranges — Use Rollup + dateRange to have parent tasks automatically calculate child task time spans
- How to Auto-Expand Database Sub-Items — A simple filter trick to solve the annoyance of sub-items collapsing every time
- What to Do When Database Nesting Gets Too Deep — Use the PARA method to control hierarchy depth + Desk quick pages to improve access efficiency
If you want these database techniques to deliver maximum value, a well-structured Notion workspace is the prerequisite. My FLO.W template comes with a clear database architecture and thoughtful property design, letting you skip the setup process and apply these techniques on a proven system right away.
Latest Updates: In 2026, Notion launched the Dashboard database view and video previews in Board & Gallery views, making databases more powerful than ever.
The Best Playground for Database Techniques
The FLO.W template comes with pre-built structured databases for tasks, projects, notes, and more. Every property has been carefully refined, making it the ideal starting point for practicing all the database techniques in this article.
