Populate a child advanced data grid dynamically.

ramsfan2000

I am building out an advanced data grid that will be populated based on the selected item in my parent data grid. For example, when I select an item in the first data grid, I want to populate an array of records for a second data grid based on my selection. What is the best way to configure this?  

Kobebills_Decisions

Hello, 

You can populate a child advanced data grid(ADG) by passing in the selected parent ADG record into an Active Form Flow(AFF). The AFF would use this to fetch the child ADG data and set the values for the child ADG. The following steps will show one way this can be configured:  

Prerequisites:  

1)Preexisting data to populate ADG.  

2)Form with two ADGs configured. My example has the Parent ADG using SingleSelect as the Grid Mode. 

 

Steps: 

 1)For parent ADG. set Input Data Name and Output Data Name under Properties > Input/Output 

 2) For child ADG, set Input Data Name using same Output Data Name value from step 1. 

 3)Create Active Form Flow under Logic > Add to List and edit flow. 

           a. Note: The behavior is dependent on the exact triggers of the Active Form Flow. In my example, I have Run at                           Start and run during SelectionChanged as triggers. 

4)Add AFF logic to fetch child data grid data using the FormData.Output Data Name selected in the parent data grid. 
              a. In my example, I used a Fetch Entities step to fetch models based on the selected car make. 

5)Add Set Control Value step to flow and set Form Control input to FormData.<Insert Child Data grid name>.

6)Input data returned from step 4 into Output Data Name input.  

7)Save and run flow.  

  

Please Note: The examples attached were developed to be instructional, and were not developed as officially supported components.  For more information or to engage our service team to develop fully supported, production quality solutions, please contact: services@decisions.com