Articles on: coreILLA

coreILLA - Workflow Builder: How to Use the Math Operation Action in coreILLA for Firearms Business Automation

The Math Operation action lets you perform automated calculations on numerical data and dates within your workflows. For firearms businesses, this can be used to track customer activity, automate sales calculations, manage stock, or determine compliance deadlines, making your processes more efficient and accurate.

Imagine you want to track customer purchases or calculate discounts on firearms or accessories automatically. This action saves you from manual work, helps maintain accuracy, and provides personalized insights about your customer base.
What Does the "Math Operation" Action Do?
The "Math Operation" action allows you to:
Add, subtract, multiply, or divide numbers.

Add or subtract time (days, months, years) from dates.


This is useful for performing calculations that you would otherwise have to do manually. For example, after a purchase, you could add a number to a "Lifetime Purchases" field, or after a gun license expires, calculate the days left and send a reminder.

Key Benefits for Firearms Businesses:

Automated Sales & Discounts: Automatically calculate sales amounts, taxes, or discounts during promotions. For example, if you are running a 10% off sale on AR-15 accessories, you can set up the system to automatically calculate and apply the discount to the final price.

License and Background Check Tracking: Automate the calculation of license renewal dates, background check expirations, or any other compliance-related tasks. You can automatically send reminders to customers about expiring licenses, making sure you stay compliant with firearm regulations.

Tracking Customer Purchases: Add up the total number of purchases made by each customer. This can be used to calculate loyalty rewards, lifetime value, or to identify high-value customers who deserve special offers.

Inventory Management: Subtract sold inventory items from your total stock to track what’s left. For example, when customers purchase a specific type of ammunition, this action can reduce the stock count automatically, and if levels get too low, you can trigger a reorder process.


Some Excellent Usage Cases for the Math Operation and How it solves some real business problems:

Sales Commissions: Calculate commission amounts for sales representatives based on custom commission rates and achieved sales targets, ensuring fair and accurate compensation.

Subscription Expirations: Calculate subscription expiration dates for a software service by adding the subscription duration to the activation date, enabling timely renewal reminders.

Customer Lifetime Value: Multiply average purchase value by the frequency of purchases to estimate a customer's lifetime value, helping businesses identify high-value clients and optimize marketing efforts.

Inventory Management: Subtract sold items from the total inventory to track stock levels and automate reordering processes.

Warranty Tracking: Add warranty duration to the product purchase date to determine the end of warranty coverage and facilitate customer support.

Age Verification: Subtract a customer's birthdate from the current date to verify their age for age-restricted products or services.

Discounted Pricing: Multiply the original price by a discount percentage to calculate discounted prices during promotional campaigns.

Sales Tax Calculation: Multiply the subtotal by the applicable tax rate to determine the final price, ensuring accurate invoicing.

Milestone Bonuses: Calculate milestone bonuses for employees by multiplying their base salary by a predetermined bonus percentage, rewarding hard work and dedication.

Product Profit Margin: Subtract the cost of goods sold from the selling price and divide by the selling price to calculate profit margins, enabling informed pricing decisions.

Customer Segmentation: Calculate the average time between purchases to segment customers into groups like "frequent buyers" or "occasional shoppers," optimizing marketing campaigns.

Event Countdown: Subtract the current date from the event date to display a countdown timer for upcoming events or promotions.

Budget Tracking: Subtract expenses from the total budget to monitor remaining funds and ensure responsible spending.

Interest Calculation: Calculate interest on savings accounts or loans by multiplying the principal balance by the interest rate, providing a clear overview of financial growth or debt repayment.








## # Create or select a workflow: Begin by creating a new workflow or selecting an existing one where you want to apply the Math Operation action.


Click on Add Action
Step 1 screenshot


Add the Math Operation action.
Step 2 screenshot


Choose the field to update: Select the numeric or date field you want to update with the result of the math operation. Depending on your requirements, this field can be a standard or custom field.
Step 3 screenshot


Select the operation: Choose the mathematical operation you want to perform on the selected field.

You can choose from addition, subtraction, multiplication, or division for numeric fields,
Step 4 screenshot


And you can choose the addition or subtraction of days, months, or years for date fields.
Step 5 screenshot


You can add any values from the trigger and use them in the field "Select Field"

The numeric and trigger fields will also be available in the 'Value" field in the operation section.
Step 6 screenshot


Untitled step
Step 7 screenshot


Input the operator. Enter the value or custom field to use as the operator in the math operation. For example, if you want to add 10 to a numeric field, input "10". If you use a custom field, you can insert it using the appropriate merge tags or custom field syntax.


Update Field - Select the field that you would want to update. In the Update field dropdown you will find "Standard Fields", "Custom Fields" and "Custom Values" to select from.
Step 9 screenshot


Save the action: Click "Save" to apply the Math Operation action to the workflow.

Updated on: 10/22/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!