Select_mutiple question (with three type choices), followed by select_one (with two size choices)

JayHodny — Fri, 16 Jun 2023 15:26:14 GMT

I am working on a Survey123 Connect project supporting the exciting (?) topic of refuse cart delivery (trash, recycle and yard waste). Our current paper process is grossly inefficient. We have three cart types: trash, recycle and yard waste, and two sizes for each type: 45- and 95-gallon. One design is to list all possible carts, followed by selecting the carts needed for delivery at a city resident. While this design works, it is not elegant.

I was trying to use Relevant option to expose cart sizes based on carts chosen. Instead of having six cart type (and size) choices, I would have the three cart types in the initial select_multiple question. If trash was selected, then a second question is exposed to capture the trash cart size. If recycle is selected, then a second question is exposed to capture the recycle cart size. Same for the yard waste carts. Something like the screen shots below. The cart types are presented and a selection is made, any one cart requested, any two, or all three depending on the resident's needs.

then......based on cart type(s) chosen, the size field is then shown, and a size selection made. The size choices are the same for each cart type.

I have searched the world wide web and GeoNet, but have not found (yet) an example of how to set up this workflow in the XLSForm, using Relevant statements, or other techniques. I could use some help with my limited Connect form building skills. Many thanks in advance.

Re: Select_mutiple question (with three type choices), followed by select_one (with two size choices)

JayHodny — Fri, 16 Jun 2023 16:02:46 GMT

I did catch a mixed text case issue, which was causing some problems, but I am still not quite sure how to set up the conditional statements.

Re: Select_mutiple question (with three type choices), followed by select_one (with two size choices)

abureaux — Fri, 16 Jun 2023 19:47:12 GMT

I think this is what you are looking for?

I attached an XLSX with a couple of examples.

Re: Select_mutiple question (with three type choices), followed by select_one (with two size choices)

JayHodny — Tue, 20 Jun 2023 12:47:31 GMT

Yes! This is very helpful, thank you. I had the group 2 option set up (or close to it), but it wasn't working.

topic Select_mutiple question (with three type choices), followed by select_one (with two size choices) in ArcGIS Survey123 Questions

Select_mutiple question (with three type choices), followed by select_one (with two size choices)

Re: Select_mutiple question (with three type choices), followed by select_one (with two size choices)

Re: Select_mutiple question (with three type choices), followed by select_one (with two size choices)

Re: Select_mutiple question (with three type choices), followed by select_one (with two size choices)