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 Layer Help

SaadShahzad

Hi all,

I'm trying to create a note in my survey that queries previous submission records in the feature layer to notify the survey-taker of an existing inspection record within the last 24 hours, I am trying to use this pulldata function in the calculate field to achieve it, but it does not seem to work, and permanently shows "Forklift has no inspections in the last 24 hours" - despite an existing inspection within the last 24 hours.

forklift_number is an integer field in my survey that holds the unique ID of the forklift

inspection_date is a dateTime field in my survey that holds the inspection date and time for a forklift

if(
  pulldata("@layer", "https://gis.blank.com/server/rest/services/Hosted/service_0d41872c64f34120b9881d67843aaes2/FeatureServer/0", "count", "forklift_number = '${forklift_number}' AND inspection_date >= timestamp(now() - 86400000)") > 0,
  "Forklift was last inspected in the last 24 hours.",
  "Forklift has no inspections in the last 24 hours."
)

Any help troubleshooting will be greatly appreciated.

Find more posts tagged with

Accepted answers

dougbrowning

In the samples I do not see it using the word where? It is a comma then the query.

pulldata("@layer", "getValue", "attributes.NAME", "https://services5.arcgis.com/jMCHJcLe13FaKCFB/arcgis/rest/services/US_Counties/FeatureServer/1?orderByFields=POPULATION DESC&resultOffset=9", "STATE_NAME = 'California'")

All comments

SaadShahzad

Hi Doug,

Thanks for your help so far. I changed some stuff up and took another approach utilizing some of the information I found on the forum and docs.

What I'm trying to achieve now (before I attempt adding a "last 24 hours" clause) is to query the count of Forklift Inspections associated with a Forklift Number in my survey (which is an integer field). This pulldata request seems to be returning the entire count of the records in my layer, so it doesn't seem like my 'where' clause is working correctly. Any tips?

pulldata("@layer", "getValue", "attributes.forkliftInspections",  concat("https://gis.blank.com/server/rest/services/Hosted/service_0b41872c64f34120b9884d67848aaef2/FeatureServer/0", '?outStatistics=[{"statisticType": "count","onStatisticField": "forklift_number","outStatisticFieldName": "forkliftInspections"}]', "&where=forklift_number=", ${forklift_number}, "&t=",now()))

Thanks.

dougbrowning

Looks like you are missing the getValue part?

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

SaadShahzad

Hmm, okay so I separated it and I broke it down to get to the bottom of the issue, but still can't seem to even get this simplified pulldata (without the check for date and time) to work:

pulldata("@layer", "https://gis.blank.com/server/rest/services/Hosted/service_0d41822d64f34120b9884d67848aaef2/FeatureServer/0", "count", "forklift_number = '${forklift_number}' " )

Something tells me I don't know how to use the "count" clause properly. I don't get any errors, but I don't get any values returned either. Shouldn't it return an integer value back with the number of records that exist with the forklift number I plugged into the survey?

Example: I have two records in the feature layer with the Forklift Number: "123" associated to them, shouldn't the pulldata request return a count of 2?

dougbrowning

Common issue that pulldata does not work inside an if statement. Break it out to its own field then run the if on that field.

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.