Already an issue on GitLab, cross-posting it here for visibility.
“When sorting, when the user chooses a “sort by” field that is of type single select, it would be very helpful if you could choose to sort the field by the user-chosen option order in the single select field. As it is now, the single select field can only be sorted alphabetically. However, this lacks intuitiveness. If the single select field options can be rearranged, then the user-chosen order of options is significant. Thus the user should be able to sort that field type by his chosen option order.”
Hey-hey! We plan to implement this feature soon. So it will be possible to sort Single select fields according to the order of the options in the field’s menu, or alphabetically if you’d like. We don’t have any exact time frames yet, but we will try to work on it in the nearest future
Hey @Yam, first of all, welcome to the Baserow community! This is a low-priority issue, and that’s why there hasn’t been any progress yet. I’ll check with the team if we can score it slightly higher.
Hey @Yam, we think the issue’s score should stay as it is. However, we’ve discussed the implementation for the feature, and we plan to offer 4 sorting options: Ascending A-Z, Descending Z-A, First to Last, and Last to First. Would that work for you?