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.


Create and Remove Actions

 

To create an Action the user needs to open the Table Designer and press the “Edit Action” button.


 


Inside the Actions form you can simply Add(1) and Remove(2) Actions by clicking the "Add" and "Remove buttons" and see a List(3) containing all your Actions. 



Action Types


There are three types 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. To learn more about SQL Tasks please head over to SQL Task article.  


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. To learn more about Publish Data please head over to Publish Data Action article.

 


Shared Customizable Features


All action types have a few shared customizable features:


Display- & Database Name


Display Name(1): If you choose to make your Action visible in the Table Editor this is the name that will appear on the Action there. 


Database Name(2): This name will be stored as the Action name in the Database. 




Exec Options Tab


Automatically run when Saving Data(1): Check this box if you would like your Action to run every time you save you Data in the Table Editor.


Save Data before Execution(2): Check this box if you would like the Table Editor to save the grid changes before the Action is executed. 


Refresh Data after Execution(3): Check this box if you would like your data to be refreshed after the Action has been executed to see the changes.  



Display Options Tab


Description(1): Add a description for your Action. This description will also be visible in the Actions tooltip in the Table Editor Toolbar.


Icon(2): If you choose to have your Action visible in either the Context Menu or Toolbar this Icon will appear next to the Actions' Display name


Visible in the Context Menu(3): Check this box if you would like your Action to be visible in the Table Editor's Context Menu (right-click a row to see the Context Menu). This option allows the 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(4): Check this box if you would like your Action to be visible in the Table Editor's Toolbar. 




 


You can read more about each action type under SQL Task Action, Execute Command Action and Publish Data Action.