Discussions

 View Only
  • 1.  Summary Field Data

    Posted 03-11-2020 17:50
    I have created a summary report that shows the number of records that I have for each item. I would like to take the number from the far right (the number of inventory items) and display on another table.

    The closest I have gotten is having a report link to all the records of that particular item number. I don't care if that link works or not, I just need to be able to see the number of inventory I have. 


    ------------------------------
    Katlyn Allen
    ------------------------------


  • 2.  RE: Summary Field Data

    Posted 03-11-2020 17:58
    Katlyn,

    Do you have a relationship where One Item Number has Many Inventory Records? If so, what you want to do is to make a summary field on that Relationship to total up the total qty or the total # of Inventory records and put that on your Item Number Master form.

    To make a Summary field you go into the relationship and use the link on the left side to Add Summary field.



       ​​

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Summary Field Data

    Posted 03-11-2020 18:04
    That is exactly what I needed! Thank you!

    ------------------------------
    Katlyn Allen
    ------------------------------



  • 4.  RE: Summary Field Data

    Posted 03-11-2020 18:05
    Hey, sometimes you get lucky and what you want is easy.  With Quick Base it's often easy to get lucky.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------