Add Data Grid to Workflows

You can add Data Grid to workflows. The Data Grid values can be read and modified within workflows.

In this example, we create a workflow with a For-Each loop activity. The user selects a Job in the WorkOrderJobsGrid and clicks Finish. The For-Each Loop activity iterates through the WorkOrderJobsGrid. An information mail is sent to the actor with details of Work Order Id, Operation ID and the Sequence number of the selected Job.

1. Create a form with a two level grid configuration, containing two lookups, Work Order and Jobs. Name the form as WorkOrderJobs scenario.

2. Associate the form with a workflow and name the workflow as WorkOrder Jobs WF.

3. Design the workflow. The SFFormData variable is created for the associated WorkOrderJobs scenario form.

   
   

4. WorkOrderJobsGrid is the mapped XML node for the Work Order and Jobs grid.

5. The grid selection information is stored in these nodes. To extract the required values and use it within workflows, we need to create XML variables of type XML Forms Data Grid.

6. Create a new XML variable of type XML Forms Data Grid for Work Order and Jobs Grid.

7. Select WorkOrderJobsGrid XML Node which is mapped to the Work Order and Jobs grid. This contains the complete selection information of the Data Grid.

   

8. We need an XML Iterator variable to loop through the Jobs for the selected Work Order. Create an XML Iterator variable LoopWorkOrder as shown in the following image:

   

9. Add a For-Each Loop activity. Set its Xml Iterator property with Iterator variable created above.

   

10. Add an Information activity. Set its Body property to show the Work Order ID, Oper ID, and the Seq No for the selected Job.

    

11. Publish and Test Run the workflow.

    

12. Select rows from Work Order Jobs Grid in the form and then click Finish.

    

13. Information is sent with the details of the selected job.