topic Re: Search Autocomplete not pulling options for dropdown list in ArcGIS Survey123 Questions

Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 18:55:21 GMT

I've created a form that, in essence, should allow survey takers to either:

A) Create a new contact

B) Pull a name from a pre-existing list (located in a feature service table) in order to update an individual's information.

I don't have any issues with creating a new contact, but for whatever reason, I can't seem to get the dropdown autocomplete search function to populate with any names I know are, for a fact, located within the feature service table.

I have referenced a similar solution posted previously and did my best to follow along with the suggestions located there, but it still does not seem to be working correctly. I think the problem lies within the appearance column for the select_one list_full_name - which is currently as follows: autocomplete search('list_full_name?url=https://services2.arcgis.com/9ITMSQly9V0ER26l/arcgis/rest/services/service_36ad485d68264fdf942d8cfcd0781676_form/FeatureServer', "startswith",${Full_Name})

Any help on trying to solve this issue would be much appreciated.

Edit: I've attached the excel form for the survey to this post, in the hopes that will help.

Re: Search Autocomplete not pulling options for dropdown list

Neal_t_k — Mon, 09 Jun 2025 18:50:34 GMT

What happens if you take the "starswith",${Full_Name} out of the calculation, That might be acting as a match instead of a "startswith" so if they add a middle initial for example it is going to blank everything out. The Autocomplete should act as your filter when they start typing.

Also you mentioned either creating a new contact or using the search to list preexisting names. When they are using the search function are they filling out the ${Full_Name} field? If they aren't filling that field in then the list isn't being populated as there is nothing to match the criteria against.

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 18:48:27 GMT

Thanks for the suggestion -- I just tried it and nope, it does the same thing. No options in the drop-down.

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 18:50:53 GMT

Here's the excel form I'm using for the form. Maybe this'll be able to provide a bit more context.

Re: Search Autocomplete not pulling options for dropdown list

Neal_t_k — Mon, 09 Jun 2025 18:52:23 GMT

If you haven't try again but close out of Connect completely, S123 sometimes caches the layer.

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 18:53:35 GMT

I tried again, closed out of Connect completely, and still nothing. I even tried publishing it again, in the odd chance that would do something. Still nothing.

Re: Search Autocomplete not pulling options for dropdown list

Neal_t_k — Mon, 09 Jun 2025 19:04:43 GMT

autocomplete search('list_full_name?url=https://services2.arcgis.com/9ITMSQly9V0ER26l/arcgis/rest/services/service_36ad485d68264fdf942d8cfcd0781676_form/FeatureServer/X')

because it redacts the url"...FeatureServer/x"

You need the number of the layer in the the url.

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 19:06:39 GMT

Nope, still not working -- I even tried closing out of the program completely again, as previously suggested.

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 19:15:24 GMT

I just now saw the second part of this comment. When the survey-takers are using the search function, they'll be operating on the assumption that the individual they're looking for is already in the system, so the ${Full_Name} field will have values in it.

If they search for an individual and they don't show up, then they'd choose to create a new contact instead. That being said, the test data I entered does have those fields with values entered, so it should be working as intended.

Re: Search Autocomplete not pulling options for dropdown list

Neal_t_k — Mon, 09 Jun 2025 19:23:54 GMT

If the below doesn't work, did you check the permissions of the rest api on the feature layer?

"Query" would have to be in there and available to the group that is using it for it to work. Maybe something with your sharing settings?

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 19:26:25 GMT

That's probably where the problem lies. I'll take a look tomorrow and comment again if that doesn't work.

Thanks so much in the meantime, Neal. I really appreciate all your help!

Re: Search Autocomplete not pulling options for dropdown list

IrelandHackman — Mon, 09 Jun 2025 20:03:30 GMT

Thank you so much, Neal. That was exactly what I (as well as my friends) needed to get this feature to work.

I appreciate you taking time out of your day to help us out.