A table holds its own data. A base holds none: its rows are other documents in your workspace, gathered live. Both look like a grid, so pick by what a row is: a record you are keeping, or a document you already have.
Table or workbook
A workbook is also a grid of rows and columns, but it is a different kind of document. Pick by who keeps it up and what the numbers have to do.
Use a table for a list you keep by hand, like suppliers, a content calendar, or interview notes. Use a workbook when the numbers depend on each other, like a budget with totals, a forecast, or a quote. A data page of KPIs and charts reads its figures from a workbook, not from a table.
What it looks like underneath
The document is a single Markdown table. The column types and any formulas are stored with the document, not in the text. HereROAS is a formula column, revenue / spend:
Creating a table
In the sidebar, chooseNew document, then Table, from a folder’s ⋯ menu. See Creating one. It opens with three columns, Name, Status, and Due, and one blank row. Status is a select column with To do, Doing, and Done, and Due is a date column.
Or ask your agent, which is usually faster when you know what the columns should be: “Build a table of our suppliers, with name, category, lead time in days, minimum order, and whether we’ve verified them.” It creates the table with the columns typed correctly and the rows filled in.
Typed columns
Every column has a type, and the type is enforced on every change, whether you edit a cell or an agent rewrites the whole table. A number column cannot quietly fill up with text.Add column in a column’s menu creates a Text, Number, Checkbox, or Date column. To get a Select column, change an existing column’s type to Select. The values already in the column become its options, and Edit options lets you change the list, one option per line. A column with no values yet cannot become a select column.
Changing a column’s type is refused if a value in it does not fit the new type, and the message names the value.
Formula columns
A formula column works a value out from the other numbers in its row: return on ad spend asrevenue / spend, or margin as (revenue - spend) / spend. Tatara calculates it and stores the result, rounded to two decimal places. Whoever reads the table, you, a teammate, or an agent, sees a real number without recalculating anything. A row with a blank input shows … in the formula cell.
Formulas are simple arithmetic over the row’s number columns. There are no functions and no date arithmetic: a “days since” column would be wrong the moment it was stored. When you need totals or lookups, use a workbook.
You cannot add a formula column from the grid. Ask your agent: “Add a ROAS column to the channel table, revenue divided by spend.” Point at a formula column’s heading to see its formula, for example = revenue / spend.
Working with a table
The grid fills the page. Above it sits a strip carrying the table’s title, theFilter button, a chip for each active filter, and a count of the rows you are looking at. The count reads 12 of 550 rows while a filter is on.
Scroll down and the column headings stay put. Scroll sideways and the first column stays with them, so you always know which row you are reading. Each row is one line, and a value too long for its column is cut short. Click the cell to see all of it. Numbers line up on the right, with the same number of decimal places down a column.
- Edit a cell. Click it. Committing a cell moves you down to the same column in the next row, so you can fill a column top to bottom from the keyboard. A select cell opens its list on the first click and saves as soon as you pick a value. A checkbox toggles on the click.
- Add a row.
New rowat the foot of the grid adds a blank row. - Delete a row. Point at the row and choose
Delete rowfrom its⋯menu. The row goes at once, withUndo. - Sort. Click a column heading to sort by it. Click again to reverse the order, and a third time to turn sorting off. The sorted column shows a small mark.
- Change a column. Point at a heading and open the arrow beside its name for
Rename,Change type,Edit options(select columns only),Add column, andDelete column. A column that holds data asks you to confirm before it goes, and the delete can be undone. A table always keeps at least one column. A column that a formula uses cannot be renamed, retyped, or deleted until the formula changes. - Filter.
FilteropensAdd filter, where you pick a column and a value. Text columns match rows that contain the value, checkbox columns filter onCheckedorUnchecked, and every other type matches the value exactly. Click a filter’s chip to remove it. If nothing matches, the grid says so and offersClear filter.
Bases
A live view over your other documents, rather than data of its own.
Document formats
All six formats, and which to pick.