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 Report Template - add related tables

AsafEvenPaz

Hi,

Is it possible to add fields from a related table in a report template?

Trouver plus de publications taguées avec

Accepted answers

KimberlyMcCallum

Hi! I am by no means a Survey123 expert but I was able to accomplish this in my feature report template following the docs here: https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereporttemplates.htm

In my case, I had user input data from a repeat question representing multiple watersheds related to a single point feature. In my feature report template Word document, I created a table like so:

HUC

Name

Total Acres

Acres Burned

Percent Burned

${#WatershedFire}

${HUC}

${ Name}

${TotalAcres}

${AcresBurned}

=${PctBurned}

${/WatershedFire}

In this example, my related table is called WatershedFire and the fields (HUC, Name, TotalAcres, etc.). Note the syntax for opening and closing. When I generate a feature report, all the related records are added automagically and I get a table with multiple watersheds.

I hope this helps!

All comments

KimberlyMcCallum

In my case, I had user input data from a repeat question representing multiple watersheds related to a single point feature. In my feature report template Word document, I created a table like so:

HUC

Name

Total Acres

Acres Burned

Percent Burned

${#WatershedFire}

${HUC}

${ Name}

${TotalAcres}

${AcresBurned}

=${PctBurned}

${/WatershedFire}

I hope this helps!

AsafEvenPaz

Thanks. I actually found the documentation which mentions this option 🙂

GrantHoward1

Hi Kimberly,
I have a related question. Is it possible to include ONLY ONE entry/record from the related table (our inspections) in the report. Ideally the latest entry. For property inspection reports we don't want the report to show the details of ALL the inspections ever completed, just the most recent and valid one.
Thanks,
Grant

Dschect

I imagine you could accomplish this by using ${#YourRelatedTable | orderByFields:"DateField" | resultRecordCount:1} ... ${/}

Dschect

I found THIS video really helpful, skip to 30:30

Luiz_RobertoArueira_da_Silva

Good morning.
Is it possible to use this solution for related tables that are not part of a Survey repeat?

thanks.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.