I have a survey that is used to perform inspections on outfall structures. The setup is a one to many relationship, with one outfall for numerous inspection. I am hoping to use the Survey123 reporting tool, but need to figure out if it's possible to pull information from the parent/origin data (the outfall) to the inspection report.
I attempted to do this following the information in the 'repeats' section of this page https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereporttemplates.htm however this outputs data from ALL of the outfalls, not just the one the inspection pertains to. I figured something like this might work but haven't had luck
${#Outfall} ${if (${ID} == ${Inspection.OutfallID}}) ${LocDesc} ${/} ${/Outfall}