13.2.3 Relate Features

Sync with List Control object

User data table can be synced with list control to display the contents on the page.

Drag-drop the list control object from the toolbox to the page.

image-20240603-224649.png

 

Double-click the object to open the configuration window.

image-20240603-224750.png

 

Item

Description

User Data Table Model

Displays the list of the user data table models in the project.

Import Model

Imports the datasheet of the selected user data table model.

Edit

Edits the selected column data

OK

Stores the settings to the list control object.

Cancel

Cancels the changes and exits the configuration window.

 

Selecting a model and the pressing the [Import Model] button will automatically fill the datasheet. The column name and the width can be changed.

Adding records to the model on the web

The user can use the function below to insert an item to the user data table.

Command

Description

DbInsert

Adds an item to the user data table model.

DbInsert

Adds an item to the user data table model.

Function

Operation

DbInsert(“User Data Table Name”)

Script

n = DbInsert(“User Data Table Name”)

Description

This function reads the tag value which is registered to the User Data Table and saves it as a data of the DB with the time data. If the function fails to save the data, a value except 0 is returned.

Example

Saves data to the model named “TEST”

n = DbInsert(“TEST”)

Controlling list control on the web

 

Item

Description

Fetch Data

Displays a popup to assign the time range to fetch the data.

Custom filter

Shows the custom filter UI on the list control object.

Excel

Exports the data displayed on the list control object as an excel file.