Pulldata("@layer") based on Dynamic List Input

DougKlimbal — Fri, 27 Dec 2024 17:39:39 GMT

Background: I'm creating a survey form using Connect. One of the questions relies on a pulldata calculation referencing a separate feature service. Respondents are instructed to first create a polygon feature in one survey, then find it by name in the survey I'm working on now.

I've successfully created a dynamic list that accomplishes that using appearance
autocomplete search('Plowshed_Name?url=https://services2.arcgis.com/ZkOsbg84o8DsPPaP/arcgis/rest/services/service_846a043cc192441a9015bca8087c516b/FeatureServer/0')
I've successfully hardcoded one of those names to return a JSON to text field, then retrieved a separate parameter from that JSON:
pulldata("@layer","getRecord","https://services2.arcgis.com/ZkOsbg84o8DsPPaP/ArcGIS/rest/services/service_846a043cc192441a9015bca8087c516b/FeatureServer/0","Plowshed_Name='110 Fourth Street South'")

Problem: I can't get what I need using the dynamic list input, either the JSON using getRecord or the field value using getValue. Since I had success hardcoding the above and I'm hoping to query it for other attribute values, I'm mostly focused on using getRecord. I have the ${Plowshed_Name} as dynamic input using the appearance written above, which I pass through a text calculation ${Plowshed_name_string} made by concat('"Plowshed_Name=',"'",${Plowshed_Name},"'",'"'). The output exactly matches the value hardcoded to query the JSON in second bullet, single quotes, double quotes, and all.

The question using the dynamic input has blank value no matter what selection I make from the dropdown list. The calculation in question reads:

pulldata("@layer","getRecord","https://services2.arcgis.com/ZkOsbg84o8DsPPaP/ArcGIS/rest/services/service_846a043cc192441a9015bca8087c516b/FeatureServer/0",${Plowshed_name_string})

I've spent two days searching forums, referencing help articles, and interrogating copilot. I've tried adding custom JS scripts. What gives?

Re: Pulldata("@layer") based on Dynamic List Input

DougBrowning — Mon, 30 Dec 2024 14:26:35 GMT

My guess is that the pulldata is firing before the selection is made, which would make sense. Try adding a relevant to the pulldata field of something like ${selection} != '' or string-length > 0. That way it does not run the pulldata lookup until it has a value from the selection.

topic Re: Pulldata("@layer") based on Dynamic List Input in ArcGIS Survey123 Questions

Pulldata("@layer") based on Dynamic List Input

Re: Pulldata("@layer") based on Dynamic List Input