Table settings
A table’s rules, form, links, tax and history used to be spread over twelve tabs. They now sit in six groups, and one bar at the foot of the drawer publishes all of it.
- Where to open it, and the six groups
- The save rule: settings are drafts, actions happen now
- The access rule: everyone sees every section, only some can change it
- Finding one setting without knowing its group
01 · Why
Why do we have this?
Everything that decides how a table behaves — what must be filled in, when a record locks, how the form looks, which tables it links to, what tax it charges — belongs to the table. Table settings keeps all of it in one place, says in one sentence what the table does today, and lets you change several things and publish them together with one reason.
02 · How
Open it
- From the table:
More actions→Table settings. - From a column’s settings:
Rules for this columnopensRules on one column, narrowed to that column. - From a link someone sent you: a link to one section opens its group, scrolled to that section.
- From the workspace search (⌘K): type the setting, for example tax sales or lock invoices.
With nothing named, the drawer opens on Overview.
The six groups
| Group | What is in it |
|---|---|
Overview | The table in a short sentence, Needs attention (a rule that cannot be checked, records breaking a published rule, changes not live yet, a copy’s conflicts), a card per group, and Describe a change. |
Rules & status | Status, Rules on one column, Checks that compare columns, Locks after a status, Record revisions. |
Form | Record layout, Show, hide or require, Linked records on a record. |
Links & sharing | Links, Who owns this table, Copy to other workspaces. |
Accounting | Tax; Match bank lines to on the bank lines table only; Depreciation on a fixed assets table only. |
History | Every version of the table, with Restore, and Published settings, where you can Roll back one publish. |
Each section folds to one line that says what it holds, for example 3 rules or After Posted. Rare options sit under the section’s Advanced, which says when something inside it is not the default. A group only appears when the table has at least one of its sections.
Change a setting and publish it
- Open the group and unfold the section.
- Make the change. It is saved into the table’s draft as you go; nothing is live yet. The section and its tab show how many changes they hold.
- Carry on in other sections if you like. The bar at the foot counts them all: “2 changes in 2 sections, not live yet”.
- Press
Review and publish. The review lists what goes live, by section. When rules are in the draft it also shows how many existing records the rules would affect, and lets you choose what happens to them. - Say why in the one reason box and press
Publish. The reason is kept inHistory.
03 · Expected result
Everything in the draft goes live at once and the bar says “Published” with your reason. If any one item cannot go live, nothing is published: the bar names the item and its section so you can fix it and publish again.
04 · The save rule
Settings are drafts, actions happen now
| Kind | What happens | Examples |
|---|---|---|
| A setting | Joins the one draft. Goes live only when you publish, together with everything else in the draft. | Rules, status, locks, record revisions, record layout, show/hide/require, linked records, a link’s options, tax, depreciation |
| An action | Happens as soon as you confirm. It carries a now mark and is never part of the draft. | Merge, Undo merge, Share, Stop sharing, Receive, Resolve conflict, Run now, Restore, Roll back |
If a section has changes not published yet, an action there tells you, because it runs on what is live now, and offers Publish first. Match bank lines to still saves each table you add through its own Sheet, outside the draft.
05 · The access rule
Everyone sees every section; changing it needs a permission
Anyone who can see the workspace can open Table settings and read every section. Nothing is hidden because of your role; a section only goes missing when it does not apply to the table (Bank, Depreciation). What you can change depends on your role’s permissions, named as in Roles and permissions:
| To do this | Your role needs |
|---|---|
| Open the drawer and read every section | See the workspace |
| Change rules, status, locks, the form, linked records, links, tax, bank and depreciation; restore a version; publish | Manage the workspace |
Change Record revisions and Copy to other workspaces | Build tables |
| Merge another table into this one | Manage the workspace and Build tables |
| Publish a change that loosens a high-risk rule | Loosen a rule, on top of the above |
A section you cannot change is read-only, and one banner under the tabs says which permission changing it needs. Two sections hold content the server only hands over with more: Linked records on a record (Manage the workspace) and Copy to other workspaces (Build tables). Without it, the section still shows and says “Reading this setting needs …” instead of its content.
Someone who can only read gets Review on the bar to see a draft, but no Discard and no Publish.
06 · Find a setting
The Find a setting box in the drawer’s header searches this table’s sections, their Advanced options, its columns and its statuses, in English and in your language. Pick a row and the drawer opens its group, unfolds the section (and its Advanced, if that is where it lives) and highlights it for a moment. Search workspace settings takes the same words to the workspace search.
07 · Troubleshooting / notes
| What you see | What it means |
|---|---|
| “Someone else has a draft of this table waiting.” | Another person started a draft. Continue their draft to build on it, or Discard it to start from what is live. |
Review and publish opens, but its Publish is off | A section has a problem to fix first; the review names it. |
| A section says “Reading this setting needs …” | Your role lacks the permission the server asks before showing that section. Ask an admin. |
| A setting changed but records still behave the old way | It is still in the draft. Check the bar at the foot of the drawer and publish it. |
08 · FAQ
Common questions
Records do not change. The draft belongs to the table, so another admin who opens Table settings sees it waiting and can continue it.
Yes. In History, Published settings lists each publish from the drawer; Roll back puts that setting back as it was, at once.
Status is a section of Rules & status now, together with the rules and the locks. Type status in Find a setting to jump to it.