Discussions

 View Only
  • 1.  Report coming from different Tables

    Posted 11-21-2020 06:56
    I would like to build a report of customer/Contacts that do not currently have an Open Project or on Open Opportunity attached.  I also would like to be able to pull when the last activity was for that customer/contact. 
    Here are my current tables and all the related fields.                   Any Insights?


    Here is my current linkage with all the related fields


    ------------------------------
    Tina Revermann
    ------------------------------


  • 2.  RE: Report coming from different Tables

    Posted 11-21-2020 11:05
    np,
    The data can travel up and down the Relationships using Summary fields for up and lookup fields for down.

    Make a field Projects called [Active Project Exists (=1)] with a numeric formula value of

    IF(Project Status] = "Active", 1,0)

    1.  Lookup down to Project Contact Selection.
    2. Summary Maximum of that field up to Contacts.  Now you know which contacts are associated with Active Projects.

    Do the same with Opportunities.

    For the date, you can simply do a summary of the Maximum of the [Contact Date] or [Date Created] in Activities.



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



  • 3.  RE: Report coming from different Tables

    Posted 11-22-2020 01:29
    Thanks Mark!   This worked Great!

    ------------------------------
    Tina Revermann
    ------------------------------