How can I get a simple formula-generated number to display on my dashboard?

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

I have a report representing a number of records. All I want is to display that number on my dashboard. I don't want it to take up a lot of space. I'm pretty handy with the formulas & functions of the app, but I don't know anything about API, if that's the solution.

I thought maybe I could put a formula into a text widget. It would be a pretty complex formula if I have to duplicate the report, but I could probably figure that out, but I don't know what format to use to get it to display, or if that's even possible with the text widget.

Photo of Bataar

Bataar

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points
I've used a small table report to for example show last date updated. Have you considered this?
Photo of Bataar

Bataar

  • 0 Points
Yeah, I considered doing that. I was hoping to make something smaller & simpler, but it looks like making it that simple will be incredibly complex :s
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,292 Points 50k badge 2x thumb
There are definitely ways to put a number up on the dashboard, but they involve javascript. So, not simple.
Photo of Jack

Jack, Champion

  • 50 Points
You can size the report widget quite small in the dashboard page. Not ideal but probably the best way of doing it unless you want to write code.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,964 Points 20k badge 2x thumb
Just put this code into a user defined page and insert it into your dashboard as a web page widget:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=491


You will have to supply parameters for the dbids and qid.
Photo of [none]

[none]

  • 130 Points 100 badge 2x thumb
That works great...but leaves me with an entire web page and not just the number...am I missing something.  
Photo of Bataar

Bataar

  • 0 Points
This seems a bit beyond me. The report that produces the number of records I want to display has 11 filter parameters, so it looks like getting this together will be a lot more work than is worth it. I guess I'll just display a report. Thanks for the answer.