Update Data Grid based on Drop-down Selection

Unknown

Update Data Grid based on Drop-down Selection

Unknown

How do I do this? Also, is there a way to periodically refresh the data in the drop-down box?

Unknown

Hi Sissafriss,

To update a datagrid’s information dynamically based upon a drop-down box selection you must create a form [b]data flow[/b] that runs or “triggers” whenever a the drop-down selection changes. The [b]data flow[/b] will run and fetch whatever data you would like to be displayed in the data grid, and the data grid will take that [b]data flow’s[/b] output as input to be displayed.
The same method can be used to update the drop-down selection data as well.

Below I’ve attached some images that detail how this process might look, using two data structures “Bank Files” and “Bank Process Status”

Set drop down to take input from data flow, this data flow gets bank files:
[b][color=rgb(127, 140, 141)][font=Roboto][img]att4[/img]

[/font][/color][/b]
Set data grid to take input from data flow. In this case I used a separate data flow that gets Bank Process Statuses based on the selected Bank File:
[color=rgb(127, 140, 141)][font=Roboto][img]att3[/img]

[/font][/color]
Set the settings for the first data flow that gives the drop-down it’s input. Notice I have an event button that I’ve toggled under “triggers”. This “triggers” the flow to run when the event button is clicked. Alternatively you can use the “Auto Run” setting to enable the flow to run automatically while the form is open every so many seconds, minutes, etc:
[color=rgb(127, 140, 141)][font=Roboto][img]att2[/img]

[/font][/color]
Since we have two data flows in use in this form, we have to also set the settings for the data flow that updates the input to the data grid: [color=rgb(127, 140, 141)][font=Roboto][img]att1[/img][/font][/color]
[i]edited by Brendan@decisions.com on 4/5/2019[/i]
[i]edited by Brendan@decisions.com on 4/5/2019[/i]