Table extensions let you extend existing FlowWright tables with fields and UI elements.  Add extra fields and track data for Users, Workflow, & Form definitions using the following UI:

User Table Extensions

Navigate to the Create - Table Extensions page. Select Users from the dropdown menu. A new table extension can be created by clicking the “Actions - Create” menu item. The following UI will be rendered. Provide the name and label information. Select the appropriate data type (navarchar, date, datetime, smallint, integer, largeint, bit) and size. Select the render type (text, date, datetime, checkbox, dropdownlist, textarea). Provide the selections and default values. Select the checkbox to have the user modify the configuration. 

Click on the Create button to confirm the action. A new field has been added to the user table extension, displaying an alert notification. For this new field extension, please take a look at the deUserDetails SQL table in the FlowWright database. 

Navigate to the Administration—User Management menu option. The column selector dropdown includes the new table extensions for Users, as shown below.  

The table extensions can be modified or removed using appropriate menu options from the Table Extensions page. 

Process Definitions Table Extensions

Navigate to the Create - Table Extensions page. Select Process Definitions from the dropdown menu. 

A new table extension can be created by clicking the “Actions - Create” menu item. The following UI will be rendered. Provide the name and label information. Select the appropriate data type (navarchar, date, datetime, smallint, integer, largeint, bit) and size. Select the render type (text, date, datetime, checkbox, dropdownlist, textarea). Provide the selections and default values. Enable the checkbox so the user can modify the table extension metadata values. Click on the Create/Update button to save. 

A confirmation message is displayed in the top right-end corner. A new field has been added to the For this new field extension; please take a look at the deDefinitionsDetails SQL table in the FlowWright database. 

Next, navigate to the Create - Process Definitions page. Select an existing process definition from the table and click the Actions—Edit menu option. You'll notice the table extension column in the Additional Information section. The user may change the metadata information by clicking the Update button to confirm the changes. 

Form Definitions Table Extensions

Navigate to the Create - Table Extensions page. Select Form Definitions from the dropdown menu. 

A new table extension can be created by clicking the “Actions - Create” menu item. The following UI will be rendered. Provide the name and label information. Select the appropriate data type (navarchar, date, datetime, smallint, integer, largeint, bit) and size. Select the render type (text, date, datetime, checkbox, dropdownlist, textarea). Provide the selections and default values. Enable the checkbox so the user can modify the table extension metadata values. Click on the Create/Update button to save. 

A confirmation message is displayed in the top right-end corner. A new field has been added to the For this new field extension, please take a look at the deFormDefinitionsDetails SQL table in the FlowWright database. 

Next, navigate to the Create - Form Definitions page. Select an existing process definition from the table and click the Actions—Edit menu option. You'll notice the table extension column in the Additional Information section. The user may change the metadata information by clicking the Update button to confirm the changes. 

Task Table Extensions

Navigate to the Create - Table Extensions page. Select Tasks from the dropdown menu.

A new table extension can be created by clicking the “Actions - Create” menu item. The following UI will be rendered. Provide the name and label information. Select the appropriate data type (navarchar, date, datetime, smallint, integer, largeint, bit) and size. Select the render type (text, date, datetime, checkbox, dropdownlist, textarea). Provide the selections and default values. Enable the checkbox so the user can modify the table extension metadata values. Click on the Create/Update button to save. 

A confirmation message is displayed in the top right-end corner. A new field has been added to the For this new field extension; please take a look at the deTasksDetails SQL table in the FlowWright database. 

Next, navigate to the Analytics—Business Intelligence page. Select the “Instance Plan, Actual, and Projected” report type from the drop-down list. Select existing process instance from the drop-down list having open tasks. Click on the Compute Summary button to generate a new report. You'll notice the task extension column in the report table.