Help center

Rows

A row is one record in the table. You add rows, fill them in cell by cell, and edit them right in the grid — there is no save button, changes are kept automatically, even offline. Each cell behaves according to its column type. You can also open a row as a full record, browse from record to record without closing the panel, and delete rows you no longer need.

Add a row

The new record button sits at the top right of the toolbar and is available in every record-based view — Table, Gallery, Kanban, List and Calendar. It appends an empty row, ready to fill in.

  1. 1Open the table in any record view.
  2. 2Click the new record button (the + at the top right of the toolbar).
  3. 3A new empty row appears at the end, with each cell set to its type's default.
  4. 4Type the values cell by cell; everything is saved automatically as you go.
A form submission also creates a row: a public form built on this table drops each response in here as a new record. See the Forms module.

Edit cells

You edit values directly in the grid — click a cell and type or pick. How you edit depends on the column type:

  • Text, integer, decimal, currency, phone, email and URL: click and type. Number cells offer a minicalculator, and phone/email/URL show a quick button to dial, write or open the link.
  • Date: click to pick from the calendar.
  • Checkbox: click to toggle on or off.
  • Select: choose one option from the dropdown. Multi-select: add or remove colored tags — you can create new tags right there.
  • Rating: click a star (click the same star again to lower it). Progress: drag the slider or type the percentage.
  • Reference and task: pick the linked item; a button opens it. Attachment: add files or links. Image: paste a URL or upload a picture.
  • Formula, autonumber, lookup, rollup and reverse links: read-only — their values are computed by the app from the row or from linked records.
There is no save button: cell edits are stored automatically and the save indicator in the status bar shows the current state. If you are offline, changes are queued on this device and sent when the connection returns; closing the tab flushes anything still pending. Columns that depend on an edited cell (formulas, lookups, rollups — here and in linked tables) recalculate on their own.

Open a row as a record

To see and edit every field of a row in one place, open it as a record. Hover over the row and click the edit (pencil) button at the right end.

  1. 1Hover over the row to reveal its actions at the right end.
  2. 2Click the edit button to open the record panel.
  3. 3Change any field; the panel also shows the read-only system properties (created and edited, when and by whom).
  4. 4Use the previous record / next record arrows in the panel header to walk through the records without closing it.
  5. 5Click save to apply the changes, or cancel to discard them.

Delete a row

Hover over the row and click the delete (trash) button at the right end. A confirmation dialog shows which record will be removed before anything happens.

Deleting a row is permanent — rows do not go to a trash and cannot be restored. If in doubt, duplicate the table first (the table ⋯ menu) to keep a copy.

Large tables

Big tables stay fast: rows are loaded in pages as you scroll, with a load more records button at the end, and search and sorting run on the server over the whole table — not just the loaded part. The local cache makes reopening a table instantaneous.

For what each cell can hold, see Column types. To sort, filter or group your rows, see Filter and organize; to look at the same rows as gallery cards, Kanban, calendar or a chart, see Views.