Discussions

 View Only
  • 1.  Expose Count Of Records In Report

    Posted 01-19-2023 17:37
    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
    ------------------------------


  • 2.  RE: Expose Count Of Records In Report

    Posted 01-20-2023 01:18

    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
    ------------------------------



  • 3.  RE: Expose Count Of Records In Report

    Posted 01-20-2023 09:03
    @Mark Shnier (Your Quickbase Coach)  the slopes provide great inspiration for solving business problems.  :)   Enjoy!​

    ------------------------------
    Don Larson
    ------------------------------