I am trying to pull a list of Case IDs into a dropdown menu using Survey123 Connect.
I've inserted the following info in the appearance column of a "select_one list_caseID" row:
autocomplete search('list_case_id?url=https://services8.arcgis.com/euhkr1dAJeQBIjV0/arcgis/rest/services/service_fb0410d92ff74e75981d175d7...')
The dropdown field is blank and even when I type in the field, no results populate.
Can someone help me with this?
Solved! Go to Solution.
Hi Nicholas, thanks for providing your XLSForm.
Currently the name and label for the list_caseID choice list are caseID and Case ID, respectively. Could you please try making the name and label for the list_caseID choice list the same value, i.e. caseID (assuming this matches the field name in the feature layer exactly)?
Hope this helps. Best, Jim
Hi Nicholas, thanks for providing your XLSForm.
Currently the name and label for the list_caseID choice list are caseID and Case ID, respectively. Could you please try making the name and label for the list_caseID choice list the same value, i.e. caseID (assuming this matches the field name in the feature layer exactly)?
Hope this helps. Best, Jim
Thank you @Jim-Moore. I changed all my names and labels to "caseID" instead of "list_caseID" and this seems to have fixed the issue.
Thank you again!
@Jim-Moore
One more question. Is it possible to do a choice_filter when pulling an external list like this as well? I want to filter the caseID options that show up for specific radioBrands selected in this XLSForm?
Hi @RutledgeNicholas glad to hear you got it working.
Regarding filtering the choices - instead of using choice_filter, you can use the optional search/filter parameters in the search() expression itself, as described here:
Dynamic Choice Lists using Search Appearance - Esri Community
I am having an issue populating my survey xls form with the autocomplete search option, excel is not connecting the search function with the choices entry and offering validation rule violations. My problem is actually much bigger though so here it is in a nutshell:
I want users to enter a taxlot number from the autocomplete search function described herein; pulldata("@layer","getRecordAt"...) to retrieve said taxlot; and finally intersect said taxlot with various other layers (individually defined) to pulldata("@layer","getValueAt",...) and I keep breaking the parser with the attached xls form : (
I am working with Survey123 Connect v3.20.63, public REST services, and one hosted service also publicly shared. Many thanks in advance for any help on this.