Choice Filter/Cascading Select Not Fully Functioning

65
3
01-17-2019 09:32 AM
Highlighted
Occasional Contributor

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.

Reply
0 Kudos
3 Replies
Highlighted
Occasional Contributor

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.

Reply
0 Kudos
Highlighted
Frequent Contributor II

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.

Highlighted
Occasional Contributor

Thanks that's good to know as well.

Reply
0 Kudos