Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoYou 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
------------------------------
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
------------------------------
- AndrewFry6 years agoQrew Assistant CaptainInteresting 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
------------------------------- EverettPatterso6 years agoQrew CaptainCheck out the video on QuickBase University.
Quick DIY Solutions for Beautiful and User-friendly Apps
I use them on dashboards to make it easier for users to see totals and other important information.
------------------------------
Everett Patterson
------------------------------