> ## Documentation Index
> Fetch the complete documentation index at: https://docs.macro.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Databases

> 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](https://docs.macro.com/product/drive).

Parts Tracker

Parts

Vendors

All records

\#

Part

Part #

Category

1
M6 Hex Socket Cap Screw
FST-1006
Fasteners

2
Nylon Lock Nut M6
FST-1012
Fasteners

3
Spindle Bearing Housing
CST-2201
Castings

4
Gearbox Cover, Aluminum
CST-2215
Castings

## 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](https://docs.macro.com/product/routines.md) can update them.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.