0

How to sort on multiple columns in interface?

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

8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 7 mths ago
    • Reported - view

    When you talk about "sort items" are you talking selecting one column for Ascending and another for Descending?

    Like
      • Mike
      • ninox.1
      • 7 mths ago
      • Reported - view

      Fred That was the idea. Like you can do In SQL in an ORDER BY...

      Thanks Fred.

      Like
    • Fred
    • Fred
    • 7 mths 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.

    Like
      • Mike
      • ninox.1
      • 7 mths ago
      • Reported - view

      Fred Thanks!

      Like
  • Mike

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

    Maybe this helps.

    Like
      • Mike
      • ninox.1
      • 7 mths 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.

      Like
    •  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.

      Like 1
      • Mike
      • ninox.1
      • 7 mths ago
      • Reported - view

      RoSoft_Steven Rooryck Good info, thanks! …:)

      Like
Like Follow
  • 7 mths agoLast active
  • 8Replies
  • 147Views
  • 4 Following