How to Do Calculations with Gravity Forms

If you’re using Gravity Forms on your WordPress website, you might need an easy way to do Gravity Forms calculations on form fields and user submissions.

Last updated November 17, 2020 | Written by Maria Ansari 13 Comments

If you’re using Gravity Forms on your WordPress website, you might need an easy way to do Gravity Forms calculations on form fields and user submissions. This sort of feature is useful in all sorts of scenarios, such as:

Selling early bird tickets to events
Event bookings
Online course or membership registrations
Counting RSVPs

And there are many different types of calculations that you can do with Gravity Forms. For example, you can use it for all sorts of filtering options such as date ranges, payment statuses, or for logged in users only.

In this article, we’ll show you how you can do Gravity Forms calculations the easy way using Gravity Forms.

When You Might Need to Do Gravity Forms Calculations

Whether you’re an online store owner, run a membership website, or organize events, there are many scenarios in which you might need to do Gravity Forms calculations on your WordPress website. Here are some of the most popular use cases:

Use Case #1: Calculating Tax or VAT

You can use Gravity Forms to automatically calculate the sales tax or VAT (value added tax) at checkout for any transaction. For example, if you have a field for the product cost and you’re collecting a 5% sales tax, you could use the formula:

Total sales tax = Item cost * Sales tax Total item cost = Item cost + Total sales tax

Alternatively, you could use Gravity Forms eCommerce Fields plugin to add a Tax field to your form – more on this later.

Use Case #2: Offering Early Bird Discounts

Another way to use Gravity Forms calculations is if you need a way to offer discounts for a specific date range. This is useful for people who sell online courses, memberships, or event tickets. For example, if you want to offer early bird pricing to registrants who register for your event between December 23rd and January 10th.

Simply put, you can do all sorts of simple and advanced calculations on forms fields and user submissions. The Gravity Forms plugin lets you do calculations using a Number field with calculation enabled.

Case Study: Conference Registrations

Michelle Hayes uses Gravity Forms calculations for offering attendees an early bird discount during conference registration without using a coupon code. She was able to do this using the Gravity Forms Conditional Logic Dates and Gravity Forms Conditional Pricing add-ons.

Automatically calculating early bird price using Gravity Forms Conditional Logic Dates and Gravity Forms Conditional Pricing.
Dynamically offer multiple types of discounts with a single discount code field using Gravity Forms eCommerce Fields.
Directing registrants to the All-Access Pass if they’d like to register for all events using Gravity Forms Limit Checkboxes. This way, registrants don’t have to check all of the individual events; they can just choose an All-Access option.

As a result, Hayes was able to deliver an enhanced user experience to registrants. The same approach can be used to offer limited-time discounts for event tickets and memberships.

Best Plugins for Gravity Forms Calculations

Here are some of the best Gravity Forms add-ons for doing Gravity Forms calculations in WordPress:

Gravity Forms eCommerce Fields

The Gravity Forms eCommerce Fields add-on supports tax, discounts, and subtotal fields in addition to various other eCommerce features. It also lets you use special merge tags for including the subtotal and coupon (and discount) amounts in calculation-enabled fields.

Pros

Great for calculating tax and VAT.
Lets you apply flat or percentage discounts to the subtotal or to specific products.
Lets you make custom calculations using calculation-ready merge tags.

Cons

If you sell to customers in the EU, you will have to set up EU VAT calculations manually.

Gravity Forms Date Time Calculator

The Gravity Forms Date Time Calculator add-on lets you use date and time fields in your Gravity Forms calculations. You can use this for building forms with time-based pricing, determining the customer’s age based on their birth date, or for tracking days (or hours).

Pros

Supports all date and time units including years, months, weeks, days, hours, minutes, and seconds.
Lets you count days (weekdays or weekends) between two dates.

Cons

You have to use merge tags to perform calculations.

Gravity Forms Conditional Pricing

The Gravity Forms Conditional Pricing add-on lets you create flexible pricing levels for product fields based on conditional values. This is great for when you need to create a single product field with variable pricing.

Pros

Pricing rules automatically determine which pricing level should be applied.
Applies the pricing level when all specified conditions are met.

Cons

If you have hundreds of pricing rules, entering them can be tedious.

How to Add Calculations to Gravity Forms Using Gravity Forms Conditional Pricing

Here, we’ll show you how to add Gravity Forms calculations to your forms using the Gravity Forms Conditional Pricing plugin (part of Gravity Perks).

Start by creating a new form using Gravity Forms. Add a Product field to the form editor. You’ll see various field types to the right. Find the Product field under Pricing Fields.

For example, we’ve set the Field Type to Radio Buttons and created three different types of tickets.

Radio buttons for different ticket types

Next, add a Quantity field to the form. Registrants can use this field to purchase multiple tickets.

Once that’s done, go to Settings > Conditional Pricing to create conditions (or pricing levels). Use the Select a Product drop-down menu in the top-left corner to view a list of Product fields in your form. Select the Ticket Type: product field.

You can set a price for the pricing level and set the conditions that need to be met in order for this pricing level to be applied to the registrant’s purchase. You can create as many pricing rules as you’d like.

Pricing level for general admission tickets

Repeat these steps to create as many conditions as you’d like. You can use the Select a Product drop-down menu to select different product options, as well.

Click the Save Conditional Pricing button to proceed. You can add a Total field to your form to make it easier for customers to see how much they’ll be charged. Your form should look something like this on the front-end:

Get Started With Gravity Forms Calculations Today

If you’re looking for an easy way to set up and manage Gravity Forms calculations, the Gravity Perks’ suite of add-ons will certainly make things easier. You can use various plugins, including:

…to calculate fields, set conditions, and much more.

We showed you how to add calculations to Gravity Forms using the Gravity Forms Conditional Pricing plugin. Hopefully, you’re in a good position now to take the next steps.

Looking for an easy way to add conditional pricing calculations to Gravity Forms? Check out the Gravity Forms Conditional Pricing add-on!

Did this resource help you do something awesome with Gravity Forms? Then you'll absolutely love Gravity Perks; a suite of 32+ essential add-ons for Gravity Forms with support you can count on.

Comments

Wayne Powell says

August 25, 2020 at 10:33 am

I am wondering if there is a way to cause all the Entries in a Form to be re-calculated (we use Gravity Forms eCommerce Fields and Gravity Forms Conditional Pricing) after a Product Price change?

We often keep and then update our Entries past the submission stage to make changes to it through the year. Doing it manually by individual Entry Edit (and re-submission) is one way, but with hundreds of records that can get tedious.

Another way we’ve found is using Inline Edit from Gravity View (speeds up the process a little but still a manual entry by entry process).

But other than Exporting all the data, manipulating it and the RE-Importing all the data to update existing records, I am wondering if it is theoretically (or practically) possible to cause a Form Entry Data Set to ALL be RE-submitted for calculations to be re-calculated at once?

Reply
- Samuel Bassah says
  
  August 25, 2020 at 12:18 pm
  
  Hi Wayne,
  
  Unfortunately, I am not sure if this possible, and the possible workaround solutions I can think of are what you’ve mentioned.
  
  Best,
Ade Ogunade says

August 14, 2020 at 7:53 pm

How can one calculate the total of entries of a for a specific user. I am trying to create closing balances for each user. Each user would have balance = Credit-Debit. But each time i post a transaction for a use, the balance for that user should change. And when i select another use, the balance should change to that of the user. Its like a double ledger entry.

Reply
- Samuel Bassah says
  
  August 15, 2020 at 7:59 am
  
  Hi Ade,
  
  We’ll need an export of your form to get a better understanding of your use case. If you’re a Gravity Perks customer, you can drop us a line via our support form so we can assist you further.
  
  Best,
Seira says

July 2, 2020 at 12:29 am

Thank you for your post!

Is there anyway to show your work in gravity forms? Basically, I just want to show my client the details of the total.

So basic charge is 2,500, 2 product x’s are x2, and 3 product y’s are y2, and the total is the 2,500 + (x2) + (y2).

Reply
- Samuel Bassah says
  
  July 2, 2020 at 5:45 am
  
  Hi Seira,
  
  You could use an HTML Field to display the details of the total calculation on the form.
- Seira says
  
  July 7, 2020 at 4:08 am
  
  Thank you !
Greay says

July 1, 2020 at 1:10 pm

First of all thank you for your post and I have questions about the RSVP form, I have RSVP form ( name, email, phone number, permission ) with limited participants ( max 50 people can join as ) which need one more field to ask ” number of attendees” and they can select from a drop-down “1, 2, 3, 4 or 5 attendees.” After that the form must calculate the number of attendees and if the ‘max 50 people’ are reached then the form will closed automatically. Also I need to display how many participants/attendees are left to join as. Like ” 39 left “. Can you please help us? we are from church and we need it in the difficult Corona period. Thank you in advance.

Reply
- Scott Buchmann says
  
  July 1, 2020 at 1:49 pm
  
  Hi Greay,
  
  This sounds like a good fit for our free Better Inventory snippet. You can use it to limit the quantity of spaces available and show the number of remaining spaces on the page where the form is hosted. It works with Quantity fields, so you can add a Quantity field to your form and set its Field Type to “Drop Down” to let your users select 1-5 attendees.
- Greay says
  
  July 1, 2020 at 2:05 pm
  
  Thank you very much for your fast answer! Can you please tell if I can use this code to different forms in the same time? Thank you in advance
- Ryan Donovan says
  
  July 1, 2020 at 2:19 pm
  
  Hello Greay, We do have a way to use the code with multiple forms. Check out our documentation on how to apply class-based snippets to other forms found here. 😊
- Greay says
  
  July 1, 2020 at 3:09 pm
  Thank you again for the very fast reply! Sorry that my code skills not so good, can you please tell me where do I need to add the code for “Many Different Forms, Same Settings” in WordPress? I saw the original code in gw-gravity-forms-inventory:
  
  public function parse_args( $args ) {
```
    $args = wp_parse_args( $args, array(
        'form_id'                  => false,
        'field_id'                 => false,
        'input_id'                 => false,
        'stock_qty'                => false,
        'out_of_stock_message'     => __( 'Sorry, this item is out of stock.' ),
        'not_enough_stock_message' => __( 'You ordered %1$s of this item but there are only %2$s of this item left.' ),
        'approved_payments_only'   => false,
        'hide_form'                => false,
        'enable_notifications'     => false,
        'field_group'              => array()
    ) );
```
  Do I need to replace it with this:
  
  foreach( array( 1, 2, 3 ) as $form_id ) { new GW_Sample_Class( array( ‘form_id’ => $form_id, ‘target_field_id’ => 7, ‘modifier’ => ‘+1 year’ ) ); }
  
  Thank you again for you great support.
- Scott Buchmann says
  
  July 1, 2020 at 4:42 pm
  
  Hi Great,
  
  You would simply use multiple GW_Inventory classes in your theme’s functions.php file. For example:
  
  new GW_Inventory( array( 'form_id' => 363, 'field_id' => 2.3, 'stock_qty' => 20 ) );
  
  If you have further questions with using the snippet, we offer snippet support for Gravity Perks customers with an Advanced or Pro license.