Select to view content in your preferred language

Pulldata not auto populating @json results

3074
14
06-20-2022 07:30 AM
JoshOsowiecki
Emerging Contributor

I am creating a follow-up survey for our program and when viewing our data in the Survey123 dashboard it will be helpful to have the county of our program participants.

I have used the string(pulldata("@json",${address})) calculation to populate the extractable features from the geocode source. The properties I would like to extract are "Subregion" (in our case will be used to represent county since the @json does not populate the county) and "City".

When I update the Survey I do not get any error messages, the fields of Subregion and City that I want to auto populate do not auto populate they are left blank. The calculation I am using to auto populate is below:
pulldata("@json",${address_json},"Subregion")

I have tried many different variants of the calculation and am still unable to get the field to auto populate.

I have attached photos of the rows in my sheet I am having trouble with as well as the json pulldata results.

 

0 Kudos
14 Replies
jeffhyderBRVA
Emerging Contributor

I appreciate your assistance but for some reason this still will not work.

pulldata("@json", ${weather_json}, "[0].macAddress.lastData.tempf")

0 Kudos
jeffhyderBRVA
Emerging Contributor
0 Kudos
jeffhyderBRVA
Emerging Contributor

After months of beating my head against the wall, I finally got it figured out.

pulldata("@json", ${weather_json}, "[0].lastData.tempf")

 

This is what worked.

 

0 Kudos
jeffhyderBRVA
Emerging Contributor

@ChrisLeSueur @IsmaelChivite @JamesTedrick 

Ok, after thinking I had this figured out. I get hit in the head, again. Everything works correctly in the test environment of Survey123 Connect meaning all my pulldata calculations populate. Everything publishes correctly. But when a survey is submitted it doesn't have any of the data from the pulldata fields there is also no data being populated in my excel file for the survey. What is the problem? What can I do to fix this? Please, I beg of you and for the love of all humanity please help me.

0 Kudos
jeffhyderBRVA
Emerging Contributor

@ChrisLeSueur @IsmaelChivite @JamesTedrick 

The pulldata function works and populates my fields if the survey is completed with the app but doesn't populate the fields if the survey was submitted using a browser. This is a public survey and participation will greatly decline if the end use has to install an application.

0 Kudos