Select to view content in your preferred language

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

1165
3
Jump to solution
06-16-2023 08:26 AM
Labels (1)
JayHodny
Frequent Contributor

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.

JayHodny_0-1686928079486.png

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.

JayHodny_2-1686928775892.png

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. 

JayHodny_1-1686928481072.png

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.

 

 

0 Kudos
1 Solution

Accepted Solutions
abureaux
MVP Frequent Contributor

I think this is what you are looking for?

abureaux_0-1686944790198.png

 

I attached an XLSX with a couple of examples.

View solution in original post

0 Kudos
3 Replies
JayHodny
Frequent Contributor

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.

0 Kudos
abureaux
MVP Frequent Contributor

I think this is what you are looking for?

abureaux_0-1686944790198.png

 

I attached an XLSX with a couple of examples.

0 Kudos
JayHodny
Frequent Contributor

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

0 Kudos