Discussions

Expand all | Collapse all

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

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

    Posted 02-11-2016 20:36

    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.



  • 2.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Top
    Contributor
    Posted 02-12-2016 17:51
    I've used a small table report to for example show last date updated. Have you considered this?


  • 3.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Posted 02-12-2016 17:54
    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


  • 4.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Posted 02-12-2016 17:55
    There are definitely ways to put a number up on the dashboard, but they involve javascript. So, not simple.


  • 5.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Top
    Contributor
    Posted 02-12-2016 23:16
    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.


  • 6.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Top
    Contributor
    Posted 02-13-2016 15:35
    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.


  • 7.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Posted 04-21-2017 18:45
    That works great...but leaves me with an entire web page and not just the number...am I missing something.  


  • 8.  RE: How can I get a simple formula-generated number to display on my dashboard?

    Posted 02-26-2016 15:21
    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.