Solutions keyboard_arrow_down keyboard_arrow_up
Our Solutions
Ontraport's solutions work together to give you everything you need to run your business in one centralized, easy-to-use platform.
Resources keyboard_arrow_down keyboard_arrow_up
Resources
Find free content on the latest marketing strategies, using Ontraport in your business, and finding the right software.
Visit the blog
University Pricing Chat
clear

Create equations in fields

Last updated on: December 13, 2024

Incorporating equations into numeric and pricing fields allows you to customize your data for a multitude of uses, such as creating reports and automating follow-up based on criteria such as quantity and frequency of purchases.

Follow the steps below to set up math equations with numeric or price fields in Ontraport. 

Table of contents

Set up equations in your automation
Set up equations in rules
Use case

To set up equations in your automation

Back to top

In most cases you’ll want to use automation maps for your equations because they give you the most customization and reporting for your automation.

  1. Create a custom numeric field.
  2. Click ContactsAutomations, then either edit an existing automation map or start from scratch.
  3. Click What happens next?Update contact.
  4. Click your new Update contanct element, then select your numeric or price field from the dropdown on the far left.
  5. Choose the numeric or price to be updated in the “Update the field” dropdown and click Insert Merge Field.

  1. Add in the merge field for your numeric/price field. From there, you can set up your equations to add, subtract, multiply, or divide:
    • [Your Field]+1 will increase the value of a numeric or price field by 1.
    • [Your Field]*5 will multiply the value of a numeric or price field by 5.
    • [Your Field A]/[Your Field B] will divide the value in field A by the value in field B.

  1. Complete your automation map, and click PublishSave and Publish.

Set up equations in rules

Back to top

If you simply want an action to trigger your equation to calculate, use a rule.

  1. Create a custom numeric field.
  2. Click ContactsRulesNew Rule.
  3. Name your rule and choose your trigger.
  4. Click + Add Action → add “Change the Value of a Field” and select your numeric or price field to be updated from the dropdown on the far left.
  5. See step 6 above for equations that can be used.
  6. Click Save.

Use Case

Back to top

If you would like to offer a coupon to reward top customers, you could set up an automation map that will send coupon codes to your customers who frequently make purchases. For example, you can set up a trigger element for Product is Purchased. Following the trigger, add in an Update Contact element and select your custom numeric field. Insert the merge field for your field +1 (e.g. [Purchase Count]+1). Now add a goal for “Purchase Count” to be updated with a condition that “Purchase Count” is equal to five. Follow the goal with a send email element. This email will include the merge field for a personal coupon for this contact. This way, every time that a customer purchases five products from you, then they will be rewarded with a coupon.

Related university lessons

Building custom reporting automations
Learn how to use automations to create detailed custom reporting on your business processes — and step up your oversight on key performance indicators.
Putting automations together
Create a fully functional lead magnet and nurturing automation step-by-step, using all the tools you’ve learned about.
Performance Mode basics
Take a tour of Performance Mode to see your live automation results, where they’re coming from and where to focus your efforts next.
arrow_drop_down_circle
Divider Text

Related support articles

arrow_forward
Custom field limits
arrow_forward
Add contacts to Facebook Custom Audiences
arrow_forward
Manage contacts by stage (Card View)

 Pro tips

Tip #1: Numeric fields will round to the nearest whole number. Price fields round to the nearest decimal value to two decimal places. Avoid mixing numeric and price fields in the same equation to prevent losing data when a numeric field is updated using a price field.
Tip #2: For equations that use decimal numbers less than one, be sure to add a 0 before your decimal point, such as [price field]+0.25.
Tip #3: If you want to create more complex equations, use parentheses to force the order of operations.
Tip #4: You can use numeric user fields for product counts or to count the total number of contacts who have performed an action. For example if you know that you have 100 units of a certain product, you can keep tabs on how many you have left by subtracting from a numeric user field every time a contact purchases the product.
Features
Company
Resources
Live events
Access
© Ontraport 2024
playlist_add_check
PCI DSS, Level 1
security
Privacy Shield Certified
[bot_catcher]