Grid¶
Related Videos
A Grid displays a set of dynamic values in the form of a table. The rows and columns can be individually stylized and configured. Additionally, specific rules can be applied to highlight important data. Larger amounts of data are supported with the automatic paging functionality.
Calculation
For calculation options, see Editing Table Valued Calculations chapter.
The calculation options control, how the displayed values are calculated.Link to Data Source
Whether data source should be used for generating results.Data Source
Available only when “Link to Data Source” is enabled
A data source to be used.
Columns
Manually orderable
List of Grid’s columns. For more information see Columns chapter.Paging
The Grid can be configured to split its data into multiple pages, with the following options:Sizing Mode
Inheritable
Row size mode.Number of Rows - Defines the number of rows to be displayed in the Grid. Available space is equally distributed to all rows.
Height of Row - Defines the height of a row. Only rows that fully fit are displayed, leaving potential empty (unused) space at the bottom of the grid.
Page Size
Inheritable
Available only when “Number of Rows” is selected as a Sizing Mode
Defines the number of rows to be displayed per page.Row Height
Inheritable
Available only when “Height of Row” is selected as a Sizing Mode
Height of a row measured in permilles of the entire Layout’s height.Maximum Page Count
Maximum number of pages to be displayed. In case source tables contain more rows that are able to be displayed (Page Size * Maximum Page Count), sorting can be configured to display data based on their relevance/priority.If Maximum Page Count is bigger than 1 Paging group also contains:
Paging Interval
Inheritable
A Grid configured to display more than one page, is paged through automatically. Each page is displayed for a duration specified in this field.Update Values On Page Change
When disabled, Grid’s values are updated only on the first page. Even if new values are available, the Grid will not update its values until all pages have been paged through.
When enabled, values are updated as soon as they are available.
Appearance
The style of the GridHorizontal Alignment
Controls, where the text should be aligned on the horizontal axis.Left - Aligns the text to the left.
Center - Aligns the text to the center.
Right - Aligns the text to the right.
Padding
Inheritable
The size of a padding between the text and cell’s border in “em” units. 1 em equals the font size of the associated text.
The padding is applied to the side where the text is horizontally aligned.Show Headers
Whether header row should be displayed in Grid. This group contains header configuration.Height
Inheritable
Height of the header, that is measured in permilles of the entire Layout’s height.Text Color
Inheritable
For more information see Color Field section.
Color of the text.Background Color
Inheritable
For more information see Color Field section.
Color of the background.Text Style
Inheritable
For more information see Text Style section.
Type of font to use and whether bold or italic text should be used.Font Size Coefficient
Inheritable
The font size is calculated by multiplying available height for the text by font size coefficient.Borders
For more information see Borders Style section.
The style, width and color settings for the header borders.
Values
Visual configuration of values in GridBackground Color
Inheritable
For more information see Color Field section.
Color of the background.Text Style
Inheritable
For more information see Text Style section.
Type of font to use and whether bold or italic text should be used.Alternate Row Colors
Inheritable
For more information see Color Field section.
Whether consecutive rows should alternate colors.Alternate Row Background Color
Inheritable
Available only when Alternate Row Colors is enabled
For more information see Color Field section.
Alternating color of the background.Borders
For more information see Borders Style section.
The style, width and color settings for the borders in a values area.
Show Totals
Whether totals should be visible in the grid.Total Row Label
The label of the totals row.Show Total Label in Column
Column, in which the total label is displayed.Text Color
Inheritable
For more information see Color Field section.
Color of the text.Background Color
Inheritable
For more information see Color Field section.
Color of the background.Text Style
Inheritable
For more information see Text Style section.
Type of font to use and whether bold or italic text should be used.Font Size Coefficient
Inheritable
The font size is calculated by multiplying available height for the text by font size coefficient.Borders
For more information see Borders Style section.
The style, width and color settings for the borders in a totals row.
Colors
For ease of access, all aforementioned color-related options are once again located in the Colors group.Headers Text Color
Inheritable
For more information see Color Field section.
Color of the header’s text.Headers Background Color
Inheritable
For more information see Color Field section.
Color of the header’s background.Values Background Color
Inheritable
For more information see Color Field section.
Color of the value’s background.Alternate Row Values Background Color
Inheritable
Available only when Alternate Row Colors is enabled
For more information see Color Field section.
Alternating color of the values background.
Client Sort Columns
Manually orderable
List of Client’s sort columns. For more information see Client Sort Columns chapter.Alerts
Grid Alerts allow you to define rules for monitoring specific conditions in the Grid’s data.Enable Silent For
If enabled, this setting temporarily disables notifications after notification is triggered, preventing frequent disturbances to the user. It applies to all notifications configured on the Grid. Once a notification is triggered, subsequent notifications will be suppressed for the specified duration.Timespan
Available only when Enable Silent For is enabled
Specifies the duration for which notifications will be suppressed. This defines the time period during which no additional notifications will be triggered.
Rules
Manually orderable
List of Grid’s alerts. For more information see Alerts chapter.