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

1. 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.

2. Others

Exclude Clone

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

3.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.