RESOURCES‎ > ‎Example Rollups‎ > ‎

Contact Rollups

 Target:  Contact, Source: Task, Relationship: Who ID

    Rollup 1: Last Task Completed
                  Create a Text rollup from the Subject field of Task to the Last Task Completed field of Contact.
                  Filters: 
                        - Deleted will need to equal false
                        - Closed should equal true
                        - Add a sort by 'Activity Date' descending.  You will want to limit the number of results to 1.
  
    Rollup 2: Last Task Completed (Date)
                  Create a Max rollup from the Activity Date field of Task to the Last Task Completed Date field on Contact.
                  The filters should be the same as the above.

    Rollup 3: Next Task Planned
                  Create a Text rollup from the Subject field of Task to the Next Task Planned field of Contact.
                  Filters: 
                        -Deleted should equal false
                        -Closed should equal false
                        -Add two sorts - One by Created Date ascending, the other by Activity Date ascending.  
                         Limit the results to 1.

    Rollup 4: Next Task Planned (Date)
                  Create a Min rollup from the Activity Date field of Task to the Next Task Planned Date field of Contact.
                  Filters should be the same as Rollup 3: Next Task Planned.

    
Comments