Preparing report using information from survey and other data sources

[dsinha]

Hello,

I was wondering if it is possible to include fields from two/more different data sources - the survey, and an independent table/spatial layer - in the report template.

In my case, the survey contains observations related to a property and I would like to include the property owner's contact details (often absentee) stored in an independent table in the report that is being generated from the survey.

Thanks for your help!

[ZhifangWang]

Hi @dsinha ,

Could you share more details on how a property links to the property owner’s record in the other layer—for example, via a shared property ID? Would something equivalent to the pulldata("@layer") function in XLSForm meet your workflow needs?

[dsinha]

Hi @ZhifangWang, yes the two data sources have the same property ID which can be used to connect them.

I am not sure if the pulldata function would work in this case as the data collection is being done through Field Maps. I am using Survey123 to only generate the report (using the spatial layer from the Field Maps).

It is possible to modify the ****_results layer in Survey123 without modifying the source spatial data layer? Then I can add the pulldata function in the ****_results layer without modifying the source layer.

Thanks for your help!

[dsinha]

I think it would be simpler if I just autoppopulate these fields in Field Maps itself using the FeatureSetByName function. I will try that.

[ZhifangWang]

Hi @dsinha ,

Thanks for sharing the information. The pulldata layer expression I mentioned previously is used to query a field value from another layer in Survey123 when filling the form, which should match your workflow. I think you should be able to achieve the same using Arcade in Field Maps. Submitting the value into the spatial layer could be a workaround to help you generate the report.

I've also logged an issue in our dev repo to support such workflow in the Survey123 feature report capability. Please feel free to submit an enhancement ticket to Esri Support if you’d like to help us prioritize this work.