How to restrict lists based on selections in two fields

[Anonymous User]

Hello all!!

I am trying to get a list to be restricted based on previous selections. I need the user to be able to select a context zone and then a functional classification and then list the street types that are associated with both. For example if the user selects Neighborhood commercial and Arterial then I need the only items in the list to be Urban connector general urban  and main street but if they select collector then the list will only contain General urban or main street. 

does anyone know how to pull that data? I can do it for a single cell but not two. 

[jcarlson]

I'm assuming you are using Survey123 Connect? If not, you probably should be for a more complex situation like this.

In our County, we use Survey123 to handle some inter-departmental workflows, and we have a "status" field. Like your situation, we want the status to be filtered by the choices in both the "review" and "dept" fields.

On the choices tab, it looks like this:

So basically you need an entry for every unique allowable combination, but it's definitely possible. Once your choices are all set, change the type of the field in question on the survey tab to something like "select_one your-list-name".

[Anonymous User]

Hey Josh, 

So did that limit what the user could choose from that drop down or did you include all the options in there? I am in connect so that is not the problem. I would just like it limit what can be selected based on their answers

[jcarlson]

Yes, that limited the dropdown options. In the screenshot above, if a user had selected "assr" for the dept field, only those rows which had "assr" in the "dept" column appeared available to them in the form for the status field.

To use the same form from above, there are certain combinations which can only lead to a single status outcome. Supposing review were set to "Not GIS Relevant" and dept were set to "GIS", the status dropdown will only show "Closed" as an option.

[DougBrowning · Accepted solution]

You want Choice filters.  Take a look here  https://www.google.com/search?q=survey123+choice+filter&rlz=1C1GCEA_enUS798US798&oq=survery123+choic...

hope that helps

[Anonymous User]

This worked perfectly! Thank you so much!!