EditGridData form UI control provides an in-place editing of data with certain level of functionality.

Use a SELECT SQL statement to fetch records from a single table / form data table and edit them in a grid. Configure the form control, route the form through a workflow where a FlowWright administrator can approve the edit grid modifications.The SELECT statement can also fetch records from multiple tables and the grid behaves in read-only mode.

With In-place editing of data;

• Define what fields (columns, rows) can be modified or not
• Ability to define editable controls with complex configuration
• Use (text box, drop down, checkbox, date picker) controls for editing
• Trigger an individual processes from EditGridData form

Example (construct):

This setup requires, 2 sets of process and form definitions, to construct and execute. 

A FormFill (form definition), accepts a sample user input and stores in a data table, by a process instance. 

A FormFillEditGrid (form definition), displays the above data table in an EditGridData control, with provisions to approve and submit. 

An ApproveForm (process definition), instantiates a workflow and routes the FormFillEditGrid to an user, for approval and submission.

A WorkflowFillForm (process definition), instantiates a workflow and routes the FormFill to an user, to accept user input to a data table. 

Let’s build the FormFill example.  

• Create a new form definition called “FormFill”
• Select the Open Designer checkbox and click the “Create” button
• Drag the label and text box controls. Arrange them on the canvas as shown in the graphic below. Add the form submit button also. Save the definition to confirm the changes.

• Navigate to the Form Definitions page - select the above form definition - choose Actions menu and select "Data Table" option to create a form data table (FormData_FillForm) as shown in the graphic below.

• Navigate to the Form Instances page.  - select the above form definition - choose Actions menu and select "Data Table" option to create a form data table as shown in the graphic below. Save the definition to confirm the changes. 

Let’s build the FormFillEditGrid example.  

• Create a new form definition called “FormFillEditGrid”
• Select the Open Designer checkbox and click the “Create” button
• Drag the EditGridData widget to the canvas. Drag the submit, approve/reject buttons also.

• Edit the control and configure the properties as shown in the graphic below. In Settings tab, select the form data table as the query.

• In Column Definitions tab, map the column names with the select control fields as shown in the graphic below.

• In Actions tab, configure the required actions as necessary like as shown in the graphic below.

• Save the form definition to confirm the changes.

Let’s build the ApproveForm example.  

• Create a new process definition called “ApproveForm”
• Drag the RouteForm step to the canvas. Configure the step properties as shown in the graphic below. Map the form definition to FormFillEditGrid created above. Configure the variable.FIID to hold the form instance ID. Route the step to an user. Save the process definition to confirm the changes.  

Let’s build the WorkflowFillForm example.  

• Create a new process definition called “WorkflowFillForm”
• Drag the RouteForm and task steps to the canvas. Configure the step properties as shown in the graphic below. Map the form definition to FormFill created above. Configure the variable.FIID to hold the form instance ID. Route the step to an user. Save the process definition to confirm the changes.  

Example (execute):

Open WorkFlowFillForm process definition, create and execute a new process instance. This instantiates a workflow and routes the FormFill to an user, to accept user input and submit to a data table.  

Navigate to Create - Data Table menu option to view the data table records. 

Open ApproveForm process definition, create and execute a new process instance. This instantiates a workflow and routes the FormFillEditGrid to an user, for approval and submission. 

Select the record to modify the contents. Confirm the changes. 

Approve the selected record and submit. 

Navigate to WorkFlowFillForm process instance and render to view. The submission of EditGridData form has triggered an individual processes and has navigated to the completed path successfully.