Skip to main content
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.
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

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).
  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. 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. Bottari manual 13 pages (#940)