Select to view content in your preferred language

Filtering and display of multiple choice list based on pre-populated value

144
2
Monday
KushShah
Emerging Contributor

Hello,
I have this survey123 connect xls form, it has nearest_pipeline name field that display pipeline that is closest to the event_point_point geopoint location and fill dynamically from calculation. I have another field called "Opername" that dynamically display the multiple choice values in appearance column. So here I want to make connection between the values of "nearest_pipeline" and "Opername" that if the value displays in nearest_pipeline, I don't want it to be displayed again but other values in multiple choice list of "Opername".

For eg. If nearest_pipeline box displays "ENBRIDGE" value, I want other choice list except the one displayed in nearest_pipeline box.

I've attached the SurveyTest xlsx file. Looking forward to any help/suggestions in this regard. Thanks!

0 Kudos
2 Replies
DougBrowning
MVP Esteemed Contributor

If I am reading this right I think you want Choice Filters  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-... 

Hope that helps

KushShah
Emerging Contributor

Thanks @DougBrowning for the link. 

The problem is that both the fields 'nearest_pipeline' and 'Opername' are calculated (one using search expression) dynamically displayed by using distance intersection. Populating the list values in the choice tab filter the value but it doesn't give desired output, I believe. 

0 Kudos