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

# Databases

A database is a set of pages that share the same properties, shown in views such as a table or a board. Use it to track work, notes or anything else your team keeps in rows.

## Create a database

1. In the **Docs** tab, hover over a space and press ＋ (**Add to this space**).
2. Choose **New database**.
3. Bottari asks **What kind of database?** Pick one:
   * **Blank database**: **Set up your own properties and views**.
   * **Agent database**: **The agent resolves approved to-dos and opens PRs**. See [Agent database](https://help.bottari.ai/en/09-agent-database.md).

Only space admins and up can create an agent database. For everyone else that card is locked.

You can also put a database inside a page. Type `/` in the page and choose **Database - Inline** or **Database - Full page**. To show a database that already exists, choose **Linked view of database**.

## Rows are pages

Each row of a database is a page. Its properties sit at the top, above the page body.

* **New** (top right of the database) adds a new page.
* In a table, hover over a row's name and press **Open** to open it.
* In an open page, the **Change view options** button switches between **Side peek**, **Center peek** and **Full page**.
* To set how a view opens its pages, go to **View settings** › **Layout** › **Page view**.

## Add a property

1. In a table, press ＋ (**Add property**) at the right end of the header row. In an open page, press **Add property** under the properties.
2. Type a name in **Property name…** (optional).
3. Under **Type**, pick a type.

If you leave the name empty, the property is named after its type.

You can also add one from **View settings** › **Edit properties** › **New property**.

### Property types

| Group | Types |
| - | - |
| Basic | **Text**, **Number**, **Select**, **Multi-select**, **Status**, **Date**, **Person**, **Files & media**, **Checkbox**, **URL**, **Email**, **Phone** |
| Connected | **Formula**, **Relation**, **Rollup** |
| Filled in for you | **Created time**, **Created by**, **Last edited time**, **Last edited by**, **Button**, **ID** |

A database can have only one **ID** property.

## Edit, hide or delete a property

Click a property's name (the column header in a table) to open its menu:

* Type in the name box at the top to rename it.
* **Edit property** changes its settings, such as options or number format.
* **Change type** changes its type.
* **Duplicate property** makes a copy.
* **Hide in this view** hides it in this view only.
* **Delete property** deletes it from every page in the database.

A deleted property goes to **View settings** › **Edit properties** › **Deleted properties**. Press **Restore** there to bring it back.

To choose which properties a view shows, open **View settings** › **Shown fields**.

Changing properties needs edit rights to the database's structure. A locked database can't be changed until someone unlocks it (**Lock database** in **View settings**).

## Create a relation property

A relation links pages in one database to pages in another database, or in the same one.

1. Press **Add property** (see [Add a property](#add-a-property)).
2. Under **Type**, choose **Relation**.
3. Pick the database to link to. Search for it in **Link a data source**. To link pages in the same database, choose the entry marked **… (this database)**.
4. Check the settings:
   * The name box: the property's name. If you didn't type a name earlier, it starts as the other database's name (**Related …** for the same database).
   * **Related to**: the database you picked. Click it to pick another.
   * **Limit**: **1 page** or **No limit**.
   * **Two-way relation** (in the same database, **Add related property**): turn it on to also add a matching property on the other side. Name it in **Related property name**. A two-way relation to another database needs edit rights to that database's structure, and that database must be unlocked.
5. Press **Add relation**.

With **Two-way relation** on, linking page A to page B also shows A in B's matching property.

### Link pages

Click a relation cell. Search in **Link or create a page** and press **Link page** next to a page. If no page has exactly the title you typed, the list also offers to create one in the other database (when you can add pages there).

If the limit is **1 page**, linking another page replaces the one already there. If the matching property on the other side is limited to **1 page** and the page you pick is already linked elsewhere, Bottari asks before moving it.

### Change or delete a relation

In the property's menu, **Edit property** lets you change **Limit** and turn the two-way link on or off. When you delete a two-way relation, choose **Delete this property only** or **Delete the related property too**.

## Rollups and formulas

A **Rollup** shows values from pages linked by a relation. Add the rollup, then open **Edit property** and choose **Relation**, **Property** and **Calculate**. Add a relation first; without one, the rollup has nothing to read.

A **Formula** calculates a value from other properties. Open **Edit property** › **Edit formula** to write it.

## Views

A view is one way of looking at the same pages. Each view keeps its own layout, filters, sorts and grouping.

### Add a view

1. Press ＋ (**Add view**) next to the view tabs. It's there for people who can edit the database's structure.
2. Pick a layout: **Table**, **List**, **Board**, **Gallery**, **Feed**, **Calendar**, **Timeline** or **Chart**.

To change a view's layout later, open **View settings** › **Layout**.

### Group

**View settings** › **Group by** groups pages by a property. Choose **None** to turn it off. A board also has **Sub-group**. Calendar and gallery views don't group.

## Filter and sort

* Filter: press the filter button above the view (**Filter**) and pick a property, then set the condition.
* Sort: press the sort button (**Sort**) and pick a property. To add more, use **Add sort**. Add more sorts and drag them to change their order. **Remove all sorts** clears them.

You can also start a filter from a column header: **Filter** in the property's menu.

### And / or filters

In the filter list, choose **Add advanced filter**. Then:

* **Add filter rule** adds a condition.
* **Add filter group** adds a nested group of conditions.
* The word between the first two conditions switches between **And** and **Or**.

### Save filters for everyone

Filters and sorts you change apply only on your screen at first. To keep them in the view for the whole team, press **Save for everyone**. **Reset** goes back to the saved view.

**Save for everyone** appears only for people who can edit the database's structure.

## Page templates

A template is a ready-made page. New pages can start from it.

* Press the arrow next to **New** to see the **Templates**. Pick one to create a page from it, or pick **Empty**.
* **New template** creates a template.
* On a template's ⋯ menu: **Set as default**, **Edit**, **Duplicate**, **Delete**.

The default template is marked **Default**. Pressing **New** itself uses it. With no default, it makes an empty page.

A new empty page also lists the templates. Press Enter to keep the page empty, or pick a template.

Creating and changing templates needs edit rights to the database's structure.

<sub>Bottari manual 13 pages (#940)</sub>


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