I'm using cascading selects to quickly filter down the choices for a room number/id for a building. Otherwise users will scroll through ~13,000 room ids.
-I can create a regular cascading select where the cascading select_one choices work great. However, I get an error 499/ gateway timeout when publishing because the choice list has over 10k values for the largest list series.
-When I convert it to an external cascading select, I can publish the survey, but the choices that are in the external_choices tab do not show up in the form.
I scoured GeoNet, and found nearly the same question unanswered. See:
External Cascading Select Not Working for an identical problem that is unresolved. (suggest solution: make unique column names that are not the same as list names. I tried that, no resolution)
and external select stopped working works for the questioner and though I tried it, it did not work. (suggested solution: ensure the label::language1 was set to label::English (en) on all forms)
Any ideas of how to solve this?
Update 9/16/2020.
After working with ESRI Support I have the following information:
The Choices sheet has an upper limit of 4837 items per list set. No known upper limit on External Choices.
Since the External Choices is stored as a CSV ensure the following.
-There are no commas anywhere in the Label field (or anywhere else)
-There are no Carriage Return (CR, ASCII code 13) or Line Feed (LF, ASCII code 10) characters in the Label field. Use 'Find and Replace' with 'Shift+J' to search for Carriage Return. Surveys viewed on a browser will work if there are multi-line characters, but Android and iOS devices will not.
-My room ids are numbers as String, Excel will flag them with an error indicating 'numbers stored as text'. You must format them as text by clearing the cell error - Ignore Error or create a helper column with the =Text formula, then copy paste values over your original data. (Then delete your helper column)
-Delete the Itemset.csv in [Show survey in folder]/Media folder. When you publish a new one will be created reflecting all the changes you made on External Choices sheet.
I have gotten my survey working!
