topic Re: select_multiple_from_file External choices in ArcGIS Survey123 Questions

select_multiple_from_file External choices

YuliaMamonova — Tue, 08 Jun 2021 12:28:10 GMT

Hello,

I have a form where I have select_one_from_file question, which is pulling choices from external CSV - It's been published and works fine. I am trying to change this question from select_one_from file to select_multiple_from_file and after saving the form XLSX the survey is converted with no errors, but then it shows it's optimizing and never finished, just keeps spinning.

Any thoughts?

Thank you,

Yulia

Re: select_multiple_from_file External choices

DougBrowning — Mon, 14 Jun 2021 17:16:23 GMT

Do you have spaces or special chars in the list? Select multiple are much more picky about that. Just a guess

Re: select_multiple_from_file External choices

YuliaMamonova — Mon, 21 Jun 2021 22:23:07 GMT

No, I don't.

Re: select_multiple_from_file External choices

DougBrowning — Mon, 21 Jun 2021 22:46:09 GMT

Can you post up the form?

Re: select_multiple_from_file External choices

YuliaMamonova — Mon, 21 Jun 2021 22:55:15 GMT

The only thing in my opinion that can contribute to this error is that my external list is over 60,000 values

Re: select_multiple_from_file External choices

DougBrowning — Mon, 21 Jun 2021 23:08:44 GMT

How would the user be able to make sense of that? It would be pretty much impossible to use.

Re: select_multiple_from_file External choices

YuliaMamonova — Mon, 21 Jun 2021 23:14:24 GMT

Autocomplete appearance is the way to go with large choice lists. Moreover, in 99% of cases in our form the value is picked automatically from the barcode scanner question.

Re: select_multiple_from_file External choices

YuliaMamonova — Mon, 21 Jun 2021 23:35:44 GMT

My choice list looks like this:

Up to 60,000.

It works just fine with select_one_from_file choice question.

Re: select_multiple_from_file External choices

YuliaMamonova — Mon, 21 Jun 2021 23:40:15 GMT

Hi @IsmaelChivite @JamesTedrick ,

Could you please help? External choice list only works with select_one_from_file question, but when I change the question to select_multiple_from_file question, the form starts spinning and then is being optimized endlessly. The choice list is over 60,000 values.

I appreciate your help!

Re: select_multiple_from_file External choices

DougBrowning — Mon, 21 Jun 2021 23:59:26 GMT

Yea but I just tested and autocomplete is not working on select multiple for me. And Ismael said is this post that it for sure does not. https://community.esri.com/t5/arcgis-survey123-questions/auto-complete-function-for-multi-select-questions/td-p/1032485

So the UI is prob trying to draw all those text boxes.

Re: select_multiple_from_file External choices

YuliaMamonova — Tue, 22 Jun 2021 00:03:57 GMT

Hmm I didn't think about it, makes sense then. Thank you!