Projects Database

The Projects feature lets you organize tasks into larger initiatives. This guide shows you how to connect a Notion projects database to CueCapture.

What Are Projects?

Projects in CueCapture are containers for related tasks. They help you:

• Group tasks by goal or initiative
• Track progress across multiple tasks
• Filter the widget to focus on one project
• See the big picture alongside individual tasks

Prerequisites

• CueCapture connected to your Tasks database
• A Notion database for projects (or you’ll create one)
• A relation property in your tasks database linking to projects

Database Setup

Option 1: Using an Existing Projects Database

If you already have a projects database in Notion:

1. Share with Integration

   Open your projects database in Notion:

   • Click ”…” → “Connections”
   • Add your CueCapture integration

2. Add Relation to Tasks

   In your tasks database, create a relation property:

   • Add new property → Relation
   • Select your projects database
   • Name it “Project” (or similar)

3. Connect in CueCapture

   Open Settings → Notion Databases → Projects:

   • Paste your projects database URL
   • Map the properties (Name, Status)
   • Select the relation property in your tasks database

Option 2: Creating a New Projects Database

1. Create the Database

   In Notion, create a new database with these properties:

   Property	Type	Description
   Project	Title	Project name
   Status	Status	Not Started, In Progress, Complete
   Due Date	Date	Project deadline (optional)
   Progress	Formula	Auto-calculated task completion

2. Link to Tasks

   In your tasks database:

   • Add a Relation property pointing to your new projects database
   • Name it “Project”

3. Share & Connect

   Share the database with your integration and connect it in CueCapture settings.

Property Mapping

Required Properties

CueCapture Field	Notion Property	Notes
Project Name	Title	The project’s name
Status	Status/Select	For filtering active projects

Optional Properties

CueCapture Field	Notion Property	Notes
Due Date	Date	Project deadline
Description	Text	Shown in project details
Icon	Icon/Emoji	Displayed in lists

Status Configuration

Tell CueCapture which status means “complete” so it can filter out finished projects:

Completed Status: Done, Complete, Finished, ✅

Progress Tracking

CueCapture can show project progress based on task completion. This works automatically when:

• Tasks have a relation to projects
• Tasks have a status property
• You’ve configured “completed” status values

Progress displays as a percentage: 7/10 tasks (70%)

Notion Formula for Progress

You can also add a progress formula directly in Notion:

// In your Projects database, add a Rollup + Formula:

// 1. Add Rollup "Tasks"
//    - Relation: Tasks relation
//    - Calculate: Count all

// 2. Add Rollup "Completed"
//    - Relation: Tasks relation
//    - Filter: Status is Complete
//    - Calculate: Count all

// 3. Add Formula "Progress"
round(prop("Completed") / prop("Tasks") * 100) + "%"

Using Projects in CueCapture

Once configured, you can:

Filter by Project

• Click the project dropdown in the filter bar
• Select a project to show only its tasks
• Select “All Projects” to see everything

View Project List

• Click the projects icon (📁) in the sidebar
• See all active projects with progress
• Click a project to filter to it

Assign Tasks to Projects

• When creating/editing a task, select a project
• The relation syncs to Notion automatically

Project Progress

• Progress bars show completion percentage
• Based on completed vs. total tasks
• Updates in real-time as you complete tasks

Tips

Nested Projects

Notion doesn’t support native nested projects, but you can simulate hierarchy:

• Use a “Parent Project” relation property
• Add project prefixes: “Client A / Website Redesign”
• Use Notion’s sub-pages within project pages

Project Templates

Create Notion templates for common project types:

• Include default tasks
• Pre-set properties
• Consistent structure

Archive vs Delete

Instead of deleting completed projects:

• Mark them as “Complete” or “Archived”
• CueCapture filters them out automatically
• You keep historical data in Notion

Troubleshooting

Projects Not Appearing

• Verify the database is shared with your integration
• Check that the relation property exists in your tasks database
• Refresh CueCapture (⌘/Ctrl + R)

Tasks Not Showing Under Projects

• Ensure tasks have the project relation filled in Notion
• Check that you’re not filtering to a different project
• Verify the relation is bi-directional

Wrong Project Count

• Progress counts may take a moment to update
• Check your “completed status” configuration
• Subtasks might not be counted (depends on setup)

Next Steps

• Time Logs Database - Track time spent on tasks
• Features: Projects - Using projects in the widget