Forum Discussion

ShayWebb's avatar
ShayWebb
Qrew Member
6 years ago

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

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. 


Tables and fields
  • deldridgdeldrid's avatar
    deldridgdeldrid
    Qrew Trainee
    6 years ago
    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.)
    • deldridgdeldrid's avatar
      deldridgdeldrid
      Qrew Trainee
      6 years ago
      You have to create a different report from the default report, but you don't have to rebuild everything from scratch.  In your new report, using the default options will mean that your new report behaves like the default report and that any changes to the default report will be reflected in the new report as well.  To use the default options, make sure "Columns to display" = "Default columns," "Filters" = "Show all xxxx," and "Dynamic" filters = "Use the dynamic filters defined in default report settings.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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's avatar
    ShayWebb
    Qrew Member
    6 years ago
    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