select_multiple_from_file External choices

[YuliaMamonova]

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

[DougBrowning]

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

[YuliaMamonova]

No, I don't.

[DougBrowning]

Can you post up the form?

[YuliaMamonova]

My choice list looks like this:

Up to 60,000.

It works just fine with select_one_from_file choice question.

[YuliaMamonova]

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

[DougBrowning]

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

[YuliaMamonova]

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.

[DougBrowning · Accepted solution]

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-que...

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

[YuliaMamonova]

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