Hi. I have a use case where I have three lists and I want to be able to constrain what is visible in the lists based off what was selected in the previous list.
Simple enough using a standard cascading select.
However, with my use case, I need to be able to constrain the third list based off a selection from list one and then optionally constrain it further based off a selection in list 2.
I have attached a simplified version of the XLS form that I have tried this with.
So in this simplified case, I want the user to select the state they live in and get a list of counties in question 2 constrained by their selection in question 1 and a list of all the cities in that state in question 3 constrained by selection in question 1. Then, if the user selects a county in question 2, I want question 3 to be further constrained by their selection in question 2.
Any help would be appreciated!