AnsweredAssumed Answered

And/or in a cascading select?

Question asked by Hayden_SAEON on Nov 22, 2019
Latest reply on Nov 27, 2019 by dougbrowning

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!