Table View

Configuration reference: Tabela

Overview

The Table view presents data as a spreadsheet-like grid with rows and columns. It is the most feature-rich view type and typically the default choice for general data management.

Sorting and filtering

Sorting

Click any column header to sort by that column. Click again to reverse the order. The table supports multi-column sorting — hold the sort and add additional columns to refine the order.

Sorted columns can be preconfigured in the view settings so users see a default sort when opening the view.

Filtering

Click the Filter button in the toolbar to open the filter panel. Filters support multiple operators depending on the column type:

• Text columns: equals, contains, starts with, ends with, is empty, is not empty
• Numeric columns: equals, greater than, less than, between, is empty
• Date columns: equals, after, before, between, is past, is today, is tomorrow, is the day after tomorrow, is next week, is empty, is not empty
• Select columns: equals, is one of, is empty

The relative date operators (is past, is today, is tomorrow, is the day after tomorrow, is next week) take no value and are evaluated against the workspace's current day; "is next week" covers Monday to Sunday of the following week.

Multiple filters can be combined. You can also save predefined filters — named filter combinations that users can select from a dropdown for quick access.

Faceted search

The table supports a faceted search panel — a sidebar filter interface that shows all available values for select-type columns with counts, similar to e-commerce category filters.

Full-text search

Click the Search button or use the keyboard shortcut to open a search bar. Search filters across all visible text columns in real time.

Inline editing

Double-click any cell in the table to edit its value directly without opening the record form. The cell transforms into the appropriate input for the column type (text input, dropdown, date picker, etc.).

Press Enter to save or Escape to cancel. Changes are saved immediately.

File columns are the exception: instead of a text field, the cell shows an upload button (no Enter/Escape).

Grouping

Click the Group button to group rows by any column. Grouped rows appear under collapsible section headers showing the group value and record count. You can hide empty groups and expand or collapse all groups.

Bulk actions

Enable row selection to perform actions on multiple records:

1. Click the checkbox in the header to select all, or check individual rows.
2. In the selection bar's Ações, pick the workflow: it runs once per selected row.
3. It lists this table's workflows with a manual trigger of Linha scope.

Additional features

Feature	Description
Column visibility	Hide or show columns from the view without affecting the feature definition
Column reordering	Drag columns to rearrange their position in the grid
Export	Export visible data to Excel or CSV format
Import	Import data from files directly into the table
Footer totals	Display sum totals for configured numeric columns at the bottom of the table
Conditional formatting	Color entire rows based on field value conditions
Action column	A special column with buttons for row-level workflow executions

Admin configuration

The admin settings dialog (Configurar Vista) arranges the table configuration in nine sections, grouped in three blocks: Dados, Apresentação and Comportamento.

Dados

• Filtros: admin filter rules applied to every user when the view opens; users can override them with their own filters
• Ordenação: the sort levels applied when the view opens (see below); users can override them with their own sorting
• Agrupamento: the default grouping column (a single level), the look of the groups and the order of the groups (see below); users can override it

Apresentação

• Campos: a list of columns with one switch each: on, the column shows; off, it is hidden by default. Click the row to switch it on or off. Users can show or hide columns on their own
• Colunas fixas: data columns pinned to the left of the grid when scrolling sideways (see below); only the view admin sets them, with no per-user override
• Somas: numeric columns (number or formula) that take part in the footer total; switch a column on to give it a footer total
• Cores: conditional formatting rules that color whole rows by field value

Comportamento

• Interface: the visible toolbar buttons (search, filters, group, export, import) and record settings (allow adding, allow row selection, and Coluna de ações, which turns on double-click and the ↗ to open records)
• Edição: a list of columns with one switch each: on, the column can be edited in place by double-clicking the cell. Click the row to switch it on or off
• Form: Which form opens for Add/Edit and the dialog size (see When opening a record)

Sorting levels

Each sort level is a row: Ordenar por the first column and depois por the following ones, each with a direction, Ascendente or Descendente. With two or more levels a grip appears at the right of each row: drag it to change the order of the levels. Adicionar nível adds a level and the bin removes it.

Grouping settings

Pick in Agrupar por the column the table opens grouped by. Once a column is chosen, the section shows two cards:

• Aspeto dos grupos: Secções (collapsible headers) or Compacto, plus Ocultar grupos sem registos, which hides groups left with no records after the filters. The Mover para grupo menu still lists those empty groups.
• Ordem dos grupos: shown when a column is grouped, it sets the order the groups appear in for every user. It exists only for selection, link or user columns; other columns follow the natural order and the section says so. Switch a group on under Grupos disponíveis to put it in the order, use the arrows to move it up or down, and Sugerir ordem alfabética to start from a sorted list. Groups left out come after, in the order of the options.

Each user can choose their own group order in the Ordem dos grupos menu of the grouping bar; the personal order wins over the admin's. Changing the grouped column restarts the group order.

Pinned columns

In Colunas fixas the admin picks which data columns stay pinned to the left while scrolling sideways. Each column has its own switch; click the row to switch it on or off. Pinned columns move to the front of the column order, right after the action and selection columns, which are always pinned. A pinned column that is also hidden in Campos does not show: visibility wins over pinning. Pinning is the view admin's choice, with no per-user override.

Toolbar controls

The table toolbar can show or hide these buttons via configuration:

• Search button
• Filter button
• Group button
• Export button
• Import button
• Add record button
• Selection toggle