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; } } }

Survey123 pulldata from attribute table not working

rpeters17

I have a field titled "user_id", which is manually entered by the user. If there is a match I would like to use this entry to pull attribute data from a hosted table (see rest endpoint below) to auto populate the second field with the data in the "name_first" field on my survey. My current code does not return anything. Please advise:

pulldata("@layer","getValue","attributes.name_first","https://services3.arcgis.com/kTHh5mF5pghzqQ3m/arcgis/rest/services/verified_users/FeatureServer/0",concat("user_id =",${user_id},"'"))

*this data is not sensitive

Form 1.xlsx

Find more posts tagged with

Accepted answers

rwrenner_esri

Hi Rosco,

The first concat value is missing a single quotation mark (bolded):

pulldata("@layer","getValue","attributes.name_first","https://services3.arcgis.com/kTHh5mF5pghzqQ3m/arcgis/rest/services/verified_users/FeatureServer/0",concat("user_id ='",${user_id},"'"))

-Rylee

All comments

rpeters17

The calculations column does not have the "Form_1" but it shows up in the error. The survey is titled Form 1

rwrenner_esri

In the error message, I see "/Form_1/" in the latter part of the concat statement. Does that match what's in the XLSForm calculation column? I didn't see that text included your initial pulldata so wondering if it got added and if that's causing the syntax error.

rpeters17

Thank you Rylee. I'm getting syntax error with the added added single quotation mark. I'm very much in the learning phase with connect, so this is much appreciated.

rwrenner_esri

Hi Rosco,

The first concat value is missing a single quotation mark (bolded):

pulldata("@layer","getValue","attributes.name_first","https://services3.arcgis.com/kTHh5mF5pghzqQ3m/arcgis/rest/services/verified_users/FeatureServer/0",concat("user_id ='",${user_id},"'"))

-Rylee

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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