select_one_external choices not available (Survey123 Connect)

3966
5
Jump to solution
11-30-2018 11:29 AM
ByronTsang1
New Contributor II

I have a long picklist of plant species (approx 3500 options to select from) that I have to choose from several dozen times in an ecology survey form. The selection from this question in turn pulls data from another external .csv file to feed various attributes to other calculate fields.

When I include this full list in the standard "Choices" worksheet and use the select_one field type, the survey takes AGES to load. To avoid this problem, I have made use of the select_one_external field type and added the required external_choices worksheet. It's worth noting, I forced the choice_filter field by setting my entire list to a constant, since I don't have any applicable cascading select field that would help me thin the list out. This has dramatically reduced the load time for the survey but now the autocomplete pulldown doesn't work! The field shows up in the survey preview but I cannot select it or choose any options.

Anybody have any suggestions??

0 Kudos
1 Solution

Accepted Solutions
JamesTedrick
Esri Esteemed Contributor

Hi Byron,

There are a couple of issues with the approach for external selects you implemented.  The choice_filter statement must include a reference to another question.  Additionally, using numbers in external selects can create a problem as they are stored as text (i.e., the 1 in the show column will be '1.0' in the CSV file).  The attached file addresses these issues (note the 'plantinit' question on line 78).

That being said, the performance issues of your survey will still be present, as you are loading your ~3500 item choice list 32 times in the form.  In looking through the form, you have a lot of sequential questions (i.e., 'Tree 1', 'Tree 2', 'Tree 3', etc.) You can improve the performance by using repeats for the situations where you are asking the same question(s) multiple times.  

View solution in original post

5 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Byron,

There are a couple of issues with the approach for external selects you implemented.  The choice_filter statement must include a reference to another question.  Additionally, using numbers in external selects can create a problem as they are stored as text (i.e., the 1 in the show column will be '1.0' in the CSV file).  The attached file addresses these issues (note the 'plantinit' question on line 78).

That being said, the performance issues of your survey will still be present, as you are loading your ~3500 item choice list 32 times in the form.  In looking through the form, you have a lot of sequential questions (i.e., 'Tree 1', 'Tree 2', 'Tree 3', etc.) You can improve the performance by using repeats for the situations where you are asking the same question(s) multiple times.  

PatriciaAlgura
New Contributor III

Hi James,

I'm having this same issue, so i tried testing the xlsx form you attached but the external choices were not working.

0 Kudos
JamesTedrick
Esri Esteemed Contributor

Hi Patricia,

Which version of Survey123 are you using?  We identified an issue with autocomplete very late in the 3.2 development process that we have addressed for the 3.2 release.

0 Kudos
RandyDeodat1
New Contributor

Hi James,

I'm having this same problem. I've attached my itemset.csv and .xls form with what you have outlined, but it's still greyed out for me. Any suggestions?

Thanks,

Randy

0 Kudos
LuisMartinez3
New Contributor II

Are there any known issues using a choice list to populate a geopoint question from a select_one_external on Portal?

It seems to work fine when in the choice list but I have 25K addresses to pull in, was thinking it was stored as a text string in the items.csv file, therefore, causing issues.

list_name namelabelparish
address+029.9329_-90.3637103 1ST ST LULING LASCP
address+029.9328_-90.3636105 1ST ST LULING LASCP
address+029.9338_-90.3640105 1ST ST LULING LASCP
address+029.9338_-90.3639107 1ST ST LULING LASCP
0 Kudos