Skip to main content

Value - Table

The Table appearance displays multiple data records in a configurable tabular format with support for various cell types, conditional formatting, filtering, sorting, and pagination.

table-showcase.png

Settings

Data Settings

SettingDescription
Column KeysDefine column structure (see Cell Types below)
Conditional formattingApply rules for styling based on values
FilteringFilter rows based on conditions
SortingSort data by column
Image folderFolder to search for images (for [file] columns)
Base event IDIdentifier for table events (default: "table")
Number max valueMaximum value for [number] type columns
Progressbar max valueMaximum value for [progressbar] type columns
Color max valueMaximum value for [color] type columns

How to define columns

Define which columns to display and their types. Enter one column per line in the Column Keys field.

Format
[type][flags]columnKey|Alias

The |Alias part is optional. If provided, the alias is displayed as the header text instead of the column key. To create a column with a blank header, use a pipe followed by one or more spaces (e.g., columnKey| ). A pipe with nothing after it is not valid and will be ignored.

Column Types
TypeDescription
[text]Plain text display, this is also the default type if the type hasn't been explicitly defined.
[number]Animated number (uses the single value appearance)
[progressbar]Progress bar indicator (uses the single value appearance)
[gauge]Mini gauge indicator (uses the single value appearance)
[color]Color-based cell (uses the single value appearance)
[linechart]Mini line chart for array data (see Linechart Cell settings below)
[numberformat]Formatted number with separators, currency, etc.
[date]Date/time formatting
[file]Image from folder lookup
[img]Direct image URL
[html]Raw HTML content
Flags

Special format flags are used to add column specific styling, which overrides the settings inside the editor. Styling flags affect both the header cell and the data cells of that column.

FlagDescriptionValueUnitDefault (when no value given)
sizeColumn width percentageNumber% (auto)Equal split
bgcolorBackground colorCSS color code-#ffffff
fontcolorText colorCSS color code-#000000
fontsizeFont sizeNumberpx (auto)16
boldBold textNone--
italicItalic textNone--
underlineUnderlined textNone--
h-alignHorizontal alignmentleft, center, right-center
v-alignVertical alignmenttop, center, bottom-center
paddingCell padding on all sidesNumberpx (auto)-
p-topCell padding top overrideNumberpx (auto)-
p-rightCell padding right overrideNumberpx (auto)-
p-bottomCell padding bottom overrideNumberpx (auto)-
p-leftCell padding left overrideNumberpx (auto)-
prefixText prepended to the value ([text] only)String--
postfixText appended to the value ([text] only)String--

Flags that require a value use the [flag:value] syntax (e.g., [size:25], [fontcolor:#ff0000]). Flags that accept no value are written as [flag] (e.g., [bold], [italic]). Flags that accept an optional value will use the default shown above when no value is provided (e.g., [h-align] defaults to center).

For numeric flags, units are appended automatically where marked with (auto) -- provide only the number (e.g., [fontsize:16] becomes 16px, [size:25] becomes 25%). Color flags require a full CSS color code including the # prefix (e.g., [fontcolor:#ff0000]).

Examples
[text][bold]name|Employee Name
[italic]Id|Employee Id
[numberformat][size:25]salary|Annual Salary
[progressbar]progress
[date]startDate|Start Date
[file]avatar|Photo
[text][padding:10]description|Description
[text][p-top:5][p-left:10]notes|Notes
[linechart]sparkline|Trend
[text][h-align:left][fontcolor:#336699]category|Category
[text][h-align]centered|Centered Column
[text][prefix:$]price|Price
[text][postfix: USD]amount|Amount
[text][prefix:(][postfix:)]note|Note
[text]internalId|

In the last internalId example, internalId| (pipe followed by a space) uses a space as the alias, resulting in a blank header for that column.


Conditional Formatting

Apply dynamic styling to cells based on data conditions.

Access via the "Conditional formatting" button to open the condition editor.


Filtering

Filter rows based on conditions. Only rows matching the filter are displayed.

Access via the "Filtering" button to open the filtering editor.


Sorting

Sorts the table rows by column values.

Access via the "Sorting" button to open the sorting editor.


Layout Settings

SettingDescription
Table OrientationVertical (standard) or Horizontal (rotated)
Maximum num of rowsLimit displayed rows (0 = show all)
Table data row/column sizingAuto (fit to container) or Fixed (specified %)
Data row/column fixed sizeSize percentage when using Fixed sizing
Enable scrollingAllow scrolling when content overflows (only with Fixed sizing)

Background Settings

SettingDescription
Enable Even-Odd Row stylingAlternate row colors for readability
Background ColorUniform background (when Even-Odd is OFF)
Even-Row Background ColorColor for even-numbered rows
Odd-Row Background ColorColor for odd-numbered rows

Pagination Settings

SettingDescriptionRange
Enable paginationSplit data across multiple pages-
Pagination animationTransition effect: None or Fade-
Time on pageSeconds before auto-advancing5-300

Header Settings

SettingDescription
Disable headerHide the header row entirely
Background colorHeader row background
Vertical alignmentTop, Center, or Bottom
Horizontal alignmentLeft, Center, or Right
Font settingsFamily, Size, Style, Color
Header SizeHeight percentage of header row

Border Settings

Outer Border

SettingDescription
Border roundingCorner radius for the table
Outer Border widthThickness of outer border
Outer Border styleSolid, Dotted, Dashed, Double, Groove, Ridge
Outer Border ColorColor of outer border
Outer Border PlacementEvery, Top, Bottom, Left, Right, Top-Bottom, Left-Right

Inner Border

SettingDescription
Inner Border widthThickness of cell dividers
Inner Border styleSame options as outer border
Inner Border ColorColor of cell dividers
Inner Border PlacementEvery, Vertical only, Horizontal only

Header Border

Separate width, style, and color settings for the header row border.


Scroll Settings

Visible only when scrolling is enabled

SettingDescription
Sticky headerKeep header visible while scrolling
SizeScrollbar width/height
RoundingScrollbar corner radius
Thumb ColorScrollbar handle color
Thumb Hover ColorHandle color on mouse hover
Track ColorScrollbar track background

Cell Padding Settings

SettingDescriptionRange
Padding TopTop padding for all cells (px)0-100
Padding RightRight padding for all cells (px)0-100
Padding BottomBottom padding for all cells (px)0-100
Padding LeftLeft padding for all cells (px)0-100

These global padding values apply to every cell in the table. They can be overridden on a per-column basis using the [padding:X] shorthand flag (sets all 4 sides) or the specific [p-top:X], [p-right:X], [p-bottom:X], [p-left:X] flags in the column key definition. Per-column specific flags take priority over the shorthand, and the shorthand takes priority over global settings.


Cell Type Specific Settings

Text Cell

SettingDescription
Vertical/Horizontal alignmentCell content alignment
Font settingsFamily, size, style, color

Date Cell

SettingDescription
PatternFormat pattern (e.g., "YYYY-MM-dd", "dd/MM/YYYY HH:mm")
Use 12-hour formatToggle AM/PM display
Locale CodeLocalization (e.g., "en-US", "de-DE")
AlignmentVertical and horizontal
Font settingsFamily, size, style, color

Formatted Number Cell

SettingDescription
SeparatorThousands separator
Decimal SeparatorCharacter for decimal point
Decimal pointsNumber of decimal places (-1 = keep original, 0-4)
Prefix/SuffixText before/after number
Currency SymbolCurrency indicator
Currency PositionPrefix or suffix
Compact modeDisplay as 1K, 1M, 1B
Compact thresholdWhen to start compacting
Percentage modeDisplay as percentage
Percentage multiplyMultiply by 100 for percentage

Image Cell

SettingDescription
Image fitStretch, Cover, or Contain

Linechart Cell

Displays a mini line chart inside a table cell. The data source value for this column must be an array of numbers (e.g., [10, 25, 18, 30, 22]). Missing or null values in the array are treated as gaps in the line.

Line
SettingDescriptionDefault
Line colorColor of the chart line#4CAF50
Line widthThickness of the line (1-10)5
Line smoothingCurve tension (0 = straight lines, 0.4 = smooth curves)0
Fill under lineFill the area between the line and the X axisOff
Fill colorColor of the fill area (visible when fill is enabled)rgba(76, 175, 80, 0.2)
Axes
SettingDescriptionDefault
Axis colorColor of the X and Y axis lines#666666
Axis widthThickness of the axis lines (0 = hidden)4
Begin Y axis at zeroForce the Y axis to always start at zeroOff
Missing Values

Controls how gaps from missing or null data points are handled.

SettingDescriptionDefault
Connect across gapsDraw a line across missing values instead of leaving a gapOff
Gap line styleStyle of the bridging line: Solid, Dashed, or Dotted (visible when connect is enabled)Dashed
Gap line colorColor of the bridging line (visible when connect is enabled)#999999
Gap fill colorFill color under gap segments (visible when both connect and fill are enabled)rgba(153, 153, 153, 0.2)
Y Axis Labels
SettingDescriptionDefault
Show Y axis range labelsDisplay min and max values on the Y axisOff
Font settingsFamily, size, style, and color for the labels (visible when labels are enabled)-

Sensor Events

Events use the configured eventId setting, as the prefix (default: table).

Event NamePayloadTrigger
eventId-page-changedpage indexPage navigation occurred
eventId-pages-count-changedtotal pagesTotal page count changed
eventId-clickedpageIndex, rowIndex, cellIndex, cellValue, datasourceValueCell was clicked

External Commands

CommandParametersDescription
setTablePageTovalue: numberNavigate to page index
setTableIndexNextnoneGo to next page
setTableIndexPrevnoneGo to previous page