How to Create a Rollup Field in Zoho CRM

How to Create a Rollup Field in Zoho CRM


Create a new workflow

To get started, first, you’ll need to access your Zoho CRM settings.

In a new tab or window, log in to your Zoho CRM account and click on the gear icon at the top right corner of the page, beside your profile picture.

From the menu, click on “Workflow Rules” under the “Automation” menu.

Step by step guide

On this new page, click “Create Rule”

Fill in the prompt box with the module you want to use, a name for your workflow (we recommend using descriptive names), and a description.


Configure the new workflow based on when you want the rollup to happen

The workflow editor is the starting point to create the WES flow. Like other automations, use the trigger and the condition to define exactly how and when you’d like your data to auto-fill.

For example, if I want to count how many clients there are in an account, based on the sum of all Clients on the Account, the trigger is on “Edit”, and the condition is when “Account Name” is modified to “any value”.



Select the "Advanced Field Update" under Custom Actions

Once the trigger and the condition are defined, the final step is defining the action.

The “Advanced Field Update” action is under the Custom Action menu. This is available for both Instant Actions and Scheduled Actions.

Note: If the Advanced Field Update is not available, you’ll need to download the WES extension: https://bluroot.ca/wes/


Select the "Aggregate field to lookup" flow to configure the data you want to sum

The “Advanced Field Update” Custom Action gives the option for 4 different data flows. Select the “Aggregate field to lookup” data flow.

What you will see here, as soon as you click it, is this step-by-step guide along the top that is telling us exactly how we’re going to roll all those deal amounts into an account.

Your selections should look similar to this:



Save the workflow and see it in-action!

Describe the mapping using the Custom Action name. This will be useful when making edits in the future. Click save on the workflow editor.

We recommend triggering the workflow to ensure that the data mapping occurred as expected.


Get the help you need

You can get the Advanced Field Update Custom Action by downloading the WES extension:

Download WES

If you have any questions at all, please do not hesitate to reach out to our support team at support@bluroot.ca.

Happy WES-ing!

Get Your Questions Answered

Still have questions? The BEST way to get them answered is to meet with a Zoho Expert. Join our free office hours, get your questions answered, and see us in action with other Zoho businesses- like you!

Register for FREE Office Hours