Skip to main content

Data Table

Properties | Methods

Used to display detailed or child-level data related to a selected parent record in a structured table format. It allows users to view, add, edit, or delete item-level details, usually in line with a master-detail relationship.

Properties​

Custom ​

Columns​

'columns' json The individual fields or attributes displayed in a data table.

Accordion​

'accordion' decimal A collapsible interface section that expands or contracts to show or hide content.

Template Mode​

'template mode' decimal The display style or layout format applied to data (e.g., list vs. grid).

Column Group​

'column group' text A way to visually or functionally group several related columns together.

Allow Add​

'allow add' boolean Permission for users to insert new records or rows.

Allow Edit​

'allow edit' boolean Permission for users to modify existing records or rows.

Allow Delete​

'allow delete boolean Permission for users to remove existing records or rows.

Excel Exports​

'excel exports' boolean The ability to download or export table data in Excel format.

Selection Type​

'selection type' decimal How users can select data (e.g., single row, multiple rows, or individual cells).

'allow search' boolean Enables users to search within the table contents.

Paging​

'paging' json Breaking data into multiple pages for simpler navigation and viewing.

Row Template​

'row template' json A customizable layout or structure defining how each row looks.

Allow Next Record​

'allow next record' boolean Allows users to move directly to the next record—commonly used in detailed views or forms.

Conditional Format​

'conditional format' json Applying special styling (like color changes) based on specific data conditions.

Allow HTML Inputs​

'allow html inputs' boolean Permits the use of HTML markup within input fields, enabling formatted or rich-text content.

Additional Information​

'additionalnfo' json Used to store extra configuration or metadata that customizes the behavior and display of the data table

Others ​

Exclude Clone​

'exclude clone' boolean Prevents a row from being duplicated or included when cloning data entries.

Methods​

GetGridCtrlProperty​

function

Retrieves Column property value from Data Table Control

Default Variant

Return Type string | number | boolean

(The return type depends on the property being accessed.)

Syntax

GetGridCtrlProperty("<<Data Table Control ID>>","<<Column Order No.>>", "<<Property>>");

Example:
let columnValue = GetGridCtrlProperty("21", "3", "value");

Parameters

Data Table Control ID string: Unique ID of the Data Table control.

Column Order No. string: Column order in the Data Table.

Property string: Respective field control property to retrieve the value.


SetGridCtrlProperty​

function Sets the value for the control property in the data grid.

Default Variant

Return Type
N/A

Syntax

SetGridCtrlProperty("<<Data Table Control ID>>", "<<Column Order No.>>", "<<Property>>", "<<Value>>");

Example:
SetGridCtrlProperty("21", "11", "disabled", false);

Parameters

Data Table's Control ID string : Unique ID of the Data Table control.

Column Order No.string : Column order in the Data Table.

Property string : Respective field control property to retrieve the value.

Value string | number | boolean : The value that is set for the mentioned property before.