Forum Discussion

AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
6 years ago

Simple question: Dashboard Reports - # of Records?

This is a a super simple question (I hope): Is it possible for the table reports on the Dashboard to list the number of records in the title of the report? Example: I have a table report titl...
App home pages
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You can make a dummy helper hidden table with just 1 record in it.  it will be Record ID# = 1.

Then make a field on your orders table called [Link to Order Count Totals] and make it a formula field with a formula of 1.
Then make a relationship. 

Make a summary count field with the filters for the status  = Pending.

Then look up that count down to your orders table.

Then create a report header text field with the words you like such as "# of pending orders is " &  ToText([# pending orders]).

Make that field be your first "Group By on the table report.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • AndrewFry's avatar
    AndrewFry
    Qrew Assistant Captain
    6 years ago
    ​Interesting tactic!!

    I hadn't even thought about using a dummy table or to edit the text of the report header to include a reference to a field in a table.

    I will have to give it a try here in a bit and report back.

    ------------------------------
    Andrew
    ------------------------------