Table View

Table view shows all your notes in a spreadsheet-style grid. You can edit cells inline, sort by any column, filter with type-aware operators, and control which columns are visible. This page covers everything you can do in Table view.

Layout

Table view uses a two-column layout:

  1. Notebook sidebar (left) — Your notebooks and groups.
  2. Table (right) — A full-width spreadsheet grid with your notes as rows and fields as columns.

Each row is a note. Each column is a field. The first column is always a row number, followed by your field columns, and optionally system columns at the end.

Alternating rows have a subtle background tint for readability.

The full table view with columns, row numbers, and populated data

Selecting and Editing Cells

The table uses a click-to-select, click-to-edit pattern, similar to a spreadsheet.

First click on a cell selects it. A blue border appears around the cell, but you're not editing yet.

Second click on the same cell enters edit mode. A text cursor appears and you can type.

Clicking a different cell selects that cell instead and deselects the previous one. Clicking an empty area of the table deselects everything.

Interactive fields like Rating, Date, Toggle, Tags, Image, and Reference work on the first click — tapping them activates the control immediately.

Inline Editing

Changes save automatically as you type or interact with a field.

Most field types are editable inline:

  • Text fields (Short Text, Long Text, Email, Phone, URL) show a text input on second click.
  • Number shows a numeric input on second click. Whole numbers display without decimals.
  • Currency shows a numeric input on second click with the currency symbol prefix.
  • Rating shows tappable stars (first click).
  • Date shows a tappable date pill that opens a calendar picker (first click). Today's date displays in red.
  • Toggle shows a switch (first click).
  • Tags show a dropdown menu to toggle tags on or off (first click, when tags are configured).
  • Image shows a menu with options to add, replace, save, or remove the image (first click).
  • Reference shows a dropdown menu to select or change the linked note (first click).
  • Secret shows dots with an eye icon. Tap the eye to authenticate with Face ID or Touch ID, then follow the same click-to-select, click-to-edit pattern.

Some field types are read-only in the table:

  • Checklist shows a summary like "3/5 done."
  • Formula shows the computed result.
  • Duration shows the formatted time (e.g., "2h 30m").
  • Color shows a colored swatch and the hex value.
  • Percent shows a progress bar and the percentage.
  • Barcode and QR Code show the string value in monospaced text.

Layout fields (Divider and Description) don't appear in the table since they don't store data.

To fully edit read-only fields like Checklist, open the note (see Opening a Note) or switch to Notes view.

Sorting

Click any column header to sort the table by that column.

Clicking the same header cycles through three states:

  1. First click — Sort ascending (A to Z, smallest to largest, oldest to newest).
  2. Second click — Sort descending (Z to A, largest to smallest, newest to oldest).
  3. Third click — Clear the sort.

A chevron icon appears on the sorted column: up for ascending, down for descending.

A column header with the ascending sort chevron

Sorting works for both field columns and system columns (Title, Created, Updated). The sort preference is saved per notebook, so it persists when you leave and come back.

How Sorting Handles Different Types

  • Text fields (including Barcode and QR Code) sort alphabetically, case-insensitive. Empty values go to the end.
  • Numbers, Currency, Duration, and Percent sort numerically. Empty values go to the end.
  • Ratings sort by star count.
  • Dates sort chronologically. Empty values go to the end.
  • Toggles sort off before on.
  • Colors sort alphabetically by hex value.
  • Formulas sort numerically by computed value. Errors go to the end.

Filtering

The filter bar lets you narrow down your notes using precise, type-aware conditions. Click the filter icon in the toolbar to open it.

Adding a Filter

  1. Click Add Filter in the filter bar.
  2. Pick a field from the menu.
  3. Choose an operator (the available operators depend on the field type).
  4. Enter a value if the operator requires one.

The table updates in real time as you adjust the filter.

The filter bar with an active filter showing field picker, operator, and value input

Multiple Filters

You can add as many filters as you need. When multiple filters are active, a note must match all of them to appear in the table. The filter icon shows a badge with the number of active filters.

Operators by Field Type

Text fields (Short Text, Long Text, Email, Phone, URL, Barcode, QR Code):

  • contains — Matches if the value includes the text anywhere.
  • equals — Matches the exact value.
  • starts with — Matches if the value begins with the text.
  • is empty — Matches fields with no value.
  • is not empty — Matches fields that have a value.

Number, Currency, Duration, and Percent:

  • equals — Exact numeric match.
  • greater than — Value is above the number you enter.
  • less than — Value is below the number you enter.
  • between — Value falls within a range (two inputs).
  • is empty / is not empty

Rating:

  • equals — Exact star count.
  • at least — Star count is this number or higher.
  • at most — Star count is this number or lower.

Date:

  • equals — Same calendar day.
  • before — Earlier than the selected date.
  • after — Later than the selected date.
  • between — Falls within a date range (two date pickers).
  • is empty / is not empty

Toggle:

  • is on — The switch is turned on.
  • is off — The switch is turned off.

Tags:

  • has any of — The note has at least one of the tags you specify.
  • has all of — The note has every tag you specify.
  • is empty / is not empty

Checklist:

  • has items — The checklist has at least one item.
  • all done — Every item in the checklist is checked.
  • not all done — At least one item is unchecked.
  • is empty — The checklist has no items.

Image:

  • has image — An image has been added.
  • no image — No image is present.

Color:

  • equals — Exact hex value match.
  • is empty / is not empty

Formula:

  • equals / greater than / less than / between — Numeric comparisons on the computed value.
  • is empty / is not empty

Removing a Filter

Click the X button next to any filter to remove it. The table updates immediately.

Group By

The group-by feature lets you organize your table rows into collapsible sections based on a field's value. Click the group-by icon (a square grid icon) in the toolbar to open the group-by picker.

Supported Field Types

  • Tags — Groups by each tag value. Notes with multiple tags appear in multiple groups. An additional "No value" group collects untagged notes.
  • Toggle — Groups into "Yes" and "No" sections.
  • Rating — Groups by star count, from 5 stars down to 1, plus a "No rating" group.

Collapsible Sections

Each group shows a section header with a chevron, the group label, and a note count. Click the chevron to collapse or expand a group. Collapsed groups are saved per notebook, so they persist when you navigate away and come back.

Clearing Group By

Open the group-by picker and select None to return to a flat table. The group-by icon is tinted when grouping is active.

Searching

The search bar at the top of the table lets you filter notes by text. Type any text and the table narrows to notes that contain a match in any field value. The search is case-insensitive.

Search and filters work together. If both are active, notes must match the search text and pass all filters.

Clear the search by clicking the X button or deleting the text.

Column Visibility

Not every field needs to be visible in the table. Click the column visibility icon (three vertical columns) in the toolbar to open the column picker.

The column picker popover with visibility checkboxes and system columns

The picker shows:

  • Field columns — Each field with a checkbox, its type icon, and its name. Uncheck a field to hide its column.
  • System columns — Three optional columns you can show or hide:
    • Title — The note's custom title (only available when "Use first field as note title" is turned off in notebook settings).
    • Created — When the note was created.
    • Updated — When the note was last modified.

System columns appear after your field columns. You must always have at least one visible column.

Hidden columns are saved per notebook.

Row Height

By default, text in table cells is truncated to a single line. You can expand rows to show more content using the row height button in the toolbar (the up-and-down arrow icon, next to the column visibility button).

Click the button to open the row height picker with three options:

Option Lines Best for
Short 1 line Compact view, scanning many rows quickly (default)
Medium 2 lines Seeing a bit more context without expanding too much
Tall 4 lines Reading longer text like descriptions or notes

The row height applies to text-based fields (Short Text, Long Text, Email, Phone, URL, Secret when revealed, Barcode, QR Code), Tags, References, Formulas, and the Title system column. Fields with inherently short values — like Number, Currency, Rating, Date, Duration, Percent, and Color — always display on one line regardless of this setting.

The row height button is tinted when set to anything other than Short, so you can tell at a glance if rows are expanded.

Your row height preference is saved per notebook.

Resizing Columns

Drag the border between any two column headers to resize. A resize cursor appears when you hover over the border on Mac.

Columns have a minimum width of 60 pixels. Your custom widths are saved per notebook.

When you show a previously hidden column or add a new field, it gets a proportional default width based on its type. Text fields get more space, toggles get less.

Reordering Columns

Drag any column header left or right to move it to a new position. A colored indicator shows where the column will land.

This only changes the column order in the table. The field order in Notes view is independent and stays the same.

System columns (Title, Created, Updated) always stay at the end and cannot be reordered.

Row Selection

Click the row number (the # column on the left) to select an entire row. The row highlights in blue.

On Mac, hold Shift and click another row number to select a range of rows.

Click the same row number again to deselect it. Clicking a cell in the table also clears the row selection.

Opening a Note

You can open a note's full detail view directly from the table. This lets you see and edit all fields — including ones that are read-only in the table like Checklist, Duration, and Color — without switching to Notes view.

There are three ways to open a note:

  • Right-click the row number and choose Open Note from the context menu.
  • Select a row (click the row number) and press Enter.
  • Double-click the row number (Mac only).

On Mac, the note opens in a separate window. You can keep the window open alongside the table and edits sync between them in real time. The window title shows the notebook name and note name. If you quit and relaunch the app, the window reopens automatically.

On iPhone and iPad, the note opens as a sheet that slides up from the bottom. Swipe down or tap outside to dismiss.

The detail view in this mode is focused on editing values — field management controls (the three-dot menu per field, drag to reorder fields, and the "Add Field" button) are hidden. To manage fields, use the Fields tab in notebook settings.

Context Menu

Right-click any cell to open the context menu. It includes:

  • Open Note — Opens the note's full detail view (see Opening a Note above).
  • Clear Value — Removes the value from this cell.
  • Copy — Copies the cell's value to the clipboard.
  • Paste — Pastes clipboard text into this cell.
  • Duplicate Row — Creates a copy of the entire note.
  • Delete Row — Deletes the note (with confirmation).
  • Delete Column — Deletes this field from the entire notebook (with confirmation). This removes the column and all its data from every note.

Right-click a row number to get the same menu with Open Note at the top.

Keyboard Shortcuts (Table View)

The table view supports full keyboard navigation on Mac, similar to a spreadsheet. iOS uses touch interaction for all of these actions.

Shortcut Action
/ Move to the previous or next row. When a cell is selected, moves to the same column in the adjacent row. If nothing is selected, selects the first row and selects the last row.
/ Move to the previous or next cell within a row. Wraps to the adjacent row at row boundaries. When a row is selected, selects the first cell and selects the last cell. Does nothing at the very first or last cell of the table.
Tab Move to the next cell. Wraps to the first cell of the next row at the end of a row. At the last cell of the last row, wraps back to the first cell of the first row. Also works while editing — confirms the edit and moves to the next cell.
Shift+Tab Move to the previous cell. Wraps to the last cell of the previous row at the start of a row. At the first cell of the first row, wraps to the last cell of the last row. Also works while editing.
Cmd+↑ Jump to the first row (same column).
Cmd+↓ Jump to the last row (same column).

Selection

Shortcut Action
Shift+↑ / Shift+↓ Extend the selection by one row up or down.
Cmd+Shift+↑ Select all rows from the current row to the first row.
Cmd+Shift+↓ Select all rows from the current row to the last row.
Cmd+A Select all rows.

Editing

Shortcut Action
Enter Start editing the selected cell (text fields only). When a row is selected, opens the note's full detail view. When already editing, confirms the edit and moves down one row. On the last row, pressing Enter while editing creates a new note.
Space Toggle a Toggle field on or off (when the cell is selected but not in edit mode).
Escape If editing, stop editing but keep the cell selected. If a cell or row is selected, deselect it. Pressing Escape multiple times progressively deselects: editing → cell selected → nothing selected.

Actions

Shortcut Action
Delete Clear the selected cell's value. If one or more rows are selected, delete them (with a confirmation dialog).
Cmd+C Copy the selected cell's value. If rows are selected, copy all rows as tab-separated text (with a header row of field names).
Cmd+V Paste clipboard text into the selected cell. Works with text-based fields (Short Text, Long Text, Email, Phone, URL, Number, Currency, Color, Barcode, QR Code, Duration, Percent, and Secret when revealed). Read-only fields like Formula and Image are not affected.

Creating and Deleting Notes

Creating a Note

Click the + button in the toolbar or press Cmd+N on Mac. A new row appears at the top of the table, ready for editing.

Deleting a Note

Right-click any cell and choose Delete Row, or select a row by clicking its row number and press Delete. A confirmation dialog appears before the note is permanently deleted.

esc
Type to search across all documentation pages.