Concepts & glossary — Understand how your data is organized

Everything nests three levels deep: a workspace holds tables, and each table holds fields (its columns) and records (its rows). The rail shows the tables of your current workspace with a live record count beside each name; click the workspace name at the top of the rail to switch workspaces or create a new one. Relations connect records across tables in the same workspace — a task can link to a project, an invoice to a customer. Lookups and rollups then carry values along those links, so you enter a number once and summarize it wherever it is linked. Deleting a record moves it to the Trash rather than destroying it, and restoring brings it back exactly as it was. Everything is this shape. A view is a way of showing a table, not a copy of it, which is why an edit made in one shows up in all of them.