topic Re: Choice Filter/Cascading Select Not Fully Functioning in ArcGIS Survey123 Questions

Choice Filter/Cascading Select Not Fully Functioning

AndrewSouthern — Thu, 17 Jan 2019 17:32:12 GMT

I have something strange going on. I have a choice filter set up and only a partial amount of the external choices are coming through. The external choice sheet is large, over 46,000 rows, but I'm not convinced that's the issue. Specifically what I'm seeing is that only some external choices are coming through but not others. Some "groupings" of answers are not coming through at all, others come through as expected. A real mixed bag so it has been difficult to pinpoint the issue.

I have attached a couple screen shots as well as the XLS form if anyone wants to try to help me navigate this issue.

Thanks.

Re: Choice Filter/Cascading Select Not Fully Functioning

AndrewSouthern — Thu, 17 Jan 2019 19:25:57 GMT

I believe I figured it out. There were commas in some choices and the CSV created (itemsets) does not jive well with Survey123 if there are commas involved.

Re: Choice Filter/Cascading Select Not Fully Functioning

DougBrowning — Wed, 30 Jan 2019 14:36:27 GMT

I was just going to write that it may be commas. Happened to me. Note it seems to be commas anywhere in external choices - even columns you do not use.

Also had issues if there are any " or ' in there.

You get really weird lists and data stored so it can be hard to figure out.

Re: Choice Filter/Cascading Select Not Fully Functioning

AndrewSouthern — Wed, 30 Jan 2019 14:56:31 GMT

Thanks that's good to know as well.