Databases in Notes: fields, views and CSV import
Make a database inside a page, add fields of ten kinds, see the rows as a table, board, list, calendar, timeline or chart, and bring rows in from a CSV file.
A database in Notes lives inside a page: rows with fields, which you can look at in several views — a table, a board, a calendar and more. Use it for a content plan, a list of suppliers, a hiring tracker or anything you would keep in a spreadsheet.
Create a database
- In a page, type /database and choose Database — or on Home choose Organise → New database, which makes a new page with one.
- The block offers Create a database here and Import CSV. Click Create a database here for an empty one.
The new database opens in a Table view with one text field. The first text field names each row — it is the title on the cards of a board, a calendar and a timeline.
Rows
- + New row under the table adds a row; click a cell to fill it.
- The row's menu (⋯ at the end of the row) has Delete row.
- Click a column's header to sort the rows by it: once ascending, again descending, a third time back to the order you made. The sort is not saved.
Fields
- Click + at the end of the table's header, or the view's ⋯ → New field.
- Type the Field name and choose the Type:
- Text, Number, Checkbox, Date, URL, Email;
- Select — type its Options, separated with commas;
- Relation, Roll-up and Formula — see Relations, roll-ups and formulas.
- Choose its Access — who may see and change it (Relations, roll-ups and formulas explains the four levels) — and click Add field.
A field cannot be renamed or deleted in Notes yet — choose the name with care.
Views
The views are tabs over the database. + View adds one: Table, Board, List, Calendar, Timeline or Chart. The view's ⋯ → Delete the view “…” removes the open view; a database always keeps at least one.
- Board — a column for each option of a Select field (Group by), plus No value. Drag a card to another column to change its option. The order of cards inside a column is not kept.
- List — each row on one line: its title, then its other filled values.
- Calendar — rows on the day of a Date field (Date field). Drag a row onto a day to give it a date.
- Timeline — bars from a Start date to an End date; without an end field, each bar is one day. Drag a bar to move its dates.
- Chart — bars for each option of a Select field (Group by), measured by Row count or Sum of a number field.
Import a CSV file
- Put a new Database block in the page.
- Click Import CSV and choose the file.
The first row of the file becomes the field names; a column whose every filled value is a number becomes a Number field, every other column a Text field. The database takes the file's name. The file can be up to 5 MB and 5,000 rows, in UTF-8.
Notes has no CSV export. Export (JSON) in the page's ⋯ saves the page with its content: Import and export.
If something doesn't work
"Board needs a Select field — add one from the table view."
The board groups rows by a Select field and the database has none. Click + New field, choose Select and type its options.
"Calendar needs a Date field — add one from the table view."
The calendar and the timeline place rows by a Date field. Add a Date field, then fill it in the rows.
"You can’t change this field — it needs full access to the page."
The field's Access lets only people with Full access to the page change it. Ask someone with full access, or an admin.
"Could not import the CSV: …"
The block says why the file was not accepted: CSV needs a header row, CSV exceeds 5000 rows, The file is over 5 MB., or that the file did not reach Notes. Fix the file — split it, add the header row — and try again: the block stays empty, so you can retry in place.
"No rows with a date filled in."
The timeline shows only rows with a date in the Start field. Fill the dates in the Table view.