How to sort on multiple columns in interface?

ninox.1
3 yrs ago
8replies

Is there a way via the interface to sort items on multiple columns (like an ORDER by in a SQL statement) and have the grid view update to show that combined order?

Thanks

- Fred
- 3 yrs ago
- Reported - view
When you talk about "sort items" are you talking selecting one column for Ascending and another for Descending?
- ninox.1
  
  3 yrs ago
  
  Reported - view
  Fred That was the idea. Like you can do In SQL in an ORDER BY...
  
  Thanks Fred.
- Fred
- 3 yrs ago
- Reported - view
Sadly, Ninox can only sort columns one at a time in table view. You can create a new field that combines other fields that would allow you to sort by multiple fields, but not multiple columns.
- ninox.1
  
  3 yrs ago
  
  Reported - view
  Fred Thanks!
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Reported - view
Mike

https://forum.ninox.com/t/x2hr8j3

Maybe this helps.
- ninox.1
  
  3 yrs ago
  
  Reported - view
  RoSoft_Steven Rooryck Not exactly, but I wanted to ask if you can create separate form views for the same table -- each with different fields and placements. Every time I try to do it, I seem to be removing a field from the main table. I don't seem to understand how to do this basic operation.
- Ninox partner
  
  RoSoft_Steven.1
  
  3 yrs ago
  
  Reported - view
  Mike Only one form for each table. But,...
  
  If you make different Tab elements in your form, you can kinda create different formlayouts per Tab, each containing their own fields. If you want duplicate fields in tabs, you must use formula fields. You can even hide a tabelement for certain users. Or use a Dashboard to jump to the correct tab.
  
  Hope this helps.
- ninox.1
  
  3 yrs ago
  
  Reported - view
  RoSoft_Steven Rooryck Good info, thanks! …:)

Content aside

1 Likes
3 yrs agoLast active
8Replies
494Views
5 Following

Welcome to the Ninox community

How to sort on multiple columns in interface?

8 replies

Content aside

Overview