🐝Mới: bot AI làm công việc của bạnTìm hiểu thêm →
Tính năng BusyBee.Day

Databases

Excel-style tabular data with formulas, relations, and aggregations - inside BusyBee.Day

Capture structured data with the rigor of a spreadsheet and the discipline of a database. Formulas, linked records, rollups, and aggregations. Seven field types. Excel-style editing. Connect to tasks via relations - no separate Airtable required.

Bắt đầu miễn phíXem giá
Cập nhật lần cuối May 5, 2026

Database content type - Excel-style grid with seven field types, formulas, and aggregations.

Câu trả lời nhanh

databases là gì?

A database in BusyBee.Day is a tabular content type with rows and columns, formulas, and relations. Unlike a task list, it is meant for structured data that does not have a status or due date - records, lookups, and metrics. Unlike a spreadsheet, it has typed fields and can link to tasks and other databases.

Cách hoạt động

How to create and use a database in BusyBee.Day

Create a database, define columns, type values, add formulas.

  1. 1

    Create the database

    In a project or workspace, add new → Database. Same place you would add a document or whiteboard.

  2. 2

    Define columns

    Pick a field type per column - text, number, checkbox, date, select, multi-select, URL, formula.

  3. 3

    Type values

    Inline editing with tab / shift+tab / enter. Paste CSV/TSV from Excel or Google Sheets to bulk-import.

  4. 4

    Add formulas

    In a formula column, type `=A1*0.21` or `=IF(status="done", 1, 0)`. Standard spreadsheet syntax.

  5. 5

    Link to tasks

    A relation column lets you link any row to a task or another database row. Roll up task counts or status.

Trường hợp sử dụng

Ai sử dụng databases?

CRM lite

Contacts, companies, deals as separate databases. Linked relations capture which deal belongs to which contact. Link rows to follow-up tasks.

Inventory & assets

Lab equipment, marketing collateral, hardware leases - rows with serial number, owner, purchase date, value. Formulas calculate depreciation.

Content calendar

Posts as rows with title, channel, status, publish date, owner. Linked to writing tasks. Aggregations count posts per channel.

Metrics tracking

Weekly KPIs as rows - revenue, signups, churn. Formulas compute deltas; charts (coming) visualize trends.

Tất cả bao gồm

Tóm tắt khả năng

  • Excel-style inline editing with full keyboard navigation
  • Seven field types - text, number, checkbox, date, select, multi-select, URL
  • Formulas with SUM, AVG, IF, CONCAT, and the operators you expect
  • Linked records between databases and to tasks
  • Aggregations - count, sum, average, min, max, percent complete
  • Lives next to tasks, projects, and documents in the same workspace
  • Per-row activity log and comments
  • CSV / TSV import via paste
So sánh

BusyBee.Day Database vs Airtable vs Notion databases

CapabilityBusyBee.Day DatabaseAirtableNotion DB
Tabular grid with typed fieldsYes (7 types)Yes (20+ types)Yes (15+ types)
Spreadsheet-style formulas=SUM, =IF, =CONCATFormula fieldFormula field
Linked records / relationsYesYesYes
Roll-ups & aggregationsYesYesYes
Lives next to tasks & docs in same appYes (native)No (separate app)Yes (same app)
Free tier editor capUnlimited (solo)5 editorsUnlimited (solo)
Starting paid plan$9/user/mo$20/user/mo$10/user/mo

So sánh phản ánh các tính năng và giá có sẵn công khai tính đến May 5, 2026. Có thể thay đổi.

Câu hỏi thường gặp

Câu hỏi thường gặp

How is BusyBee.Day Database different from a spreadsheet?

Spreadsheets have untyped cells - a column can mix text and numbers, and formulas operate on any value. BusyBee.Day Database has typed columns: number columns reject text, date columns enforce a date format, select columns offer predefined options. It also supports linked records and integrates with the rest of BusyBee.Day.

Can I import data from Airtable or Notion?

Export the source as CSV, then paste into a BusyBee.Day Database. Field types map directly. A native Airtable/Notion import is on the roadmap.

What formula functions are supported?

Arithmetic operators (+ - * / ^), comparison (= < > <= >= !=), and the common spreadsheet functions: SUM, AVG, MIN, MAX, IF, AND, OR, NOT, COUNT, CONCAT, LEN, LOWER, UPPER, ROUND, NOW.

Can I link a database row to a task?

Yes. A relation field type lets you reference any task or row in another database. Use it for CRM-style "this deal has these tasks" or "this inventory item has these maintenance tasks".

Does a database have board / calendar / gallery views?

No. Those views belong to BusyBee.Day Tasks. The Database content type is intentionally Excel-style only - tabular. If you want board / calendar / gallery, use a project with its 6 views and custom fields.

What plan do I need to use Databases?

Databases are available on the Basic plan ($9/user/mo) and above. The Free plan supports rich text documents only.
🐝
Được viết bởi đội ngũ sản phẩm BusyBee.Day
Đội ngũ sản phẩm phần mềm năng suất tại BusyBee.Day. Xác minh lần cuối May 5, 2026.

Tính năng liên quan

Project Management

Six views for any workflow - Kanban, list, table, calendar, timeline, gallery

Custom Fields

Adapt tasks to your workflow with text, number, checkbox, date, select, multi-select, and URL fields

Documents, Whiteboards & Databases

Rich text notes, visual whiteboards, relational databases, and embeds - all in one place

Task Management

Create, organize, and ship tasks with priorities, custom fields, and AI scheduling

Sẵn sàng dùng thử Databases?

Bắt đầu miễn phí - không cần thẻ tín dụng. Nâng cấp lên Pro bất cứ lúc nào cho đội nhóm, phân tích nâng cao và tự động hóa không giới hạn.

Bắt đầu miễn phíXem giá