Skip to main content

Tcol

Details a column in the table object.

Attributes

Column

Type

Defines the column's cell type.

The default value is: text.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescription
textDefault value. Text content.
buttonButton content.
imageImage content.
htmlHTML content.
checkA check is displayed if there's any value other than "false" or "0".
switchA switch is displayed if there's any value other than "false" or "0".

It can control a boolean value in the datasource without opening the edit popup.
indexThe row's index.
progressA progress bar.
selectionDisplays a check if the item is selected. This column is displayed only if the table's "Item Selection" attribute is true.
moveMove the item with drag and drop.

Hidden

Hides the column so it's not displayed in the table. A column can be hidden, but still have an edit field associated

The default value is: false.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescription
falseDefault value. Visible.
trueHidden.
viewmodeHidden in view mode, visible in edit mode.
editmodeHidden in edit mode, visible in view mode.

Data

Data Name

Specifies the datasource's column name to be associated with the table's column.

Attribute Values
ValueDescriptionExample
<string>A valid datasource column's name.address

Data Index

Specifies the index in the items array.

The default value is: auto.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescriptionExample
autoDefault value. Index based on column's index.
<int>A 0-based index.0
noneIs not associated.

JSON Value

If true, interprets the cell value as a JSON object. Each key in the JSON object represents a column attribute.

Values specified in the JSON object will extend or override the initial column setup.

Only non-static attributes can be overridden.

E.g. { "type": "button", "action": "command", "buttonlabel": "hi", "style": "blue", "commandname": "hi" }

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Value is not interpreted as JSON.
trueCell value interpreted as JSON.

Format

Specifies the language-sensitive format type to be applied.

The default value is: text.

Attribute Values
ValueDescription
numberNumeric value, with optional unit or currency.
dateDate value.
timeTime value.
datetimeDate and time value.
relativetimeDate and time value.
time-intervalTime interval value.
listList value.

Data Format

Specifies the data format, which determines how the value is parsed when received (through a UISet) or sent.

The default value is: extended.

Attribute Values
ValueDescription
extendedDefault value. HH:mm:ss.SSSS Extended Format.
basicHHmmssSSSS Basic Format.
timestampUnix Timestamp: Seconds since the Unix Epoch (January 1, 1970 00:00:00 GMT).

Data Format

Specifies the data format, which determines how the value is parsed when received (through a UISet) or sent.

The default value is: extended.

Attribute Values
ValueDescription
extendedDefault value. YYYY-MM-DD ISO 8601 Extended Format.
basicYYYYMMDD ISO 8601 Basic Format.
timestampUnix Timestamp: Seconds since the Unix Epoch (January 1, 1970 00:00:00 GMT).

Number Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Time Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Date Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Datetime Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Relative Time Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

List Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Time Interval Display Format

Specifies the field's format.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Foreign Key

If specified, the column value is interpreted as a foreign key for either a linked datasource or the items attribute.

In datasource mode, cells display the corresponding value from the linked datasource's column specified in the "Label Data Name" attribute.

In list mode, cells display the corresponding value from the list of items specified in the "List" attribute.

In items mode, cells display the corresponding value from the items array, where every item is an array with the first element being the key and the second element being the label.

The default value is: none.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescription
noneDefault value. No foreign key.
datasourceDatasource foreign key.
listList foreign key.
itemsItems foreign key.

Datasource ID

Specifies the ID of the linked datasource.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescriptionExample
<[Datasource ID]>A valid datasource ID.ds_addresses

Value List

If true, treats the value as a comma-separated list of keys relative to the linked datasource. It shows a comma-separated list of labels, based on the "Label Data Name" attribute.

The default value is: false.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescription
falseDefault value. Treat the value as a single key.
trueTreat the value as a comma-separated list of keys.

Label Data Name

Specifies the linked datasource's column name to display instead of the key value.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescriptionExample
<[Datasource Column Name]>A valid datasource column name.address

List

Sets the items. An item with a label "---" (three hyphen-minus characters) is treated as a separator and its value is ignored.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Attribute Values
ValueDescriptionExample
<comma-separated list>Items specified as a comma-separated list.item1,item2,item3
<array>Items specified as an array of strings.["item1","item2","item3"]
<array of arrays>Items specified as an array of arrays. Each item has an array of value and label.[[1,"label1"],[2,"label2"],[3,"label3"]]
<array of arrays>Items specified as an array of arrays. Each item has an array of values that can be recalled from the template attribute.[[1,"label1","descr1"],[2,"label2","descr2"],[3,"label3","descr3"]]

Items

Specifies the items.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Cell Style & Format

Width

The column's width.

Columns set to 'auto' width expand or contract to fill the remaining space of the table, after accounting for columns with fixed widths. Each 'auto' column maintains a minimum width of 100 pixels, ensuring consistent visibility and layout.

If the combined width of all columns exceeds the width of the table, the table becomes horizontally scrollable. This ensures that all columns, regardless of their individual or total width, remain accessible to the user.

The default value is: auto.

Attribute Values
ValueDescriptionExample
<int>The column's width in pixels.200

Fixed Width

Columns of type selection, move and switch have a fixed width.

note

This attribute is static. Its value can't be changed dynamically with a uiSet command or with a value binding.

Align

Specifies the cell's content alignment.

The default value is: left.

Attribute Values
ValueDescription
leftDefault value. Left.
centerCenter.
rightRight.

Background

Specifies the cell's background color.

Attribute Values
ValueDescriptionExample
<html color>Color in any html accepted format.#ff0000

Column Header

Label

The label displayed in the column header.

The default value is: =@title:dataname.

Attribute Values
ValueDescription
<string>A label.

Icon

An optional icon to be displayed in the column header, before (or in place of) the label.

Attribute Values
ValueDescriptionExample
<image>An icon image.icon:mdi#account-multiple

Summary Label

If true, the footer column will contain a label of the row's content (Total, Average, Minimum or Maximum). If more consecutive columns have summary label set to true, they are merged (can be used to display the whole label if a single column is too narrow)

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. False.
trueTrue.

Summary

Specifies the summary to be displayed on the column footer. Can be one or more values. If there's an active filter, the results are calculated using the filtered rows. If there's a selection, Selecting specific rows will calculate the results using only the selected rows

Attribute Values
ValueDescription
noneNo summary.
sumShow sum of all the displayed column values.
avgShow the average value of all the displayed column values. If the column has type "check", show checked/total.
minShow the minimum value among the displayed column values.
maxShow the maximum value among the displayed column values.

Button Action

Action

Specifies the action performed when clicked/tapped.

The default value is: none.

Attribute Values
ValueDescription
noneDefault value. No action.
editEdits the item.
deleteDeletes the item.
duplicateDuplicates the item.
commandSends a command to the server, with the specified name and parameter.
datapointToggles a datapoint.
linkChanges page, shows a popup or opens a URL.
downloadFires a download file request.
tabShows a specified container and hides the other of the same group.
cameralinkOpens a page with the specified camera address.
copyCopies the cell's value to the clipboard.

Command Name

Specifies the command name that is sent to the server.

If the name starts with $, then the server will automatically set a variable with the same name as the command, containing the command's parameter.

The default value is: =id.

Attribute Values
ValueDescriptionExample
<string>A command name.
$[variable name]A command name that sets a variable.$myvar
$[variable name]!A command name that sets a persistent variable.$myvar!

Parameter

If set, specifies the command's parameter value. The default parameter is the key value of the row.

The default value is: [Row's key value].

Repeat

If enabled, the command will be repeated every second. Down/Repeat/Up/Stop commands are sent.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Repeat mode is disabled.
trueRepeat mode is enabled.

If set, specifies the link. The default link is the row's cell value.

Specifies where to open the linked URL. Available only for URL links.

The default value is: _self.

Attribute Values
ValueDescription
_selfDefault value. Opens the linked URL in the same window or tab.
_blankOpens the linked URL in a new window or tab.
<string>Opens the linked URL in a named window or tab. Use this to open multiple links in the same window or tab.

Datapoint

Specifies a datapoint, to display and control its status.

The default value is: [Cell's value].

Attribute Values
ValueDescriptionExample
[datapoint address]The datapoint address.dummy.dimmer.1

Feedback

If feedback is enabled, when the action is performed, a loader is displayed until the server responds.

Also the action can't be performed again until the server responds.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Feedback is disabled.
trueFeedback is enabled.

Confirm

Requires a confirmation before performing the action.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. No confirmation, the action is performed right away.
doubleclickA second click (or touch or enter key) is required to confirm the action.
popupA popup is displayed to ask for confirmation.

Confirm Message

The confirmation message to be displayed if the "confirm" attribute is set to "popup".

Attribute Values
ValueDescriptionExample
<string>The message to be displayed in the confirm popup.Are you sure?

Confirm

Edit Duplicate

If true, opens the edit popup to allow changes before adding the item as new.

The default value is: true.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
trueDefault value. Edit the item before adding it as new.
falseDuplicate the item right away.

Text

Text

Specifies the text to be displayed in the cell.

The default value is: [Cell's value].

Attribute Values
ValueDescription
<string>A text.

Template

Defines an HTML template. The text parameter is split with pipe character (|) and each part is inserted in the template, replacing the %1;, %2;, $3;, etc. placeholders.

Attribute Values
ValueDescriptionExample
<string>HTML template.&lt;b&gt;%1;&lt;/b&gt; - %2;

Selectable

Makes the text selectable.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. False.
trueTrue.

Detects urls, emails and phone numbers and displays them as hyperlinks. Phone numbers can be: E.164 format, [+]XXX XXX XXXX or [+]XXX-XXX-XXXX.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Disabled.
trueEnabled.

Button

Copy Text

Specifies the text to be copied in the clipboard when the button is clicked.

The default value is: [Cell's value].

Attribute Values
ValueDescription
<string>A text.

Button Color

Specifies the button color.

The default value is: default.

Attribute Values
ValueDescription
defaultDefault value. Default color.
primaryPrimary color, used to highlight action buttons.
warningWarning color, used to highlight warning buttons.
successSuccess color, used to highlight success buttons.
errorError color, used to highlight error buttons.
lightLight color.
darkDark color.
red,blue,yellow,green,yellow,purple,orange,greenPalette colors.
customCustom color, defined in the "Custom Color" attribute.

Button Look

Specifies the button's look.

The default value is: filled.

Attribute Values
ValueDescription
filledDefault value. Filled look, with a solid background.
clearClear look, no background or border.
outlinedOutlined look, with a solid border.
glassGlass look, with a semi-transparent background.

Button Label

Specifies the button's label.

Attribute Values
ValueDescription
<string>Button's label.

Button Description

Specifies a description displayed below the label.

Attribute Values
ValueDescription
<string>Button's description.

Button Icon

Specifies an icon to display. Its position is set with the "Icon Position" attribute.

Attribute Values
ValueDescription
<icon>An icon or image.

Button Text Align

Sets the horizontal alignment of the text.

The default value is: none.

Attribute Values
ValueDescription
noneDefault value. No alignment.
leftLeft alignment.
rightRight alignment.
centerCenter alignment.
justifyJustified alignment.

Image

Image

Specifies an image to show.

The default value is: [Cell's value].

Attribute Values
ValueDescription
<image>Path to the image file. Files are searched inside the project's directory first, then inside the www/img directory.

Icon Color

Specifies the icon color.

Typography

Font Family

Specifies the font family.

The default value is: default.

Font Size

Specifies the font size in pixels or percentage (relative to the project's font size).

The default value is: 14.

Attribute Values
ValueDescriptionExample
<integer>Font size in pixels.
<percentage>%Relative font size in percentage.90%

Font Color

Specifies the text CSS color.

Attribute Values
ValueDescriptionExample
<html color>Color in any html accepted format.#ff0000

Font Weight

Specifies the weight of the font.

The default value is: normal.

Attribute Values
ValueDescription
normalDefault value. Normal.
boldBold.
bolderBolder.
lighterLighter.

Italic

Show the text in italics.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Normal.
trueItalics.

Small Caps

Sets the font to small caps.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Normal.
trueSmall caps.

Decoration

Specifies the text decoration.

The default value is: none.

Attribute Values
ValueDescription
noneDefault value. No decoration.
underlineUnderline.
overlineOverline.
line-throughLine through.

Line Height

Sets the line height of the text.

The default value is: 1.0.

Attribute Values
ValueDescription
<float>Specify the line height as a multiple of the font size.

Progress

Value

Specifies the current value of the progress bar.

The default value is: [Cell's value].

Attribute Values
ValueDescription
<int>Current value.

Max Value

Specifies the maximum value of the progress bar.

The default value is: 100.

Attribute Values
ValueDescription
<int>Maximum value.

Status

Specifies the status of the progress bar.

active displays an animation over the progress bar.

success and error display icons in place of the value label.

auto chooses the status depending on the current value:

  • active if the value is less than the maximum value
  • success if the value is equal to the maximum value
  • error if the value is less than 0

The default value is: auto.

Attribute Values
ValueDescription
autoDefault value. Chooses status depending on the current value.
idleIdle status, no animation.
activeActive status, displays an animation.
successSuccess status, displays a checkmark icon.
errorError status, displays a cross icon.

Color

Specifies the color of the progress bar.

The default value is: auto.

Show Percentage

Specifies whether the current percentage is shown.

The default value is: true.

Attribute Values
ValueDescription
trueDefault value. Current value is shown.
falseCurrent value is not shown.

Edit Field

Field Type

Specifies the type of the edit field.

The default value is: text.

Attribute Values
ValueDescription
noneNo edit field.
textDefault value. Single line text field.
multilineMulti line text field.
checkboxCheckbox.
selectSelect box.
dateDate picker.
timeTime picker.
datetimeDate and time picker.
time-intervalTime interval picker.
keypadKeypad.
hiddenHidden field, not displayed in the edit popup. Useful for sending data to the server.

Field Name

Specifies the name of the field, used to send a command to the server, along with the field's value as a parameter.

If the name starts with $, then the server will automatically set a variable with the same name as the command, containing the command's parameter.

The default value is: =dataname.

Attribute Values
ValueDescriptionExample
<string>Command name.
$[variable name]A command name that sets a variable.$myvar
$[variable name]!A command name that sets a persistent variable.$myvar!

Placeholder

Specifies a short hint that describes the expected value of the field (e.g. a sample value or a short description of the expected format).

The short hint is displayed in the input field before the user enters a value.

Attribute Values
ValueDescription
<string>Placeholder text.

Field Icon

Specifies the field's icon image.

Attribute Values
ValueDescription
<image>Image path or icon id.

Clear Button

Show a clear button that clears the field's value.

The default value is: false.

Attribute Values
ValueDescription
trueShow the clear button when there's any value set.
falseDefault value. Hide the clear button.

Prefix

Specifies a prefix to display before the field's value.

Attribute Values
ValueDescription
<string>Prefix text.

Suffix

Specifies a suffix to display after the field's value.

Attribute Values
ValueDescription
<string>Suffix text.

Focus Tooltip

Specifies a description tooltip to display when focusing the field.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
<string>Tooltip text.

Error

Specifies that the field is in error state.

The default value is: false.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

note

This attribute is live. It can't be set from the Project Editor, it needs to be set dynamically with a UISet.

Attribute Values
ValueDescription
falseDefault value. Normal state.
trueError state.

Error Tooltip

Specifies a custom error tooltip to display when focusing the field. Displayed only if the field is in error state.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

note

This attribute is live. It can't be set from the Project Editor, it needs to be set dynamically with a UISet.

Attribute Values
ValueDescription
<string>Error tooltip.

Required

Specifies if the field is required when adding and editing. If true, an empty/null value is considered not valid. When there are non valid fields, the confirm button focuses the first non valid field instead of sending data to the server, to prompt the user to fill in the required fields.

The default value is: auto.

Attribute Values
ValueDescription
autoDefault value. If the table is connected to a datasource, this attribute is controlled by the datasource's nullable attribute on the specified column. Otherwise it's set to false.
trueA value is required. Where it applies, null values can't be selected.
falseAn empty/null value is accepted.

Default Value

Specifies the default value in the add popup's edit field. This value is used to initialize the field's value when adding a new item. It's ignored when editing an existing item.

Attribute Values
ValueDescription
<string>A default value.

Edit Field Options

Checkbox Label

Specifies a label that is displayed next to the field.

Attribute Values
ValueDescription
<string>A label.

Keypad Label

Specifies a label.

Attribute Values
ValueDescription
<string>Label.

Min

Specifies the minimum value allowed.

Attribute Values
ValueDescription
<string>Minimum value.

Max

Specifies the maximum value allowed.

Attribute Values
ValueDescription
<string>Maximum value.

Digits

Specifies the number of digits allowed.

Attribute Values
ValueDescription
autoAny number of digits.
<int>Maximum number of digits.

Decimals

Specifies the number of decimals allowed.

The default value is: 0.

Attribute Values
ValueDescription
<int>Number of decimals.

Password

Hides the typed value, providing a way for the user to securely enter a password.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Typed value is not hidden.
trueHide the typed value.

Field Data Mode

Specifies the mode of the data.

The default value is: items.

Attribute Values
ValueDescription
itemsDefault value. Data is set with the UI attribute Items.
listData is a list of comma-separated values. Set in the List attribute.
datasourceData is set by a linked datasource.

Field Datasource ID

Specifies the ID of the datasource.

The datasource keys are used as values, while a column specified in Label Data Name is used as label.

The default value is: =datasourceid.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Field Label Data Name

Specifies the name of the column containing the label.

The default value is: =labeldataname.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Field List

Sets the items. An item with a label "---" (three hyphen-minus characters) is treated as a separator and its value is ignored.

The default value is: =list.

Attribute Values
ValueDescriptionExample
<comma-separated list>Items specified as a comma-separated list.item1,item2,item3
<array>Items specified as an array of strings.["item1","item2","item3"]
<array of arrays>Items specified as an array of arrays. Each item has an array of value and label.[[1,"label1"],[2,"label2"],[3,"label3"]]
<array of arrays>Items specified as an array of arrays. Each item has an array of values that can be recalled from the template attribute.[[1,"label1","descr1"],[2,"label2","descr2"],[3,"label3","descr3"]]

Field Items

Specifies the items.

The default value is: =items.

Multi

Specifies if the field is multi select.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Single select.
trueMulti select.

Field Template

Specifies the template for the items.

The template can contain placeholders for the values of the items. The placeholders are specified as %0;, %1;, %2;, etc.

For example, if the template is %0; - %1;, %2; and the item is ["value", "label", "descr"], the result is value - label, descr.

If the template is not specified, the items' labels are displayed.

Field Filter

Displays an input field for filtering the items. After typing a value in the field or setting the Filter Value attribute, any item that does not match the input will be hidden. A match occurs when the filter value is found anywhere within any item's fields ('value', 'label', etc).

The default value is: false.

Attribute Values
ValueDescription
trueDisplay the filter field.
falseDefault value. Hides the filter field.

Free Input

Specifies if the user can input a value that is not in the list.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Only the items in the list can be selected.
trueThe user can input a value that is not in the list.

Specifies the width of the select's popup.

The default value is: auto.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
autoDefault value. Popup is wide enough to fit the content, but not wider than three times the field's width.
<int>Width in pixels.

Password

Hides the typed value, providing a way for the user to securely enter a password.

In toggle mode, a toggle button is displayed that allows the user to show the typed value.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Typed value is not hidden.
trueHide the typed value.
toggleShow a toggle button that allows the user to show the typed value.
toggle-falseShow the toggle button, but show the typed value by default.

Sanitize Value

Specified one or more sanitization options to apply to the field's value before sending it to the server.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
trimRemoves leading and trailing whitespaces and line breaks.
carriage-returnRemoves carriage returns.
non-printableRemoves non-printable characters.
lowercaseConverts the value to lowercase.
uppercaseConverts the value to uppercase.

Validate Key

Specifies a regular expression to be validated on a keypress. E.g. "[a-z]" will allow only lowercase letters.

Won't work on Android devices.

Attribute Values
ValueDescription
[empty]Default value. No validation, all keys are allowed.
[a-z]Only lowercase letters.
[A-Z]Only uppercase letters.
[0-9]Only numbers.
[0-9a-zA-Z]Only numbers and letters.
<string>Regular expression.

Validate Value

Specifies a regular expression that the field's value must match.

Attribute Values
ValueDescription
[empty]Default value. No validation, any input is valid.
[a-z]+Only lowercase letters.
[A-Z]+Only uppercase letters.
[a-zA-Z]+Only letters.
[0-9]+Only numbers.
[0-9a-zA-Z]+Only numbers and letters.
<string>Any regular expression.

Min Length

Specifies the minimum number of characters required for the field's validation.

Attribute Values
ValueDescription
<int>Length in characters.

Max Length

Specifies the maximum number of characters allowed in the field.

Attribute Values
ValueDescription
<int>Length in characters.

Validate Tooltip

Specifies a custom validation tooltip to display when focusing the field. Displayed only if the current value doesn't match the validation criteria.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
<string>Validation tooltip.

Field Height

Height of the edit field in pixels.

Step

Specifies the step of the time picker, referred to the smallest unit of time that can be selected.

E.g. if the smallest unit is minutes and step is set to 15, the time picker will allow to select only times that are multiple of 15 minutes.

The default value is: 1.

Attribute Values
ValueDescriptionExample
<int>Step of the picker.15

Precision

Specifies the precision of the time picker, the smallest unit of time that can be selected

The default value is: minute.

Attribute Values
ValueDescription
minuteDefault value. Minute.
secondSecond.
msMs.

Step

Specifies the step of the time picker, referred to the smallest unit of time that can be selected.

E.g. if the smallest unit is minutes and step is set to 15, the time picker will allow to select only times that are multiple of 15 minutes.

The default value is: 1.

Attribute Values
ValueDescriptionExample
<int>Step of the picker.15

Unit

Specifies the unit of the value.

E.g. Unit: hour, Max Precision: hour, Min Precision: second. 5:30 will be parsed as 5.5. Unit: second, Max Precision: hour, Min Precision: second. 5:30 will be parsed as 330.

The default value is: hour.

Attribute Values
ValueDescription
yearYear.
dayDay.
hourDefault value. Hour.
minuteMinute.
secondSecond.
msMs.

Min Precision

Specifies the minimum precision of the time picker, the greatest unit of time that can be selected

The default value is: hour.

Attribute Values
ValueDescription
yearYear.
dayDay.
hourDefault value. Hour.
minuteMinute.
secondSecond.
msMs.

Max Precision

Specifies the maximum precision of the time picker, the smallest unit of time that can be selected.

The default value is: minute.

Attribute Values
ValueDescription
yearYear.
dayDay.
hourHour.
minuteDefault value. Minute.
secondSecond.
msMs.

Min Value

Specifies the minimum value of the time interval, in the unit specified by Unit.

Attribute Values
ValueDescriptionExample
<float>Minimum value of the interval.5.5

Max Value

Specifies the maximum value of the time interval, in the unit specified by Unit.

Attribute Values
ValueDescriptionExample
<float>Maximum value of the interval.5.5

Value Options

Specifies additional value options, which appear as buttons.

The default value is: [{"value":"*", "label":"- -"},{"value":"now", "label":"$now;"}].

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
<array>Array of JSON options, each with value and label properties.

From Date

Specifies the earliest selectable date. Dates prior to this will not be selectable. The format is specified by the Data Format attribute.

"now" specifies the current date. "[+|-][y|M|w|d]" specifies a date relative to today, where y=year, M=month, w=week, d=day.

Attribute Values
ValueDescriptionExample
<string>Date value formatted as specified in Data Format.2020-12-31
nowCurrent date of the browser.
[+|-][y|M|w|d]Relative date, where y=year, M=month, w=week, d=day.-1w

To Date

Specifies the latest selectable date. Selection of dates beyond this point is not permitted. The format is specified by the Data Format attribute.

"now" specifies the current date. "[+|-][y|M|w|d]" specifies a date relative to today, where y=year, M=month, w=week, d=day.

Attribute Values
ValueDescriptionExample
<string>Date value formatted as specified in Data Format.2020-12-31
nowCurrent date of the browser.
[+|-][y|M|w|d]Relative date, where y=year, M=month, w=week, d=day.+1w

Value Options

Specifies additional value options, which appear as buttons.

The default value is: [{"value":"*", "label":"- -"},{"value":"now", "label":"$today;"}].

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
<array>Array of JSON options, each with value and label properties.

Add/Edit Popup

Edit Popup Column

Specifies the column index in the add/edit popup. First column has index 1

Minimum value is 1.

The default value is: 1.

Attribute Values
ValueDescription
<int>Column index starting from 1.

Edit Popup Order

Specifies the order by which the fields appear in the add/edit popup's layout.

If set to auto, the fields appear in the same order as the table's columns, including hidden columns.

If set to a number, the order is the specified number, starting from 1.

For example: to swap the edit fields of the 3rd and 4th columns, set their Edit Popup Order to 4 and 3 respectively.

Minimum value is 1.

The default value is: auto.

Attribute Values
ValueDescription
autoDefault value. Follows the column order, starting from 1.
<int>Specifies a new order.

Edit Popup Title

Specifies a title header above the field, used to group multiple fields logically.

Attribute Values
ValueDescriptionExample
<string>A title.Address

Edit Popup Description

Specifies a description label that appears below the field, used to give more information about the fields.

Attribute Values
ValueDescriptionExample
<string>A description.Insert your full name including the title

Hide Field

Hides the field in the add and/or edit popup. If a field is hidden, its value is not sent to the server.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Visible.
addHidden in add popup, visible in edit popup.
editHidden in edit popup, visible in add popup.

Disable Field

Disables the field in the add and/or edit popup. If a field is disabled, its value is not sent to the server.

The default value is: false.

Attribute Values
ValueDescription
falseDefault value. Enabled.
addDisabled in add popup, enabled in edit popup.
editDisabled in edit popup, enabled in add popup.
bothDisabled in both add and edit popup.

Save Value

Specifies if the value of this field is sent to the server when confirming an add or edit operation.

This attribute does not affect the pre-add, pre-edit, edit-change commands.

If set to "auto", the value is sent if the field is not disabled.

If set to "changed", the value is sent if the field's value is different from the initial value.

The default value is: auto.

Attribute Values
ValueDescription
autoDefault value. The value is sent to the server if the field is not disabled.
trueThe value is always sent to the server.
falseThe value is never sent to the server.
changedThe value is sent to the server if the field's value is different from the initial value.

Other

Import

Specifies how the imported column values are parsed.

The default value is: value.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
falseImport disabled for this column.
valueDefault value. Import the value.
keyImports the key value, if there's a linked datasource.
formattedAttempts to parse the value when importing (results can vary depending on the input).

Export

Specifies how the column values are exported.

The default value is: value.

note

This attribute is experimental. It might not work properly and it might be modified or removed in a future release.

Attribute Values
ValueDescription
falseExport disabled for this column.
valueDefault value. Exports the value. Can differ from raw if there's a linked datasource or an edit field of type "select" .
keyExports the key value (as received from the datasource or from the items attribute).
formattedExports the formatted value.

Filter

Controls whether the column's value is used when filtering the table.

If set to "formatted", the displayed value is used.

If Column Filters are enabled and this attribute is false, the column filter field is not displayed for this column.

The default value is: formatted.

Attribute Values
ValueDescription
falseThe filter check skips this column.
valueThe filter is applied to the value.
formattedDefault value. The filter is applied to the formatted value.

Sort

Specifies sorting behavior for this column. Applies only if table is sortable.

The default value is: ascii.

Attribute Values
ValueDescription
asciiDefault value. Column is sorted using an lexicographical sort algorithm.
naturalColumn is sorted using a natural sort algorithm.
offColumn is not sortable.

Tooltip

Specifies a tooltip to be displayed when the mouse hovers over the cell.

Attribute Values
ValueDescriptionExample
<string>A tooltip.This is a tooltip