š Overview
Some company information is a list that keeps changing. Which trucks are due for service. Who holds which certification and when it expires. Which suppliers you use for what. Kept in a spreadsheet on one laptop, the list is out of date the day someone else needs it.
A Table element on an SOP page in Company Operations keeps that list where your team can see and update it. It works like a spreadsheet: click a cell and type, move around with the keyboard, and drag a value down a column. You set up the columns in the page's Edit mode, and your team adds and updates rows.
š Understanding Tables
ā” What It Does
Tables allow you and your team to:
Keep a live list on an SOP page -- next to the process it supports
Work like a spreadsheet -- type in cells, use keyboard shortcuts and fill values down a column
Choose from 12 column types -- including Person, Date, Status, Priority, Link and Currency
Track progress with Status -- Not Started, In Progress, Stuck and Done, with your own labels
Sort and reorder -- sort by a column and drag columns and rows into order
Let your team add rows -- without opening Edit
Keep data private -- with Enable privacy?
š When to Use It
Tables are most valuable when you want to:
Track equipment, vehicles or tools and their service dates
Keep a list of certifications and expiry dates
Maintain a supplier or contact list for a process
Track a short list of company tasks with a status
š Step-by-Step Instructions
1. Add a Table Element
Open the SOP page and click Edit. On an empty page, click New Element straight away.
Click New Element and choose New Table
Enter the Table Title and, if you like, a Table Description
Tick Enable privacy? if members should only see their own data
Click New
Click Save (top right) to save the page
The table starts with three columns, Name, Status and Date, and one empty row.
2. Set Up Columns
Columns change only in the page's Edit mode.
Open the page and click Edit
To add a column, click the orange + at the end of the column headers. It adds a Text column named "Column" and a number.
To change a column, click the three dots on its header:
Rename -- type the new name in the header and press Enter
Change type -- choose Text, Number, Currency, Status, Dropdown, Priority, Person, Date, Email, Phone, Link or Checkbox
Sort ascending, Sort descending and Clear sort
Delete column
To move a column, drag it by the handle on its header. To move a row, drag it by the handle at its left.
Click Save (top right)
Important: Delete column removes the column and its values at once, with no confirmation. Check before you delete.
3. Add Rows and Fill In Cells
Click + New row under the table
Click a cell and type, or double-click it to open its editor. A Status cell starts at Not Started. A Person cell opens a list of your company's users with Search person....
Press Enter or Tab to move on
You don't need Edit to add rows. Rows you add outside Edit are saved straight away.
To delete a row, hover over it and click the x at its right end (Delete row). The row is removed at once, with no confirmation.
4. Use Keyboard Shortcuts and Fill Down
Click Shortcuts above the table to see them all. The main ones:
Arrow keys move between cells. Tab and Shift + Tab move across columns.
Enter or F2 opens the editor on a cell.
Escape cancels an edit. Delete or Backspace clears a cell.
Ctrl + Z undoes and Ctrl + Shift + Z or Ctrl + Y redoes (ā on a Mac)
To copy a value down a column, click the cell, then drag the orange dot at its bottom-right corner down or up.
5. Change Status Labels
The Status column starts with Not Started, In Progress, Stuck and Done. To change them:
In Edit, open a Status cell and click Edit labels
Change a label's color or name, delete it with its trash icon, or click + New label to add one
Click Apply, then Save (top right)
6. Know Who Can Change What
In Edit (Full Access on Standard Operating Procedures): change columns, every row and the row order
Outside Edit (Collaborate or Full Access): add rows and change the rows you added
View Only: see the table but not change it
With Enable privacy? on, members see only the rows they added. Owners and admins still see every row.
ā Best Practices
Set up columns before your team starts -- columns only change in Edit, so give the table the columns it needs first.
Pick the right column type -- a Date column always holds a real date. A date typed into Text can be written any way.
Use Status for anything with a stage -- a status pill is faster to scan than a written note.
Rename the starting columns -- Name, Status and Date are placeholders. Name them for what they hold.
Use fill down for repeated values -- drag the orange dot instead of typing the same value in every row.
Keep one table per list -- mixing trucks and certifications in one table makes both hard to use.
ā Common Questions
Q: Do I need to click Edit to change a table?
A: Not to add rows. Anyone with Collaborate or Full Access can add rows and change the rows they added without Edit. To change columns, other people's rows or the row order, click Edit on the page.
Q: Why can't I change a row?
A: Outside Edit, you can only change rows you added. Someone with Full Access on Standard Operating Procedures can change any row in Edit.
Q: Why is my new column called "Column 4"?
A: The + button adds a Text column with a numbered name. Click the three dots on its header and choose Rename and Change type.
Q: Can I change the Status options?
A: Yes. In Edit, open a Status cell and click Edit labels. Rename, recolor, delete or add labels, then click Apply and Save.
Q: What does Enable privacy do on a table?
A: Members see only the rows they added. Owners and admins still see every row.
Q: Is a Table the same as a Form?
A: No. A Form collects new entries one at a time and records who added each one. A Table is a list your team keeps up to date by editing cells. See Custom Forms.
ā ļø Common Mistakes to Avoid
ā Don't | ā Do |
Type dates and amounts into Text columns | Use Date and Currency columns |
Delete a column to clear a few cells | Clear the cells with Delete or Backspace |
Expect your team to add columns | Set up columns in Edit before they start |
Leave the starting columns with their default names | Rename them for what they hold |
Forget to save after changing columns | Click Save (top right) before you leave Edit |
