topic Re: Pull data attribute values and compare with input in ArcGIS Survey123 Questions

Pull data attribute values and compare with input

KennethLindhardt1 — Thu, 25 Jul 2024 09:25:01 GMT

Hi, I have the most of my pull data to work, but what I can't seem to figure out is to search through the table and get the value.

So I need the survey to block for input, if the parcel has already been surveyed, but I'm not storing any parcel geometries in the surveys feature layer.

So my idea was to create an ID field created from the parcel data. I enter a parcel and using pull data to retrieve the ID, that ID is stored in the Surveys feature service.

If a survey is submitter, it will then include the Parcel ID.

If I in a week walk into the same parcel, I will get the same ID from my parcel feature service, but since it's now also stored in the feature of the survey, I can then remind the user to use the inbox and edit, instead of trying adding 2 surveys in the same parcel.

I can't seem to get there though.

Maybe I'm seeing it wrong, maybe there's also another solution or a more standard way of doing this. The goal is to never be able to create a second survey within a parcel, but being forced to edit existing using repeats.

Thanks.

Re: Pull data attribute values and compare with input

tamburo — Mon, 29 Jul 2024 23:07:46 GMT

Yeah that's exactly where I'm coming from in my thinking. Sometimes you desire the flexibility of a class that can be thrown into a bag of classes on a whim and sometimes you desire something more strict that is embedded into the structure of your app. For me, the data attributes allow you to be more structured than a class list, and that's useful https://tutuapp.uno/ .

Re: Pull data attribute values and compare with input

KennethLindhardt1 — Thu, 25 Jul 2024 12:40:09 GMT

Oh, I did a typo, and that's why I couldn't get it to work. Sometimes delete everything and start over 😕

So it is actually working fine, I just needed tot spell the attribute correctly.

pulldata("@layer","getValue","attributes.THE_ATTRIBUTE_FIELDNAME_I_WANT_ASWERED","https://myserviceURL",concat("THE_ATTRIBUTENAME_THAT_SEARCHES_IN_THE_TABLE='",${survey123Question},"'"))

No issue.

Re: Pull data attribute values and compare with input

jfischer91 — Fri, 27 Jun 2025 20:56:10 GMT

Hey @KennethLindhardt1, thanks for sharing this, it's super helpful! I have a follow-up question that hopefully you or maybe @JamesTedrick or @IsmaelChivite could help with.

I'm doing something similar: I want to make sure a user-entered Feature ID doesn't already exist in the layer. So I have this set in a Relevant note field. The problem is that when I'm testing the survey in the browser, the Relevant note is already showing before I type anything, and it won't let me input anything into the text box. It just clears it right away.

I'm wondering if this is because the way the URL is constructed, it thinks an empty Feature ID text box matches the URL when there's no Feature ID specified?

Note calculation:

${Feature_ID} = pulldata("@layer","getValue","attributes.Feature_ID","https://services.arcgis.com/MY_LAYER",concat("Feature_ID='",${Feature_ID},"'"))

If this calculation creates a query where Feature_ID = '', then when the form field is blank, it would calculate to True and show my warning, right?

Did you encounter any similar issues when using this in your survey?