Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Suggestion: Sorting empties to bottom

cancel
Showing results for 
Search instead for 
Did you mean: 
Samir_Ghosh
7 - App Architect
7 - App Architect

May I suggest a very helpful, super simple to implement, feature?

Problem: Sorting (ascending order) a single select that has empty values puts all the empties up front.
Work around: Reverse the single select options order (put 1st at bottom), but this is a pain.
Suggestion: You already have “Alphabetize” in Single or Multi Select, which sorts A-Z. Please enable a 2nd click to then sort Z-A. Voila! Now sort my view Descending and my empties will be at the bottom and my single selects will sort in the view correctly.

A better, more intuitive solution might be to provide a switch in Sort dialog: “Sort empties at top/bottom”.

3 Comments
Vivid-Squid
11 - Venus
11 - Venus

It is confusing have the up/down icon next to Alphabetize as that would imply that selecting it a second time would reverse the order.

Samir_Ghosh
7 - App Architect
7 - App Architect

That’s the intent: allow sorting by ascending or descending. Keep in mind, this is an easy solution to putting empty values in a Single Select field at top or bottom.

Roy_Golan
5 - Automation Enthusiast
5 - Automation Enthusiast

You often need Ascending with empty last. This is needed.