Select to view content in your preferred language

Search Autocomplete not pulling options for dropdown list

1208
11
Jump to solution
06-09-2025 11:08 AM
IrelandHackman
Emerging Contributor

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_36ad485d68264fdf942d8cfcd...', "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.

0 Kudos
1 Solution

Accepted Solutions
Neal_t_k
Frequent Contributor

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

NealKittelson_0-1749496771220.png

"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?

NealKittelson_1-1749496801914.png

 

View solution in original post

11 Replies
Neal_t_k
Frequent Contributor

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.

0 Kudos
IrelandHackman
Emerging Contributor

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

0 Kudos
Neal_t_k
Frequent Contributor

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

0 Kudos
IrelandHackman
Emerging Contributor

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.

0 Kudos
IrelandHackman
Emerging Contributor

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.

0 Kudos
IrelandHackman
Emerging Contributor

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

0 Kudos
Neal_t_k
Frequent Contributor

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

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

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

0 Kudos
IrelandHackman
Emerging Contributor

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

0 Kudos
Neal_t_k
Frequent Contributor

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

NealKittelson_0-1749496771220.png

"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?

NealKittelson_1-1749496801914.png