Skip to content

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 /database inside any page to create one inline, or /linked to 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.

ViewDescription
TableSpreadsheet-style rows and columns, with optional sub-items and dependencies
ListCompact vertical list
GalleryCard grid with cover images
BoardColumns grouped by a property such as Select, Status or Person. Move cards with the mouse, the keyboard or touch.
TimelineRows laid out by date, using the first two Date properties as start and end
File archiveUpload 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:

TypeDescription
TextText
NumberNumeric value
ProgressA percentage shown as a progress bar
DateA date, or a date and time
CheckboxYes or no
SelectOne option from a list
Multi-selectSeveral options from a list
StatusOptions grouped into the stages To do, In progress and Done
URLA clickable link
EmailEmail address
PhonePhone number
FileFile attachment
PersonA workspace member or a People page
LocationMap coordinates. Edit them by hand or pick a point on a map.
RelationLink to other pages or rows
Created by, Last edited byFilled in automatically from who created or last changed the row
Created time, Last edited timeFilled in automatically
IDA counting number with an optional prefix, such as TASK-14, assigned to each new row
ButtonRuns 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.

Aurora is in public beta and free while beta.