nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

search() and pulldata() from feature service returning empty list and attributes

MollyMoore

I am setting up a survey to use the search() function to query a feature service layer to auto-populate values in a drop down for users to select. I then want other fields to auto-fill attributes in the Survey123 from the feature service layer with the pulldata() calculation. When I set up these functions, the list is empty and the pulldata() function (when tried separately) is also empty. The feature layer is in a referenced feature service hosted on our enterprise portal and the Survey123 form is being built in the same same portal. What am I doing wrong?

My search() expression in the appearance option:

w2 autocomplete search("site_name_picker?url= https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0")

My pulldata() expression in the calculate option:

pulldata("@layer", "getValue", "attributes.nha_join_id", "https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0",concat("site_name='", ${site_name}, "'"))

I've attached photos that show the .xlsx file and the blank drop down list.

Encuentra más publicaciones etiquetadas con

Accepted answers

JA7

Pulldata does not like being included with other functions (concat, if, etc). You might want to try breaking up your pulldata into separate calculations:

1st question builds the where clause.

concat("site_name= '", ${site_name}, "'")

2nd question is the pulldata calculation.

pulldata("@layer", "getRecord", "https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0", ${where1}).

Along with what Jim mentioned, I would also check to ensure that query is enabled on the layer you are using with the search appearance.

Pull Data.xlsx

All comments

Jim Moore

Hi @MollyMoore

The syntax in your expressions looks good. A couple of things to check:

Is "site_name" the exact name of the field in the feature layer with which you want to populate the choice list?
Does the signed in user have access to the feature layer?

Best, Jim

JA7

Pulldata does not like being included with other functions (concat, if, etc). You might want to try breaking up your pulldata into separate calculations:

1st question builds the where clause.

concat("site_name= '", ${site_name}, "'")

2nd question is the pulldata calculation.

pulldata("@layer", "getRecord", "https://<enterprise_url>/server/rest/services/PNHP/NHA_EDIT/FeatureServer/0", ${where1}).

Along with what Jim mentioned, I would also check to ensure that query is enabled on the layer you are using with the search appearance.

Pull Data.xlsx

Chris3030

Hi @MollyMoore , does this happen in the desktop app or the web form version of the survey? I'm experiencing a similar problem right now

MollyMoore

Mysteriously, everything started working after rebooting two days later without changes. I updated to separate the concat() function from the pulldata() function anyway, as you suggested @JenniferAcunto, and everything seems to be functioning well. Thank you for the tip and hopefully it will make things more stable.

MollyMoore

Hi @Chris3030, I am using the desktop app and creating in Survey123 Connect. After two days, my functions mysteriously started working without changes. I did update my .xlsx to separate the functions as @JenniferAcunto suggested and things seem to be working well now.

TKSHEP

How would I use the pulldata calculation to search a feature layer for the same field name and update a different column in the feature layer when survey is submitted?

Example:

both features are in the same map and have the same column name site. When survey is submitted update site locations feature column inspection completed to yes with the matching site from the survey that was submitted.

Thank you for your help!

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.