topic Re: Issue with Instance_name Dates not sorting in Inbox in ArcGIS Survey123 Questions

Issue with Instance_name Dates not sorting in Inbox

neomapper — Mon, 23 Sep 2024 19:00:59 GMT

I have noticed that the dates in my inbox are not sorting properly. Even when I provide the instance_name in the format of 'year / month / day' ('%Y %b, %d'), it does not seem to honor it. I have also tried using the filter options within the app, but it still does not sort the assignments accurately. My goal is to sort the assignments by year, then month, and then date from furthest to latest. Any assistance would be appreciated.

if(${nextinspection} - today() <= 0, concat('', format-date(${nextinspection}, '%Y %b, %d'), ', ', "Past Due"," ", ${nextinspection}, ''), concat('', format-date(${nextinspection}, '%Y %b, %d'), ', ', "Coming Soon"," ", ${nextinspection}, ''))

Re: Issue with Instance_name Dates not sorting in Inbox

neomapper — Tue, 24 Sep 2024 18:25:43 GMT

I have found a temporary solution that may not be perfect, but it will suffice for now. It is surprising that the inbox function has not been improved for the community. Survey123 is considered one of the best user-friendly apps for capturing data with smart forms.

Re: Issue with Instance_name Dates not sorting in Inbox

abureaux — Tue, 24 Sep 2024 19:02:09 GMT

I'd swap month name for number. 20240924 will sort better than 2024-Sep-24.