Create a database
- In the Docs tab, hover over a space and press + (Add to this space).
- Choose New database.
- 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.
/ 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
- In a table, press + (Add property) at the right end of the header row. In an open page, press Add property under the properties.
- Type a name in Property name… (optional).
- Under Type, pick a type.
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.
Create a relation property
A relation links pages in one database to pages in another database, or in the same one.- Press Add property (see Add a property).
- Under Type, choose Relation.
- 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).
- 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.
- Press Add relation.
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
- Press + (Add view) next to the view tabs. It’s there for people who can edit the database’s structure.
- Pick a layout: Table, List, Board, Gallery, Feed, Calendar, Timeline or Chart.
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.
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.