exTables actions provide the user with a simple way to store frequently used scripts or procedures relevant to the table. These scripts can then be executed by anyone editing the table data. Commonly used actions are row validations, browser shortcuts and pushing data from exTables to other systems.
To create action user needs to open the table designer and press the “Edit Action” button.
There are three type of actions available in exTables:
- SQL Task – Allows user to execute SQL query or stored procedure. Common use of this action is to validate the data that just got changed.
- Execute Command – Allows user to fx. open email or browser. Can be used to open underlying system with row values as parameter
- Publish Data – Allows user to move edited data from exTables to underlying source.
All action types have a few shared customizable features:
- Visible in context menu
- Visible in toolbar / Customize toolbar icon
- Automatically run when saving data
- Save data before execution
- Refresh data after execution
Most of those actions are self explanatory but I’d like to mention a few interesting ways they can be used to enrich exTables.
Visible in context menu
This option allows user to select one or many rows and right click to execute the action. When executing the action this way, id’s of selected rows can be used by the action to fx. validate only the selected rows.
Visible in toolbar / Save data before execution / Refresh data after execution
These options work well together, along with the table property of hiding standard toolbar options (save, refresh, delete).
By selecting all three options, the data save, action and refresh all become a single operation and fx. a validate action is guaranteed to be executed and the validation results will be visible to the user afterwards.