Sum fields from multiple records Zoho CRM

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.

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.

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 calculate the Deal Amount, based on the sum of all products/quotes on the Deal, the trigger is on “Edit”, and the condition is when “Stage” and “Amount” are modified to “any value”.

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/

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 like this:

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.

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!