Forum Discussion

BryanBryan's avatar
BryanBryan
Qrew Member
8 years ago

adding a count of activities with a customer

I have a simple app and I am looking to have report with each customer identify the number of activies recorded with the particular customer. The customer and activities are on different tabs. Any help would be appreciated. I am a beginner QB. 
Ask about Quickbase functionality
Tables and fields
  • ChuckGrigsby's avatar
    ChuckGrigsby
    Qrew Cadet
    8 years ago
    Go into one of the tables (tabs) and click settings. Then click relationships. You should see one connecting Customers to Activities. On the Customers side you want to click Create Summary field. Additionally you can enter a criteria to filter that number if you're looking for a specific type of activity count. 

    Now that you have the field created you can go to the Customers table, click reports and charts and create a new one. Choose the customs you want to see, maybe Name, Address, Phone, # of Activities for example.

    Hope this helps! Good luck!