Select to view content in your preferred language

Create rule to control options in dropdown

176
4
Jump to solution
3 weeks ago
CMcDonald
Frequent Contributor

Hello,

is it possible in the Survey web designer to use a Single select option to then control what choices are available in a Dropdown if some of the single select choices also allow same matching selection in the dropdown.

I am not very experienced with the Connect app but discovered there is a way to do a one to one match of sorts for picnic tables but not for bences.

Below is the logic I would like to achieve if possible?

Feature TypeRuleModel 
Drop Down (Single Choice) Drop Down (Single Choice)
Bench IF Bench OR Available space for a bench OR Vacant but reservedStreetmaster Clarendon Green
Picnic TableIF Bench OR Available space for a bench OR Vacant but reservedCavendish
Available space for a benchIF Bench OR Available space for a bench OR Vacant but reservedPhoenix Jubilee Sea
Vacant but reservedIF Bench OR Available space for a bench OR Vacant but reservedPhoenix Bench (no arms)
 IF Bench OR Available space for a bench OR Vacant but reservedPlymouth
 IF Bench OR Available space for a bench OR Vacant but reservedGlen Ogil
 IF Bench OR Available space for a bench OR Vacant but reservedRub/Queens Wave Bench
 IF Bench OR Available space for a bench OR Vacant but reservedHaz Queen Mother Bench
 IF Bench OR Available space for a bench OR Vacant but reservedUnknown Bench
 IF Picnic TableHillside Picnic Table
 IF Picnic TableHillside Picnic Table – DDA
 IF Picnic TableUnknown Picnic Table

So for example if user selects Bench from the Single choice they can only select from the dropdown 'Plymouth' and if they select Picnic Table, 'Hillside Picnic Table'

I hope this makes sense.

Thanks

0 Kudos
1 Solution

Accepted Solutions
Neal-Kittelson
Frequent Contributor

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-...

Read this tips and tricks regarding choice filters, it explains cascading selects.

Short is you can add those custom "helper" columns to filter your choice list.

View solution in original post

4 Replies
Neal-Kittelson
Frequent Contributor

Yes,  you will have to set up the second list with all the duplicate values. One for each option in the first list that you want that item to be available for.

NealKittelson_1-1745933554163.png

 

 

CMcDonald
Frequent Contributor

Thanks @Neal-Kittelson My setup looks a little different in that I don't have a Choices column.

CMcDonald_0-1745936543091.png

 

0 Kudos
Neal-Kittelson
Frequent Contributor

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-...

Read this tips and tricks regarding choice filters, it explains cascading selects.

Short is you can add those custom "helper" columns to filter your choice list.

CMcDonald
Frequent Contributor

Thank you @Neal-Kittelson 

Using that guide my setup now seems to work 🙂

CMcDonald_0-1746001831052.png

 

0 Kudos