Skip to content
Go to platform

Last updated:

Grid

The Grid control visualizes a dataset structured like a table, supporting paging, filtering, and sorting, alongside styling for layout, look, and line formatting. It’s typically used to display data in tabular form, or let users select from non-singular data entries such as order lines or downtime records.

Grid is gradually being replaced by Gridlist, which adds footers and multi-value row layouts. Grid remains supported for existing implementations: for new dashboards, prefer Gridlist.

Event Description
On update Triggered whenever the grid receives or updates its data, from an initial load or a filter change.
On grid row click Triggered when a user selects a row: enables actions like downloading a file or opening/copying a form for that row.
Mapping Description
Columns Which columns are displayed. In table view, each column also supports cell-based color mapping (background color driven by the data).
Rows The data rows shown: dataclips have a variable row count, so this is mapped automatically.
Definition header Used by the New form for grid line action to pick the form definition.
Document header Used by the Download grid line document action to identify the document.
Message header Used by the Open grid line form or Copy grid line form actions to identify the message.

Configured per column, under Properties → Grid data → Overview fields:

Aspect Description
Caption The column header’s text; defaults to the mapped column name.
Weight The column’s relative width. A weight of 0 hides the column, but keeps its value available for logic or actions.
Sorting The default sort order (index and direction).
Format Formats the cell’s value based on its type: numeric values can set a decimal count with {#} (e.g. €{2} renders 4.5 as €4.50), and date/time values use ISO 8601 format tags.
  • Column- and row-based styles, for alternating lines or highlighted records.
  • Conditional coloring through data mapping, e.g. coloring rows based on thresholds or statuses.
  • Header customization through captions and weights.
  • Hidden technical columns (weight 0), used for logic without cluttering the display.

Grid receives minimal new feature support and is gradually being replaced by Gridlist. Keep using Grid for existing implementations that rely on its column/row mappings; for new dashboards, use Gridlist.

Feature Grid Gridlist
Footers Not supported Supported
Row layout Single value per column Multiple values under one column
Paging Supported Supported
Mapping Requires Columns and Rows mappings Uses direct dataset configuration
Cell styling Basic Advanced per-cell overrides