Skip to main content
Question

Is there a way to get more that one sort option in a table

  • July 12, 2019
  • 0 replies
  • 34 views
Is there a way to get more that one sort option in a table? In other fields there is a (+ -) that lets you do multiple sorts. However, the table page only lists one. When I am in the actual table I can of course sort multiple ways but if I move from the page then it reverts back. How do I get the multiple sort to stick? 

It is always the simple things that trip me up so I am sure I am just missing something. 


    This topic has been closed for replies.

    The default report allows only one sort criterion, but you can fake it by creating a new report using all of the default options except setting the sort criteria as you want, and then changing the table home page report from "Default report" to your new report.  (You change the home page report by clicking "Customize this report" and -- instead of clicking "Edit settings" beside the report name, click the arrows to select a different report.)
    What I do is to make a field called [default sort]

    List("-", [field 1],[field 2],[field3])

    Then set that formula field as the default sort.
    • ShayWebb
    • Author
    • Quickbase Alumni
    • July 12, 2019
    Seems an odd thing to have a work around for. I'm REALLY new to QB. I will try adding the default sort field. Thanks
    Terms & ConditionsAccessibility statement