Table extensions let you extend existing FlowWright tables with fields and UI elements.  You can add extra fields and track data for Users, Workflow, and form definitions using the following UI.

You must navigate to the Manage - Table Extensions page.

The Table Extensions UI is rendered below. The Form Definitions type is selected by default, showing the base table and details table information. You may use the Search textbox to filter the result set. 

You may use the drop-down list to switch between table extensions for Forms (definitions and instances), Process (definitions and instances), tasks, and users. 

Form Definitions Table Extensions.

On the Table Extensions page, select the 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 the Create button to confirm. The new table extension is created, and 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. 

Using the “DropDownList” render type, you may use the data connection to fetch SQL table data or provide a list of static values as below.   

An example is included for the Database data connection type here. 

Next, navigate to the Forms - Definitions page. Select an existing form 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 Instances Table Extensions.

You can use this feature to add more documentation to the form instances generated by the workflow. 

On the Table Extensions page, select the Form Instances 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 the Create button to confirm. The new table extension is created, and a confirmation message is displayed in the top right-end corner. 

A new field has been added to the deFormInstances SQL table in the FlowWright database. Note: For this new field extension, please look at the deFormInstancesDetails SQL table. 

User Table Extensions.

You can use this feature to add more documentation to the User's schema. 

On the Table Extensions page, select the 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. Enable the checkbox so the user can modify the table extension metadata values.  

Click the Create button to confirm. The new table extension is created, and a confirmation message is displayed in the top right-end corner. 

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. 

On the User Management page, select a user from the table list and click the Actions - Edit menu option. 

A popup is rendered with the user's information for changes. As noticed, the new table extension is available for use. Click the Update button to confirm the changes. 

Process Definitions Table Extensions.

You can use this feature to add more documentation to the Process Definition's schema. 

On the Table Extensions page, select the Process Definition in 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 the Create button to confirm. The new table extension is created, and a confirmation message is displayed in the top right-end corner. 

Next, navigate to the 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. 

Process Instances Table Extensions.

You can use this feature to add more documentation to the Process Instance's schema. 

On the Table Extensions page, select the Process Instances in 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 the Create button to confirm. The new table extension is created, and a confirmation message is displayed in the top right-end corner. 

A new field has been added to the deInstanceDetails SQL table in the FlowWright database. Note: For this new field extension, please look at the deInstanceDetails SQL table. 

You must navigate to the Process-Instances page and click the Actions-Create menu option. Select an existing process definition from the drop-down list and generate and execute a new process instance. The process instance is executed and a confirmation message is displayed in the top right-end corner. 

Please search for the new process instance by its GUID value to view the table extension values. 

Task Table Extensions.

You can use this feature to add more documentation to the Task's schema. 

On the Table Extensions page, select the Tasks in 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 the Create button to confirm. The new table extension is created, and a confirmation message is displayed in the top right-end corner. 

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