topic Re: Sorting Fields in a repeat Report Template in ArcGIS Survey123 Questions

Sorting Fields in a repeat Report Template

DeborahDennison — Wed, 05 Jun 2024 22:35:40 GMT

Hello S123 team mates, I can use some guidance on how to sort fields within a Repeat Section in a Report Template (Word Document).

Is it possible to use the 'orderByFields' in a repeat section?

Here is the syntax that does not work for sorting:

${#repeat_tree_survey | orderByFields:"tree_tag_id ASC"}

Survey Site: South Watershed Monitoring

Tree Tag ID: ${tree_tag_id}

Survey Date: ${Tree_Survey.survey_date}

Tree Species: ${tree_species}

${/}

Your thoughts and tips are greatly appreciated!

Debbie

abureaux — Thu, 06 Jun 2024 16:02:23 GMT

You can use sorting in the Feature Report just fine for a repeat. See Report templates

${#defects | orderByFields:"state_name ASC, pop2000 DESC"}...${/}

EDIT: forgot to mention, but please ensure that your field (tree_tag_id) is a number and not a number stored as text.

TrafficOpsGIS — Fri, 16 Aug 2024 20:54:18 GMT

Please see screen shot of how to format table in word doc in order to accomplish.