Select to view content in your preferred language

Can't figure out why the search or pull isn't working to bring in feature layer data for another survey choice column

129
1
3 weeks ago
Mobius_devil1
New Contributor

I have a very simple survey that needs to pull another survey's data as a choice picklist for users to select from. I can't get the feature layer data to pass through and show up on the new survey as a choice picklist. Any suggestions would be appreciated.

in my appearance column, I have this 

pulldata("@layer", "https://services6.arcgis.com/N6rP5o1W5BrPYgsm/arcgis/rest/services/survey123_9e24d36efd414b7f8c55c10...", "Event")

 

and this 

autocomplete search('Signup?url=https://services6.arcgis.com/N6rP5o1W5BrPYgsm/arcgis/rest/services/survey123_9e24d36efd414b7f8c55c10...', 'Event')

 

And I do not have any data showing up, even though there are only 6 total data points from the feature layer.

0 Kudos
1 Reply
Neal_t_k
Frequent Contributor

To start with,  the pulldata(@layer) should go in as a calculation, and it is not properly formatted

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985...

you need to tell it what kind of query eg. "getRecord" and a where clause eg. "Event = ${Event}"

 

Same with the search appearance,  you need to properly format the criteria

Neal_t_k_0-1758200587514.png

something like

autocomplete search('Signup?url=https://services6.arcgis.com/N6rP5o1W5BrPYgsm/arcgis/rest/services/survey123_9e24d36efd414b7f8c55c10...','matches', 'Event', ${Event})

https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/ba-...

Fix those up, and if your queries still doesn't work post back, syntax can be tricky.