Appearance
Databases
A database in Aurora is a collection of pages with structured properties. Each row is a full page: click any row to open it in the editor.
Creating a database
- Click New page in the sidebar and choose Database, or
- Type
/databaseinside any page to create one inline, or/linkedto show an existing database inline.
Views
Each database can have several views. Pick the layout from the view menu at the top of the database.
| View | Description |
|---|---|
| Table | Spreadsheet-style rows and columns, with optional sub-items and dependencies |
| List | Compact vertical list |
| Gallery | Card grid with cover images |
| Board | Columns grouped by a property such as Select, Status or Person. Move cards with the mouse, the keyboard or touch. |
| Timeline | Rows laid out by date, using the first two Date properties as start and end |
| File archive | Upload files into the database and browse them by name, type, size and upload date |
Plugins can add more views. The built-in Chart and Pie Chart plugins add a bar chart and a donut chart grouped by a property, and the optional Board (WIP limits) plugin adds a board with column limits. Manage them in Settings → Plugins.
Named view tabs
Save several named views on the same database. Each view keeps its own layout, filters, sorting, grouping and visible columns. Click + View to add one.
Properties
Every row can have any number of properties. Built-in types:
| Type | Description |
|---|---|
| Text | Text |
| Number | Numeric value |
| Progress | A percentage shown as a progress bar |
| Date | A date, or a date and time |
| Checkbox | Yes or no |
| Select | One option from a list |
| Multi-select | Several options from a list |
| Status | Options grouped into the stages To do, In progress and Done |
| URL | A clickable link |
| Email address | |
| Phone | Phone number |
| File | File attachment |
| Person | A workspace member or a People page |
| Location | Map coordinates. Edit them by hand or pick a point on a map. |
| Relation | Link to other pages or rows |
| Created by, Last edited by | Filled in automatically from who created or last changed the row |
| Created time, Last edited time | Filled in automatically |
| ID | A counting number with an optional prefix, such as TASK-14, assigned to each new row |
| Button | Runs actions on its row when clicked, such as setting a property or opening a page |
Plugins add more property types, such as Rating, Currency, Duration, Color and Date range.
Formula and Rollup columns can appear in a database, for example after an import, but they are read-only there. To create formulas and rollups, add them to a page type in Settings → Workspace → Page types (see Pages).
ID numbers
An ID is assigned on the device, so it works offline. If two devices give out the same number, the row created first keeps it.
Buttons
A Button property puts a button in every row. Its actions run on that row: set or clear a property, toggle a checkbox, add a row to a database, open a page, or open a link. A button can ask for confirmation first. Buttons run on your device, so they work offline and in end-to-end encrypted workspaces. For a button inside a page, type /button.
Sub-items and dependencies
In a table view, open the column menu and choose:
- Add sub-items to nest rows under a parent row. Use Show sub-items and Hide sub-items to expand and collapse them.
- Add dependencies to let a row list the rows that block it. A blocked row shows a Blocked badge until the rows it waits on are done.
Filtering
Open Filter to add filter rules. Combine rules with AND (all must match) or OR (any must match). Each rule has a property, a condition and a value.
Conditions include contains, does not contain, equals, does not equal, starts with, ends with, is empty and is not empty. Numbers add is greater than, is at least, is less than and is at most; dates add is before, is after, is on or before and is on or after.
Date rules can use a relative period instead of a fixed date: Today, Yesterday, Tomorrow, This week, Last week, Next week, This month, Last month, Next month, This year, Past 7 days, Next 7 days, Past 30 days or Next 30 days.
Sorting
Open Sort to add sort rules. Several sort rules apply in order. In a table, Shift-click a column header to add a secondary sort.
Grouping
Open Group to group the rows of a table, list or gallery by a property. A board is always grouped.
Summaries
Columns can show a summary below the rows: Count, Sum, Average, Min, Max or Unique count.
Quick filter
Type in the Quick filter field in the database toolbar to narrow the rows by text.
Relations and rollups
A Relation property links rows to other pages or rows. A Rollup on a page type can then summarise the linked pages, for example by counting them or summing a number property.
Properties on any page
Properties aren't just for databases. You can add structured properties to any page from its Properties panel, which turns any note into a small database entry.
Tags
The built-in tags property is available in database and collection views. Hashtags typed in page content sync into the page's tags, so tag pages and database filters line up. See Tags, flags & trash.
