How Show All Records In Dashboard Without Scrolling?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

How Show All Records In Dashboard Without Scrolling?

Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
This feature has been requested on QuickBase's UserVoice:


"Can you add the ability to show all records in a report on the dashboard? Similar to the old dashboards which showed all records."

https://quickbase.uservoice.com/forums/111823-quickbase-product-feedback/suggestions/8913322

Would you believe it only takes one like of code to fix this? Have a look at my Northwind Traders dashboard and click the Good and Bad buttons to flip between the two dashboards - one with scrolling of the report and one without.
The Good Dashboard without Scrolling
https://haversineconsulting.quickbase.com/db/bf3zb9bph?a=showpage&pageid=14

The Bad Dashboard with Scrolling
https://haversineconsulting.quickbase.com/db/bf3zb9bph?a=showpage&pageid=13

And The Ugly ...
https://www.youtube.com/watch?v=5PgAKzmWmuk

Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=435
Photo of Adam

Adam

  • 0 Points
Hey Dan, is it possible to do this for a report not on the dashboard? Taking it a step further, is this possible for a grid edit report?
If so, how?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
I would have to see an example of where you are encountering scrolling and don't want it. If reports are long QuickBase pages the report and provides navigation to the previous / specific / next page of the report which I think is the  best interface. I don't have the extra time to explore all possibilities but as a general rule most things can be patched up. But you should use UserVoice to get a new feature implemented as these techniques are generally workarounds.
Photo of Adam

Adam

  • 0 Points
Thanks for the response Dan. The only case that's relevant to me is grid edit reports. My users would rather have grid edit look and function as close to an excel spreadsheet as possible (no scrolling). I'll be sure to sure to use UserVoice, thanks for the suggestion.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Adam>The only case that's relevant to me is grid edit reports

We have been having remarkable success using handsontable - an Excel style JavaScript library with a truckload of features. It integrates beautifully with QuickBase and offers every feature you could reasonably expect from Excel. For example I am in the process of creating a generic Join Editor. Attached is a screenshot of a demo that allows you to directly edit the many to many relationship between Employees and Skills using a Join table.


Employees  Join  Skills

In this case you want both vertical and horizontal scroll-bars if the number of rows or columns is large along with freezing the first row and column which contain the headers.
HandsOnTable
http://handsontable.com/
This thing is fantastic!
UPDATE:
I wanted to show you the Join Editor Form in QuickBase with the second screenshot. 
Pro Tip for Forum Posting:  The Unicode characters for the crow's feet are ⤙ and  ⤚
Employees  Join  Skills
Now I just need to track down the Unicode characters for the remainder of my operators (see screenshot3) and I will be all set for my presentation at the Mas Que Nada User Group Presentation held in Brazil entitled "A QuickBase Relational Algebra Implemented in Underscore.js"
Photo of Adam

Adam

  • 0 Points
Very interesting. It essentially allows you to turn information from a report into something better than grid edit. I'm always amazed by your use of javascript plugins to improve native QuickBase. I'll have to look into it!
Photo of enielsen0001

enielsen0001

  • 40 Points
This is perfect!  Except that I don't know how to integrate the script with a dashboard page.  How might I go about that?  Is there a way to only target certain report tables, or exclude others?  Thank you so much for your good work.