Select to view content in your preferred language

Issue with Instance_name Dates not sorting in Inbox

291
2
Jump to solution
09-23-2024 12:00 PM
neomapper
Frequent Contributor

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('<font color="red"><b>', format-date(${nextinspection}, '%Y %b, %d'), '</b>, ', "Past Due","<br>", ${nextinspection}, '</font>'), concat('<font color="orange"><b>', format-date(${nextinspection}, '%Y %b, %d'), '</b>, ', "Coming Soon","<br>", ${nextinspection}, '</font>'))

neomapper_0-1727117784638.png

 

 

0 Kudos
1 Solution

Accepted Solutions
neomapper
Frequent Contributor

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. 

View solution in original post

0 Kudos
2 Replies
neomapper
Frequent Contributor

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. 

0 Kudos
abureaux
MVP Frequent Contributor

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

0 Kudos