Databases
Overview
Databases in Ascend let you organize and track structured information in flexible tables. Think of them as powerful spreadsheets with typed columns, multiple views, and advanced features like formulas, relations, and real-time collaboration.
Quick Start
Creating Your First Database
- Navigate to the Databases page
- Click "New Database"
- Choose a template or start blank
- Give it a name
- Start adding your data!
Your database comes with a default "Name" column and a "Table" view ready to use.
Key Concepts
Properties (Columns): Define what type of data each column holds (text, numbers, dates, etc.)
Rows: Individual records or entries in your database
Views: Different ways to display and filter the same data
Cells: Individual data points where a row meets a column
In This Section
Core Features
- Property Types - All available column types and how to use them
- Working with Rows - Adding, editing, and organizing your data
- Views & Filters - Create custom views with filters, sorts, and grouping
- Advanced Features - Formulas, relations, rollups, and computed properties
Guides
- Working with Rows - Deep dive into individual records
- Collaboration - Comments, mentions, and real-time editing
- Troubleshooting - Common issues and solutions
Common Use Cases
Project Management
- Track tasks with status, assignee, and due dates
- Group by status to see what's in progress
- Filter to see only your tasks
CRM (Customer Relationship Management)
- Store client information with contact details
- Track deal stages and values
- Link related contacts and companies
Content Calendar
- Plan blog posts, social media, and campaigns
- Use date properties for publishing schedules
- Multi-select for platforms and categories
Inventory Management
- Track products with SKUs and quantities
- Use numbers for stock levels and prices
- Relations to link products to suppliers
What Makes Databases Powerful
✅ Typed Properties - Each column knows what kind of data it holds ✅ Multiple Views - See your data in different ways without duplicating it ✅ Real-time Sync - Changes appear instantly for all team members ✅ Flexible Filtering - Show only the data you need ✅ Advanced Formulas - Calculate values automatically ✅ Relations - Connect databases together ✅ Rich Data Types - Files, dates, people, and more
Related Features
- Workspaces - Organize databases by workspace
- Pages - Link databases to pages
- Search - Find database rows globally
Last Updated: December 2024