Problem
As an Account Manager or Sales Rep. I need to see the most recent activity on an Account before contacting the client.
Solution
Create a Custom Object (Updates) as a child of Account so that all Account Team members can log notes in one central place. Create a Text rollup of the most recent Updates to the Account.
Rollup the notes first to Update, then up to Account.
- Rollup to Update:
- Create a Text Area field on Updates (Most Recent Notes)
- Navigate to Rollup Helper, Rollup Step 1 select Updates
- Rollup Step 2 select the field you created (Most Recent Notes)
- Rollup Step 3:
![Rollup Notes to Update](https://www.passagetechnology.com/hs-fs/hubfs/Rollup%20most%20recent%20updates%20on%20account%20-%20rollup%201.png?width=799&name=Rollup%20most%20recent%20updates%20on%20account%20-%20rollup%201.png)
- Add a filter:
- Limit of 3 child records per parent
- Sort order is Created Date, in Descending order
![Most Recent 3 Notes Filter](https://www.passagetechnology.com/hs-fs/hubfs/Rollup%20most%20recent%20updates%20on%20account%20-%20filter.png?width=1297&name=Rollup%20most%20recent%20updates%20on%20account%20-%20filter.png)
- Rollup to Account
- Create a Text Area field on Account ( Recent Updates)
- Navigate to Rollup Helper; rollup step 1 Select Account
- Rollup Step 2 select the field you created (Recent Updates)
- Rollup Step 3:
![Rollup Update to Account](https://www.passagetechnology.com/hs-fs/hubfs/Rollup%20most%20recent%20updates%20on%20account%20-%20rollup%202.png?width=780&name=Rollup%20most%20recent%20updates%20on%20account%20-%20rollup%202.png)
- Add a filter: Limit to 3 record, Sort Created Date in Descending order.
Save the filter, Save and Run the rollup.
Need help?
![Schedule a one-on-one demo](https://no-cache.hubspot.com/cta/default/4130736/fbae864a-7cf4-44e6-93ef-9069a57d082e.png)