News / Richer field types — calculations, sub-tables & lookups

Richer field types — calculations, sub-tables & lookups

A table is only as useful as the field types it supports. This release adds a set of new ones so you can model the real shape of your work instead of flattening everything into plain text columns.

What's new

  • Calculation fields — compute a value from other fields in the record: totals, margins, days-until-due, full names, status labels. Calculations can even be used as the record's title, so lists read the way you think.
  • Sub-tables — nested records inside a record. Perfect for line items on an invoice, tasks under a project, or attendees on an event — the detail lives with its parent instead of in a separate, disconnected table.
  • Lookups — pull live values from a related table so you're never copying data by hand. Change it once at the source and every lookup follows.
  • User fields — assign a record to a person on your team, ready for the notifications and tasks features to build on.
  • Sorting — order records the way you actually work, not just by the order they were entered.

Why it matters

Most "spreadsheet problems" are really modeling problems — the data has structure the spreadsheet can't express, so people paper over it with copy-paste and colour-coding. These field types let the structure live in the data itself, which means fewer mistakes and far less manual upkeep.

See them all on the features page, or read up on formulas in the help docs.