topic Re: orderByFields not working Survey123 Summary Photo Report in ArcGIS Survey123 Questions

orderByFields not working Survey123 Summary Photo Report

Anonymous User — Wed, 28 Apr 2021 19:06:37 GMT

Hi there, I'm trying to produce a summary report showing site photos collected along with some relevant text as a summary report and I'm running into an error with my syntax. I'm getting the error that "my tag"" is unopened", but I'm following the syntax shown in this blog: Survey123 Tricks of the Trade: Summary sections in... - Esri Community and everything appears to match up, so I'm not readily seeing what needs to change here.

I've attached three versions of my report word doc. The one titled _v2 outputs the photos, but not in order by photo ID, the ones titled _v3 and _v4 are just different attempts to achieve the result of the photos being ordered by photo ID ascending. I've also attached a copy of my Survey123 Connect xlsx form. Any thoughts or suggestions on my syntax would be much appreciated.

Thanks!

Re: orderByFields not working Survey123 Summary Photo Report

BarbaraWebster1 — Thu, 23 Sep 2021 17:30:44 GMT

Hi Sarah,
I was able to get Photo_Print_Site_Summary_v4 working with the following changes (see attached):

- Change end tag from ${/} to $</>
- Change $<$Summary> to $<$summary>
- Added a repeat to your summary table for the main layer, so now you can access the questions that are in the main body of the form.

This is an old post, so you may not need this anymore, but I thought I'd pass it along just in case.

Thanks,
-Barbara

Re: orderByFields not working Survey123 Summary Photo Report

Anonymous User — Wed, 29 Sep 2021 14:37:30 GMT

Thank you Barbara! Your changes worked and I went ahead and modified the syntax further to include a sort by site name, as well as photo ID. We will be using this for annual reporting, so I very much appreciate your response/solution.

Re: orderByFields not working Survey123 Summary Photo Report

BarbaraWebster1 — Wed, 29 Sep 2021 16:17:14 GMT

Great, glad you got it working!

Re: orderByFields not working Survey123 Summary Photo Report

KrystaHouseknecht — Tue, 17 Oct 2023 23:19:28 GMT

Hi! I am having a problem getting my report to orderByFields on multiple columns. Your comment above says that you were able to include a sort by site name, as well as photo ID. Can you show me that code? What I'm trying to do is sort by City and then sort by Building_name after that; so all the cities are in order, along with the building names in ASC order. Thanks! -Krysta