topic Hide Select One from CSV in ArcGIS Survey123 Questions

Hide Select One from CSV

DarrylKlassen1 — Fri, 16 Feb 2024 19:55:23 GMT

Hello, I have a series of Select One questions - each relying on the previous question for its options using the "Choice_Filter" column. This works great, except for when there is no entry in my CSV for a the answer to the previous question. For instance:

When someone selects in Question 1 "Toronto" - I would like Question 2 to remain hidden, as there is no "City" = Toronto in Question 2.

Is this possible?

Thanks

Darryl

Re: Hide Select One from CSV

abureaux — Fri, 16 Feb 2024 21:21:22 GMT

Well, there's the obvious relevant: not(selected(${my_question},'Toronto'))

But I assume you are looking for a more programmatic method? I'd put the selections into an external CSV so there were additional columns. Then, I'd make a column in said CSV for items that have "additional data". Then, I'd tie the relevant column to that. You'd just have to keep on top of updating that "additional data" column.

EDIT. Did this super quick and it works:

Re: Hide Select One from CSV

DarrylKlassen1 — Fri, 16 Feb 2024 21:59:09 GMT

Thanks @abureaux I tried your example and it worked for me as well. now I just have to figure out how to get it working with my data. ha ha! Thanks again!