Select to view content in your preferred language

Sorting order of repeat records based on any chosen field

185
4
3 weeks ago
Status: Open
Labels (1)
SĮVilniausplanasISDV
Emerging Contributor

When a Survey123 form containing a repeat is created in Survey123 Connect and later opened in web survey (embedded in Experience builder), the repeat records are currently displayed in seemingly random order - based on OBJECTID.
The functionality that would allow form creators to define the sorting order of repeat records based on any chosen field (e.g., date, name, custom number, etc.), rather than relaying on the default, would be great.

This would enhance the clarity and usability of web-based surveys, particularly in applications where the order of repeated entries is critical for user interpretation or workflow efficiency

4 Comments
Neal_t_k

@SĮVilniausplanasISDV Unless I am misunderstanding, you should be able to already do this.

https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereportqueries.htm

 

BrandonA_CDPH

@Neal_t_k  - That looks like it would work for static (PDF) reports, but not a live view of individual records. I interpreted @SĮVilniausplanasISDV as wanting a "view only" version of the form with the repeat sorted by a custom field.

I use a similar implementation for a form that tracks disaster response follow ups. The form has a "main" portion for a specific license holder's details (read only on the dashboard), then an embedded repeat that is used as a call log. It would be great to sort by a field in the repeat (such as call date/time) so that the form embedded in the dashboard is more user friendly.

Neal_t_k

@BrandonA_CDPH yep, you are right, I read that wrong.  In that case, especially if it is view only, Would bringing the feature in in a different widget, or maybe dashboards  might be a better alternative.  Something where the repeats could be sorted and filtered???

BrandonA_CDPH

That would work as well. I still see the value in having it integrated into Survey123 so that it's a "one stop shop" for field staff so they don't have to pull up a dashboard.