Follow Avox Docs on Google
Pick Avox Docs as a preferred source and Google shows these pages more often when you search for help with Avox.
Follow Avox Docs on Google
Pick Avox Docs as a preferred source and Google shows these pages more often when you search for help with Avox.
A table's Data tab is a grid that works like a spreadsheet: click a cell and type, select a range with the mouse or the keyboard, copy and paste to and from Excel or Google Sheets, and right-click for every action. Changes save on their own as you go.
You need Create and edit tables to change rows and columns. With See tables only, the grid is read-only.
A table's Data tab with the toolbar and the grid
Under the toolbar you'll see how many rows the table has out of your plan's row limit, and how many rows miss a value in a required column.
On a Mac, use Cmd where this says Ctrl.
Copy cells in the grid and paste them into Excel, Google Sheets or a document: they keep their rows and columns. The other way works too: copy a range in your spreadsheet, click the cell where it should start in Avox, and paste.
The keyboard shortcuts always work. The Copy, Cut and Paste items in the right-click menu need your browser's permission to use the clipboard.
On a cell: Cut, Copy, Paste, Clear, Insert row above, Insert row below, Duplicate row, Delete row, Open row details, Filter by this value, Sort A to Z, Sort Z to A.
On a row number: Insert row above, Insert row below, Duplicate row, Copy row, Open row details, Delete row.
On a column header (also the arrow on each header): Sort A to Z, Sort Z to A, Filter by this column, Rename, Change type and settings, Insert column left, Insert column right, Hide column, Freeze up to this column (or Unfreeze columns), Resize to fit, Delete column.
Click Open row details (or the open button next to a row number) to see one row as a form: every column, hidden ones included, with the same editors, when the row was added and last changed, and where it came from (the dashboard, a Flow, an automation, the API, an import or an app). Use the arrows to go to the previous or next row. On a computer it opens at the side; on a phone it opens from the bottom.
On a narrow screen the grid becomes a list of row cards: each card shows the row's title (pick the column in the table's Settings) and a few other values. Tap a card to open the row details and edit it, use Add row for a new one, and search or filter as usual. More rows load as you scroll.
Changes show straight away and save in the background a moment after you stop typing. If a save fails, the cells go back to their saved values and a message says why, for example AVX-3469 when another row already has a value in a unique column. If the connection drops, Avox keeps your changes and tries again. Your browser warns you before you leave the page while changes are still saving.
Several people, Flows, automations and the API can change a table at the same time. For each cell, the last change wins. If someone else changed a row since you opened the table, your change is still saved and Avox tells you (AVX-3472), so you can check the row. If they deleted the row, your change can't be saved and Avox tells you that too.
Deleted rows are kept for 30 days. Open Deleted rows from the table's menu to see them and bring any of them back. After 30 days they're removed for good. Deleted rows don't count towards your plan's row limit.
An archived table opens read-only with a banner and a Restore button.
Last updated