Is there a way to have +/- grouping buttons in a table report like in Excel?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Looking for a native solution first. -   It's a toggle button. It would work on both columns and rows as needed. See Excel screenshot for clarity of what I mean.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Dynamic Filers can de-select rows to be displayed, (natively).  But I don't know of a way to toggle column aside from that you can click the blue column triangle to "hide" a column.  

But, I have done reports where the user might have wanted to toggle between different sets of columns as there were too many to show on one screen without side to side scrolling. So I made I think 4 versions of the report and then provided very skinny links (url formula links) as the last 3 columns to link to the other 3 versions of the report.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb
I guess I'm thinking of expanding dynamically rather than de-selecting dynamically.  For example, we have one client project that is large and has many work steams.  In the projects table, we originally made one project record to track all of its costs.  Later, we decided we needed more detailed tracking so we made 8 more projects and all cost from then on was put into one of these 8 "sub projects" instead of the original. However, we use a table report that shows all 9 projects, but I wish it could just show the original one and then we could expand it to see the other 8.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb
In addition, when the report only shows the original record, that records fields would display the grand totals of the 8 "sub projects".  Kind of like a summary record.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Well, if you want it to work exactly like excel, you can always dump the data to excel and use the Excel features.

But in terms of sticking with QuickBase, it "expands" by drill downs.  So I suggest that you think of starting at a summary level and then drilling into detail.  Summary reports are fully native, but with clevel use of URL formula buttons it's possible to hyperlink to any "detail" target record or list of records.