I have a simple RG that displays notes (comments) that the user adds. These notes are sorted so that the newest comment is displayed at the top of the list. I have also created a checkbox so certain comments/notes can be ‘pinned’ to the top of the list.
I would like the RG to sort first by pinned comments, and then by date. This seems to work to a point. It will sort the pinned comments at the top and by date, but the unpinned comments no longer sort by created date.
Can a repeating group be sorted by multiple fields? Here is how it looks currently. Notice the note number. Note 1 was created first, followed by note 2, 3, etc.
Here is the search settings of this RG…
I should also note that if I pin note 6 (or any note that is out of order) and then unpin it, it sorts correctly. I don’t want to have to pin and unpin ever note though to get the sort to work. Is there some sort of workflow or refresh list option that might do the trick?