The Math Operation workflow action is a versatile feature designed to automate calculations on numeric, monetary, and date fields within your business workflows. Whether you’re calculating lead scores, setting renewal reminders, or determining project deadlines, this feature simplifies manual processes, improves accuracy, and enhances overall workflow efficiency. This guide will walk you through what the Math Operation action is, its key benefits, configuration steps, use cases, and answer frequently asked questions to help you get started with confidence.
TABLE OF CONTENTS
- What is Math Operation Workflow Action?
- Key Benefits of Math Operation Workflow Action
- Configuring Math Operation Workflow Action
- Frequently Asked Questions
What is Math Operation Workflow Action?
The Math Operation workflow action allows users to perform various calculations directly within a workflow. You can add, subtract, multiply, or divide numeric fields and update them automatically based on specific actions or triggers. For date fields, you can add or subtract days, months, or years, making it easy to automate time-sensitive processes like reminders or scheduling.
For example, a subscription-based service can use the Math Operation action to calculate renewal dates by adding a specific duration to the start date, ensuring customers receive timely reminders.
Key Benefits of Math Operation Workflow Action
Here are some of the key advantages of using this feature in your workflows, helping you automate calculations, improve accuracy, and streamline processes effortlessly.
- Automation & Efficiency: Eliminates manual calculations, reducing errors and saving time while streamlining repetitive tasks like lead scoring, commission calculations, and deadline management.
- Customization & Integration: Supports custom fields and values, allowing flexible configurations while seamlessly working with other workflow actions, triggers, and If/Else conditions for advanced automation.
- Accuracy & Scalability: Ensures precise updates to numeric, monetary, and date fields while handling large data volumes without additional manual effort, maintaining consistent performance.
Configuring Math Operation Workflow Action
Now that you have understood the advantages of using this action, Let's learn how to set up the Math Operation action by choosing the right field, applying calculations, and updating values. Also, how to leverage dynamic fields, multiple operations, and custom values to keep your calculations accurate and automated.
Navigate to Automation
Select or create a workflow by navigating to the Automation section. Create a new workflow or choose an existing one where you want to add the Math Operation action.
Adding the Math Operation Action
Before adding the Math Operation action, it’s important to set up a workflow trigger—this determines when the workflow will activate and execute the Math Operation. Once the trigger is in place, click on “Add Action” and select “Math Operation” from the list to configure the calculation within the workflow.
Naming the Action
By default, the action is named “Math Operation,” but you can rename it for clarity. Use a descriptive name to make workflows easier to follow. A clear name helps quickly identify the action, especially in complex workflows.
Selecting a Field
After naming the action, the next step is selecting the field where the calculation will be applied. Clicking the “Select Field” dropdown presents three options:
- Date Fields: With this option, you can perform date-based calculations for scheduling, reminders, or age verification using system-generated date fields like Current Date and Date of Birth. Lets understand each option:
- Current Date: Represents the present date when the workflow runs. This is useful for operations like calculating deadlines, follow-up reminders, or scheduling future events based on today’s date.
- Date of Birth: Refers to a contact’s recorded birth date. This option is often used for age verification, birthday reminders, or calculating anniversaries.
- Current Date: Represents the present date when the workflow runs. This is useful for operations like calculating deadlines, follow-up reminders, or scheduling future events based on today’s date.
- Custom Fields: These are fields specific to your CRM setup, such as Policy Expiry Date or Contract Start Date. Selecting a custom field enables calculations based on data stored in the system, making it useful for setting up automated renewal reminders, contract extensions, or milestone tracking.
- Custom Values: This option allows you to manually input a static value instead of selecting a stored field. It’s useful for applying fixed calculations, such as adding a specific number of days to a date field or calculating a percentage increase for lead scores or pricing adjustments.
Operation Type
Once you’ve selected a field—whether it’s a Date Field, Custom Field, or Custom Value—the next step is to define the type of calculation you want to apply.
Date fields : In Date Fields you have the flexibility to add or subtract days, months, or years, making it easy to set up automated reminders, deadlines, or scheduling adjustments.
Numeric and monetary fields: In numeric fields, you can perform operations like Addition, Subtraction, Multiplication, or Division to update values automatically.
Setting the Operation Value
After selecting the operation type, you need to enter a numerical value for the calculation. You can either input a static number manually or use the ”+” and “-” icons to quickly adjust the value as needed.
Tag Icon
The Tag Icon allows you to select dynamic values from custom fields instead of entering static numbers manually. This ensures that calculations automatically adapt to real-time data changes, making workflows more flexible and efficient.
Delete Icon
The delete icon (trash bin) lets you remove an operation if you no longer need it. This feature helps keep calculations clean and accurate by allowing quick adjustments without rebuilding the entire Math Operation action. If a mistake is made or an operation is no longer required, simply click the trash bin to delete it.
Adding Multiple Operations
In order to add multiple math operations within a single math operation action you will use the Add Operator option. This feature is useful when performing a sequence of calculations, such as first adding a value and then multiplying the result. By clicking Add Operator, you can continue refining the calculations without needing separate workflow actions, making complex automation setups more efficient.
Update Field
The Update Field option determines where the result of the calculation will be stored. Users must ensure that the selected field matches the type of data being processed—numeric fields should be updated with numeric values, and date fields should store date-based calculations.
Save and Publish
Save and activate the action by clicking “Save” to apply the Math Operation action to the workflow. Once your workflow setup is complete, click “Publish” to activate the workflow.
Frequently Asked Questions
Q. Can I perform math operations on custom date fields?
Yes, you can perform addition or subtraction on custom date fields to automate time-sensitive tasks, such as reminders or scheduling.
Q. Are there any limitations on the range of values in math operations?
Numeric fields can store both positive and negative values, while monetary fields only accept values greater than or equal to zero. Negative values are not supported for date fields.
Q. Can I use Math Operation actions with If/Else conditions?
Absolutely! You can use the result of a Math Operation action in an If/Else condition to create dynamic workflows. For example, use calculated lead scores to route leads through different sales paths based on their engagement level.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article