Select to view content in your preferred language

how to retrieve a value from a repeat table to another survey

443
1
11-18-2024 04:22 AM
Labels (1)
agroges362
Emerging Contributor

Hello!

I’m using a survey with a repeat group where users select a crop and then enter several values, such as the cultivated area. The user fills out the repeat group for as many crops as they have.

In a second survey, I’m collecting production data, and I would like to pull the area data for each crop to calculate the yield.

 

How can I do this? 

I've tried the following formula: 

pulldata("@layer","getValue","attributes._02122_area_perma_crop","https://services-eu1.arcgis.com/.../FeatureServer/2",concat("_0_farm_identification='",${_0_farm_identification},"'"))

 

The record ID that each user uses to identify their entries is the farm name, which is common across both surveys.

 

 

 

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

Is this showing a field name that starts with underscore?  ${_0_farm_identification}  If so I have seen that break forms.