Forum Discussion

PatrickO_Neill's avatar
PatrickO_Neill
Qrew Member
2 years ago

Expose Count Of Records In Report

Hi,
I've created a report to pick records from a table based on a set criteria - is it possible to add a formula object to a form to display the number of records in my Record Picker report.

Want to use the count of records to enable / disable certain features from within the report.

Rgds
Pat

------------------------------
Patrick O'Neill
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    In general, yes.  You can use a Formula Query. That is recent functionality. Have you used them before?  The formula will dynamically recalculate based on the fields in the record  


    If you are new to formula queries, the easiest way would be to boil your qualification criteria to a single checkbox field instead of a more complex set of filters. 


    I can post links to help examples if you need syntax help.  But heading out to ski now ......



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------