Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
---
title: "Databases"
icon: "database"
description: "Typed records you can view as a table, a board, or a timeline."
---
A database tracks records that share a shape, such as parts, vendors, applicants, or a pipeline. Each row is one record. Each column is a field on that record.
Choose **Database** from the **Create** menu, or choose **New → Database** in [Drive](/product/drive).
<div className="db-preview" role="img" aria-label="Parts Tracker database open to the Parts table, All records view">
<div className="db-preview-top">
<span className="db-preview-close" aria-hidden="true">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none"><path d="m6 6 12 12m0-12-12 12" stroke="currentColor" strokeWidth="2" strokeLinecap="round" /></svg>
</span>
<span className="db-preview-name">
<svg className="db-preview-db" width="16" height="16" viewBox="0 0 24 24" fill="none" aria-hidden="true"><path d="M4 5.5a8 3 0 1 0 16 0 8 3 0 1 0-16 0Z" stroke="currentColor" strokeWidth="2" /><path d="M4 5.5v13c0 1.65 3.6 3 8 3s8-1.35 8-3v-13M4 12c0 1.65 3.6 3 8 3s8-1.35 8-3" stroke="currentColor" strokeWidth="2" strokeLinecap="round" /></svg>
<span>Parts Tracker</span>
</span>
<span className="db-preview-icon" aria-hidden="true">
<svg width="16" height="16" viewBox="0 0 24 24" fill="currentColor"><path d="M5 10.65a1.35 1.35 0 1 0 0 2.7 1.35 1.35 0 0 0 0-2.7Zm7 0a1.35 1.35 0 1 0 0 2.7 1.35 1.35 0 0 0 0-2.7Zm7 0a1.35 1.35 0 1 0 0 2.7 1.35 1.35 0 0 0 0-2.7Z" /></svg>
</span>
<span className="db-preview-tab is-on">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none" aria-hidden="true"><rect x="3" y="4" width="18" height="16" rx="2.5" stroke="currentColor" strokeWidth="2" /><path d="M3 9h18M9 9v11m6-11v11M3 14.5h18" stroke="currentColor" strokeWidth="2" /></svg>
<span>Parts</span>
</span>
<span className="db-preview-tab">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none" aria-hidden="true"><rect x="3" y="4" width="18" height="16" rx="2.5" stroke="currentColor" strokeWidth="2" /><path d="M3 9h18M9 9v11m6-11v11M3 14.5h18" stroke="currentColor" strokeWidth="2" /></svg>
<span>Vendors</span>
</span>
<span className="db-preview-icon" aria-hidden="true">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none"><path d="M12 5v14M5 12h14" stroke="currentColor" strokeWidth="2" strokeLinecap="round" /></svg>
</span>
</div>
<div className="db-preview-views">
<span className="db-preview-view is-on"><span>All records</span></span>
<span className="db-preview-plus" aria-hidden="true">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none"><path d="M12 5v14M5 12h14" stroke="currentColor" strokeWidth="2" strokeLinecap="round" /></svg>
</span>
</div>
<div className="db-preview-table">
<div className="db-preview-row is-head">
<span>#</span>
<span className="db-preview-h">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none" aria-hidden="true"><path d="M4 20l4.75-1 11-11a2.3 2.3 0 0 0-3.25-3.25l-11 11L4 20Z" stroke="currentColor" strokeWidth="2" strokeLinejoin="round" /><path d="m14.5 6.75 3.25 3.25" stroke="currentColor" strokeWidth="2" /></svg>
<span>Part</span>
<svg className="db-preview-caret" width="12" height="12" viewBox="0 0 24 24" fill="none" aria-hidden="true"><path d="m6.75 9.5 5.25 5 5.25-5" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round" /></svg>
</span>
<span className="db-preview-h">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none" aria-hidden="true"><path d="M4 20l4.75-1 11-11a2.3 2.3 0 0 0-3.25-3.25l-11 11L4 20Z" stroke="currentColor" strokeWidth="2" strokeLinejoin="round" /><path d="m14.5 6.75 3.25 3.25" stroke="currentColor" strokeWidth="2" /></svg>
<span>Part #</span>
<svg className="db-preview-caret" width="12" height="12" viewBox="0 0 24 24" fill="none" aria-hidden="true"><path d="m6.75 9.5 5.25 5 5.25-5" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round" /></svg>
</span>
<span className="db-preview-h">
<svg width="14" height="14" viewBox="0 0 24 24" fill="none" aria-hidden="true"><path d="M9 6h12M9 12h12M9 18h12" stroke="currentColor" strokeWidth="2" strokeLinecap="round" /><path d="M3.75 5a1 1 0 1 0 0 2 1 1 0 0 0 0-2Zm0 6a1 1 0 1 0 0 2 1 1 0 0 0 0-2Zm0 6a1 1 0 1 0 0 2 1 1 0 0 0 0-2Z" fill="currentColor" /></svg>
<span>Category</span>
</span>
</div>
<div className="db-preview-row">
<span className="db-preview-num">1</span>
<span>M6 Hex Socket Cap Screw</span>
<span>FST-1006</span>
<span><span className="db-preview-pill"><span className="db-preview-dot is-blue" /><span>Fasteners</span></span></span>
</div>
<div className="db-preview-row">
<span className="db-preview-num">2</span>
<span>Nylon Lock Nut M6</span>
<span>FST-1012</span>
<span><span className="db-preview-pill"><span className="db-preview-dot is-blue" /><span>Fasteners</span></span></span>
</div>
<div className="db-preview-row">
<span className="db-preview-num">3</span>
<span>Spindle Bearing Housing</span>
<span>CST-2201</span>
<span><span className="db-preview-pill"><span className="db-preview-dot is-purple" /><span>Castings</span></span></span>
</div>
<div className="db-preview-row">
<span className="db-preview-num">4</span>
<span>Gearbox Cover, Aluminum</span>
<span>CST-2215</span>
<span><span className="db-preview-pill"><span className="db-preview-dot is-purple" /><span>Castings</span></span></span>
</div>
</div>
</div>
## Types
A column holds one kind of value.
- **Text**
- **Number**
- **Select** and **Multi-select**, dropdowns with a color on each option
- **Date**
- **Time range**
- **Checkbox**
- **URL**
- **People**, **Documents**, and **Tasks**, a mention of that Block
- **Formula**, calculated from other columns
- **Related table**, a link to records in another table in this database
## Editing a database
Click a cell to edit it. Changes save as you work. Type in the empty row under the records to add a record. Click a row number, or choose **Open record**, to edit that record.
**Add column** adds a field. **Change type** on a column header sets what that field holds. **+ → New table** adds another table. **New view** saves the records as a table, a board, or a timeline.
## Collaborating
Other people in the database show up by name on the cells they have selected, and their edits appear as they save. If two people change the same cell, the later save stands. **Share** adds people or channels. On a team, **Team access** sets view, comment, or edit for the whole team. A saved view is the same for everyone who can open the database.
## Mentions
Type `@` in a cell to mention a Block. A column can hold a person, document, task, channel, email, project, company, or contact.
## AI editing
**AI** in the header opens a conversation with this database attached. The agent can answer questions about the records, or edit the records, columns, and tables. A [routine](/product/routines) can update them.