topic Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating in ArcGIS Survey123 Questions

Using an external choice list with a choice filter in the web form on a select multiple - list not populating

MeganEngel — Thu, 15 Aug 2024 17:53:48 GMT

I'm having trouble with a Survey123 web form where a "select_multiple" question uses an external choice list and a choice filter. The list isn't appearing in the web form, though it works fine in Survey123 Connect.

What I've Tried:

XLSForm Check: All references and filter logic seem correct.
Browser Testing: The issue persists across different browsers
Mobile App: Works as expected
Connect Test: The list appears without issues in Survey123 Connect.

Questions:

Is there a known issue with this setup in web forms?
Any workarounds or solutions to make the list appear correctly?

Thanks for any advice!

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

abureaux — Thu, 15 Aug 2024 18:46:14 GMT

No limitations. There may be wrong with the CSV. Any chance you can share it here?

Here is an external select_multiple I did as a test. This CSV as ~1300 choices and it displays fine in web.

(name list, so names censored. I know this isn't a lot to go off of, but trust me when I say it's a working External Select in web!)

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

JenniferAcunto — Wed, 21 Aug 2024 12:50:40 GMT

The browser is less forgiving than Connect and the Field App, so if it is working in Connect and not the browser you likely have a slight syntax error somewhere.

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

JacobCabral — Mon, 26 Aug 2024 13:52:49 GMT

Hello!

The survey and associated external lists are attached below. Any feedback would be greatly appreciated!

Thank you

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

abureaux — Mon, 26 Aug 2024 14:25:52 GMT

Still publishing.

But before it even finishes, I will say the issue is with the CSVs. Your column names are incorrect. Your first two need to be "name" and "label", just like the "choices" tab in the XLSX

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

abureaux — Mon, 26 Aug 2024 14:43:17 GMT

Went through the files. Found these couple items:

Don't use "reserved" names. It causes a bunch of issues which can become especially prevalent once published.
External Choice Lists need to have the "name" and "label" column to work properly (same idea as the "choices" tab of the XLSX).

Missing fieldinfo.csv, which I believe is the main drop-down you were having issues with. Also missing producerinfo.csv, which is used to filter fieldinfo later on (I just removed that filter). I used a copy of idnumbers_media(1).csv for now. I also cleared the relevant column just to make testing easier. The list worked as expected (obviously the wrong list due to limitations above):

I would check the format of the CSVs, and replace that reserved name within the XLSX. Give it another try after that and hopefully it works.

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

JacobCabral — Mon, 26 Aug 2024 14:46:21 GMT

Hello Abreux,

Fantastic, thank you for the suggestions! I'm going to try these immediately.

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

JacobCabral — Mon, 26 Aug 2024 14:52:03 GMT

Also my apologies, I changed the names of the CSVs from the originals and forgot the Survey XLSX called the wrong names. My fault on that.

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

abureaux — Mon, 26 Aug 2024 14:55:28 GMT

No worries! Hopefully the column names is all that's really wrong.

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

JacobCabral — Mon, 26 Aug 2024 16:48:12 GMT

Made all the edits you suggested plus changes to the linked content and everything seems to work. Thank you again!

Re: Using an external choice list with a choice filter in the web form on a select multiple - list not populating

abureaux — Mon, 26 Aug 2024 16:53:15 GMT

Fantastic news!