The “Table Extensions” feature lets you add fields and UI elements to the existing FlowWright tables.  

You can add extra fields and track data for Users, Workflow, and form definitions using the following UI.

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. Use the Search textbox to filter the result set. 

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 drop-down 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 (nvarchar, 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 appears in the top-right corner. A new field has been added to the form. For this new field extension, please take a look at the deFormDefinitionsDetails SQL table in the FlowWright database. 

Using the “DropDownList” render type, you can use the data connection to fetch data from an SQL table or provide a list of static values, as shown 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.

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 (nvarchar, 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 appears in the top-right 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.

Use this feature to add more documentation to the User schema. 

On the 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 (nvarchar, 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 shall be displayed in the top-right 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 pop-up displays the user's information for review and changes. As noted, the new table extension is available. Click the Update button to confirm the changes. 

Process Definitions Table Extensions.

Use this feature to add more documentation to the Process Definition 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 (nvarchar, 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 shall be displayed in the top-right 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.

Use this feature to add more documentation to the Process Instance schema. 

On the Table Extensions page, select 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 (nvarchar, 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 shall be displayed in the top-right 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. 

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 executes, and a confirmation message appears in the top-right corner. 

Search for the new process instance by its GUID to view the table extension values. 

Task Table Extensions.

Use this feature to add more documentation to the Task's schema. 

On the Table Extensions page, select 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 (nvarchar, 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 shall be displayed in the top-right 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 the Compute Summary button to generate a new report. You'll notice the task extension column in the report table.