Table

Tables are primarily used as utilities and for storing configuration data for business rules. Tables are materialized as SQL Server tables and can be read and written to by any SQL script or process having the required permissions.

Actions

Load Data

Use this action to load or refresh the table.

Save Data

Use this action to save all of the changes to the database.

Add Item

Use this action to add new row to the table.

ExecuteExpression

Executes one or more instructions.

Unload Data

Unloads the data.

Validate Data

Validates data. Run it if you want to run the Cell Validation rules before data is saved, and optionally prevent the save process for the particular Worksheet from executing if the validation fails.

Validate(terminateOnValidationFailed : boolean | Eaze expression)

Recalc

The Recalc action triggers the execution of the formulas script in the spreadsheet. You can call SetDataModified(…) in Recalc actions.

calc

Events

Data Modified

This event is raised when data in a table is modified.

Cell Action Link Tapped

This event is raised when an action link cell in a table is clicked. The payload of the event is the name of the column that was clicked and the row object.

This event is raised when a custom context menu action is clicked. The payload of the event is the name of the action that was clicked, the column and the row object that the cell belongs to.

Item Added

This event is raised when you add a new item to the table, for example, a new row.

Table of Contents