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.
Double-click the object to open the configuration window.
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. |