A table is structured data your team keeps in rows and typed columns: a register, a tracker, a list of suppliers, the vendors you've assessed. Reach for one when the work is records rather than prose.
A table, a memory or a fact?
- A memory is something worth knowing, written in words. "We retry with exponential backoff, capped at 30s." Recall finds it by meaning.
- A fact is one thing asserted about a project, with a source and a date, that can be verified or go stale. See Facts and decisions.
- A table is many things of the same shape. If you'd catch yourself writing the same five fields down for the tenth time, or want to sort, filter and count them, it's a table.
A table can point at the other two. A column can hold a memory, a wiki page, an artifact, a fact or a decision, so a supplier row can link to the memory that says why you chose them.
Where a table lives
A table belongs to the whole workspace, or to one project, and you choose when you create it. A project's tables follow that project's visibility: tables in a private project are for its members, as its memories are. Someone who can't see a table won't find it in the list, in search, or by following a link from another table.
There's no per-table privacy beyond that. If a table needs to be private, put it in a private project.
Column types
| Type | Holds |
|---|---|
| Text, Long text | A line, or several paragraphs |
| Number | A number |
| Date, Date and time | A day, or a moment (shown in your time zone) |
| Checkbox | Yes or no. A box nobody ticked counts as no |
| Single select, Multiple select | One, or several, from a list of options you set |
| URL, Email, Phone | Checked as you save |
| Member | A person in the workspace |
| Kythene item | A memory, wiki page, artifact, fact or decision. Paste its Kythene link |
| Attachment | An artifact |
| Link to another table | Rows in another table. See below |
Each column header carries its type's icon, so a grid reads without opening anything.
Links between tables
A Link to another table column connects rows to rows. A Contract table can link to Suppliers, and the link shows from both sides: open a supplier and its contracts are listed there too, with nothing to keep in step. Tick Holds several if one row may link to many.
A link column holds links, not values, so you add and remove links on the row's page rather than typing into a cell.
Working with a table
See Tables screen for the list, the grid and the row page, and Changing a table's columns for adding, retyping and deleting columns.
Who can do what
- Members add, edit and delete rows and links.
- Owners and admins make tables, and add, change and delete columns. They also archive and restore tables.
- Viewers read.
- Agents read, and add, change and delete rows and links, over MCP. Changing a table's structure is off unless turned on. See Changing a table's columns.
History
Every change to a row is kept: who made it, whether a person or an agent, and from what to what. A deleted row's history stays too. An archived table keeps its rows, links and history, and comes back whole when it's restored.
Tables are in your workspace export and come back with a restore.