Select to view content in your preferred language

Survey123 Adding sort to the Inbox

1825
7
Jump to solution
09-16-2021 09:55 AM
YukoYokozawa
Frequent Contributor

Can I add sort to the data in Inbox? 

0 Kudos
1 Solution

Accepted Solutions
DeonLengton
Esri Contributor

You can click on the sort icon and get the following options:

DeonLengton_0-1631858610007.png

 

View solution in original post

7 Replies
DeonLengton
Esri Contributor

You can click on the sort icon and get the following options:

DeonLengton_0-1631858610007.png

 

YukoYokozawa
Frequent Contributor

I see... Is there a way to add sort on the query in the Inbox option? I tried to add ORDER BY but didn't work.

0 Kudos
MattReeves_SpokaneValley
Regular Contributor

How does Survey123 (not connect) decide which fields to use for the Ascending / Descending decision? i.e. Can I control which fields to use for these Ascending and Descending Sort options without using Survey123 Connect? 

Matt Reeves
IsmaelChivite
Esri Notable Contributor

 The ORDERBY in your WHERE statement will be overruled by the app sort options @DeonLengton showed.

0 Kudos
YukoYokozawa
Frequent Contributor

I see. I tested the sort in Inbox, and found it sorts by what it appears in there (the instance name). Also if the date is in word (like april, may...) it sort by the letter; April comes before January. Is this right?

YukoYokozawa_0-1631896437452.png

Above, I sorted descending

 

0 Kudos
DeonLengton
Esri Contributor

Hi 

Yes that is correct, it sorts alphabetically, not by the data in your records.

If you want to sort by date you could potentially format the date in your instance name to be dd/mm/yyyy

0 Kudos
YukoYokozawa
Frequent Contributor

Thanks for the reply. I will adjust my instance name. 

0 Kudos