Notion Advanced Training: Database Features

Notion Advanced Training: Database Features

 

Overview of Notion Databases

  • Notion databases are collections of pages with structured metadata
  • Similar to a digital filing cabinet that helps organize information
  • More powerful than spreadsheets as each entry can open into its own page with rich content
  • Example shown: Project database with metadata like DRI (Directly Responsible Individual) and status

Database Properties and Templates

  • Various property types available: text, number, select, multi-select, date, formula, and more
  • AI-connected properties like AI Summary when AI is enabled
  • Database templates allow standardization of new entries
    • Templates can pre-fill property values and page content structure
    • Example: Creating a "Product Team 1" template with pre-assigned team value and page sections

Database Views

  • Table View: Default layout showing all information in rows and columns
  • Board View: Groups entries by a select property (e.g., project status: Not Started, In Progress, Done)
  • Timeline View: Visualizes entries across a timeline using date properties
  • Calendar View: Displays entries on a calendar based on date properties
  • Gallery View: Visual representation using cover images (useful for employee directories)
  • Chart View: Visualizes data (e.g., number of projects per DRI, projects by status)

Linked Databases

  • Same database can be accessed from multiple pages using linked views
  • Updates to data in one view reflect in all linked instances
  • Can select specific views (Board, Timeline, etc.) when linking a database

Relations and Roll-ups

  • Relations connect two databases (e.g., Projects and Tasks)
  • Allow you to associate entries between databases
  • Roll-ups pull information from related databases
    • Example: Calculating the percentage of completed tasks for each project

Sub-items and Hierarchies

  • Creates parent-child relationships within a database
  • Allows for sub-tasks under main tasks
  • Recommendation: Limit hierarchy to 1-2 layers to avoid complexity

Database Automation

  • Triggers actions automatically based on database changes
  • Format: When [Trigger] happens, perform [Action]
  • Example: When a project status changes to "Complete," send a notification
  • Can integrate with email, Slack, and other tools

Action Items

Practice creating database templates for standardized entries
Set up relations between related databases
Implement roll-ups to calculate summaries across databases
Create automations for workflow improvements