The Table widget displays query results as a structured grid — rows and columns with full control over how each column looks, sorts, and highlights values.

​

Reading the data

Each row in the table corresponds to one row returned by the underlying query. Column headers are the field names from your query — you can rename them inside the widget without changing the query itself. The table paginates automatically for large result sets. The total row count is shown in the widget footer. Null values are displayed as an empty cell. They are sorted to the bottom when sorting ascending and to the top when sorting descending. Numbers, dates, and text are all displayed as returned by the database. Use column controls to add prefixes, suffixes, or formatting on top of the raw values.

​

Sorting and filtering

Open the widget settings to set a default sort: Viewers can click any column header to sort interactively — this overrides the default sort for their session without changing the saved configuration. Filter data lets you apply a persistent filter condition to the query results (e.g. show only rows where status = "active"). This filter is applied before the table renders and is not visible to viewers as a control.

​

Column controls

Click any column header in edit mode, or open Settings → Columns, to configure a column. Prefix and suffix are purely visual — they do not change the underlying value used in sorts or calculations.

​

Conditional formatting

Conditional formatting lets you apply styles to individual cells based on their value. Open Settings → Columns → Conditional formatting for any column.

​

Single color rules

Rules are evaluated top-to-bottom. The first matching rule wins. Each rule has a condition and a style to apply when that condition is true. Condition types: Style options per rule: Any combination of styles can be applied in a single rule.

​

Color scale

The Scale tab in conditional formatting applies a continuous color gradient across the column’s values — useful for quickly spotting high and low values in numeric columns. Configure three anchor points: Anchor types: Values between anchor points receive interpolated colors. Values outside the defined range receive the nearest anchor color.

​

Table style

Open Settings → Style to pick a predefined color theme for the entire table.

​

Custom style

When Custom is selected, four color fields appear: Setting separate light/dark colors ensures the table looks correct in both themes.

​

Pinned columns

Pinned columns stay fixed at the left edge of the table while the remaining columns scroll horizontally. Useful for identifier columns (e.g. name, ID) that viewers need to keep visible. To pin a column: open Settings → Columns, select the column, and toggle Pin column. Multiple columns can be pinned; they appear in the order they are pinned.

​

Column order

Drag columns in the Settings → Columns panel to reorder them. The saved order persists for all viewers — individual viewers cannot reorder columns. To reset to the query’s natural column order, drag columns back or use Reset order.