Hi! I'd like to request being able to sort a table by a hidden column. Maybe this should go hand-in-hand with being able to disable sorting for all columns at once (since it would be confusing to be able to change sorting, but not restore it to its default).
Currently, hiding a column that is used for sorting by default reverts the ordering to its default.
I've hidden the id column, but the Default column to sort by still changes the values in the table when selecting id and switching between descending and ascending. Were you looking for different behavior?
Ahhh, definitely an oversight on my end here. Didn't realize I was effectively just reusing the id data-set. You are correct that sorting by a hidden custom column does not work. I'll submit an internal feature request and update this thread whenever I have additional information!
I'm sorting a table by a hidden column - in this case it's because I'm showing the user a formatted text revenue column, but also using a hidden raw_revenue column that shows the actual numerical value.
Imagine a table:
Now, I want to sort the table by raw_revenue on the backend, but I also want to stop the user trying to sort the table by revenue - because doing that will mean they can't go BACK to the raw_revenue sorting without refreshing the page.
So what I'd like is a way to disable column sorting on a table - just like I can disable row selection.
Hey Henry14! Thanks for the feedback. You can currently disable sorting for individual columns in the column editor. So if you would like to disable sorting by revenue, you can do that. To disable sorting on the table as a whole, you would have to toggle that option on every column. I'll add a feature request for a master toggle that would disable sorting for every column, but wanted to let you know what option is available currently.\