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.
Events
Section titled “Events”| 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. |
Data mapping
Section titled “Data mapping”| 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. |
Advanced configuration
Section titled “Advanced configuration”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. |
Styling
Section titled “Styling”- 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 vs. Gridlist
Section titled “Grid vs. Gridlist”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 |