Multiple Dropdowns Feeding off Each Other

jpence · February 24, 2020, 8:25pm

I have several dropdowns in series, one dependent on the data from another. Each is SQL query binding referencing the dropdown previous.

Is it possible to have the children, grandchildren, etc. go back to an unselected state after its parent or grandparent is changed?

Select Group feeds the Select Type

Select Type feeds the Select Area

Select Area feeds the Select Failure

grietveld · February 24, 2020, 8:31pm

Easiest way would be a change script for the tier above. You’d be manually just setting it back to -1 or what ever your no selection ID is set to.

jpence · February 24, 2020, 9:22pm

I see that. It appears that I do not have polling at that point, however. I’m OK with that.

Any other comments on best practice for this kind of thing?

grietveld · February 25, 2020, 12:24pm

You should be able to poll, otherwise you can use system.db.refresh() to trigger the refresh for the next binding as well.