November 4, 2019: Fixed notices caused by indirect modification of an overloaded element.
December 10, 2018: Added a proper plugin header.
December 1, 2018: Updated to support Gravity Forms 2.4.
November 19, 2014: Updated to support decimal quantities. Props daniaux!
April 1, 2014: Fixed issue where single product fields with no quantity input were not calculated.
March 17, 2014: Fixed issue where option fields of the radio input type were not included in the generated merge tag string.
November 20, 2013: Fixed issue where "Subtotal" merge tag was not displaying in Formula merge tag drop down until it had been added manually. Thanks to @realph for helping track this bug down.
October 9, 2013: Fixed issue where checkbox option fields with ten or more inputs were not being calculated correctly.
September 12, 2013: Fixed issue with Single Product fields when the "Disable Quantity" option was enabled.
September 11, 2013: Fixed issue where checkbox option fields were not correctly calculated.
Stop! There's a better way.
This snippet is available as a plugin with Gravity Perks, a suite of over 32 premium Gravity Forms plugins!
| <?php | |
| /** | |
| * --- STOP! --- | |
| * Get the latest version: | |
| * https://gravitywiz.com/documentation/gravity-forms-ecommerce-fields/ | |
| * ------------- | |
| * | |
| * Calculation Subtotal Merge Tag | |
| * | |
| * Adds a {subtotal} merge tag which calculates the subtotal of the form. | |
| * | |
| * This merge tag can only be used within the "Formula" setting of Calculation-enabled fields (i.e. Number, Calculated Product). | |
| * | |
| * @version 1.3 | |
| * @author David Smith <david@gravitywiz.com> | |
| * @license GPL-2.0+ | |
| * @link http://gravitywiz.com/subtotal-merge-tag-for-calculations/ | |
| * @copyright 2018 Gravity Wiz | |
| * | |
| * Plugin Name: Gravity Forms Subtotal Merge Tag | |
| * Plugin URI: https://gravitywiz.com/subtotal-merge-tag-for-calculations/ | |
| * Description: Adds a {subtotal} merge tag which calculates the subtotal of the form. | |
| * Author: Gravity Wiz | |
| * Version: 1.3 | |
| * Author URI: http://gravitywiz.com | |
| */ | |
| class GWCalcSubtotal { | |
| public static $merge_tag = '{subtotal}'; | |
| function __construct() { | |
| // front-end | |
| add_filter( 'gform_pre_render', array( $this, 'maybe_replace_subtotal_merge_tag' ) ); | |
| add_filter( 'gform_pre_validation', array( $this, 'maybe_replace_subtotal_merge_tag_submission' ) ); | |
| // back-end | |
| add_filter( 'gform_admin_pre_render', array( $this, 'add_merge_tags' ) ); | |
| } | |
| /** | |
| * Look for {subtotal} merge tag in form fields 'calculationFormula' property. If found, replace with the | |
| * aggregated subtotal merge tag string. | |
| * | |
| * @param mixed $form | |
| */ | |
| function maybe_replace_subtotal_merge_tag( $form, $filter_tags = false ) { | |
| foreach( $form['fields'] as &$field ) { | |
| if( current_filter() == 'gform_pre_render' && rgar( $field, 'origCalculationFormula' ) ) | |
| $field['calculationFormula'] = $field['origCalculationFormula']; | |
| if( ! self::has_subtotal_merge_tag( $field ) ) | |
| continue; | |
| $subtotal_merge_tags = self::get_subtotal_merge_tag_string( $form, $field, $filter_tags ); | |
| $field['origCalculationFormula'] = $field['calculationFormula']; | |
| $field['calculationFormula'] = str_replace( self::$merge_tag, $subtotal_merge_tags, $field['calculationFormula'] ); | |
| } | |
| return $form; | |
| } | |
| function maybe_replace_subtotal_merge_tag_submission( $form ) { | |
| return $this->maybe_replace_subtotal_merge_tag( $form, true ); | |
| } | |
| /** | |
| * Get all the pricing fields on the form, get their corresponding merge tags and aggregate them into a formula that | |
| * will yeild the form's subtotal. | |
| * | |
| * @param mixed $form | |
| */ | |
| static function get_subtotal_merge_tag_string( $form, $current_field, $filter_tags = false ) { | |
| $pricing_fields = self::get_pricing_fields( $form ); | |
| $product_tag_groups = array(); | |
| foreach( $pricing_fields['products'] as $product ) { | |
| $product_field = rgar( $product, 'product' ); | |
| $option_fields = rgar( $product, 'options' ); | |
| $quantity_field = rgar( $product, 'quantity' ); | |
| // do not include current field in subtotal | |
| if( $product_field['id'] == $current_field['id'] ) | |
| continue; | |
| $product_tags = GFCommon::get_field_merge_tags( $product_field ); | |
| $quantity_tag = 1; | |
| // if a single product type, only get the "price" merge tag | |
| if( in_array( GFFormsModel::get_input_type( $product_field ), array( 'singleproduct', 'calculation', 'hiddenproduct' ) ) ) { | |
| // single products provide quantity merge tag | |
| if( empty( $quantity_field ) && ! rgar( $product_field, 'disableQuantity' ) ) | |
| $quantity_tag = $product_tags[2]['tag']; | |
| $product_tags = array( $product_tags[1] ); | |
| } | |
| // if quantity field is provided for product, get merge tag | |
| if( ! empty( $quantity_field ) ) { | |
| $quantity_tag = GFCommon::get_field_merge_tags( $quantity_field ); | |
| $quantity_tag = $quantity_tag[0]['tag']; | |
| } | |
| if( $filter_tags && ! self::has_valid_quantity( $quantity_tag ) ) | |
| continue; | |
| $product_tags = wp_list_pluck( $product_tags, 'tag' ); | |
| $option_tags = array(); | |
| foreach( $option_fields as $option_field ) { | |
| if( is_array( $option_field['inputs'] ) ) { | |
| $choice_number = 1; | |
| $inputs = $option_field->inputs; | |
| foreach( $inputs as &$input ) { | |
| //hack to skip numbers ending in 0. so that 5.1 doesn't conflict with 5.10 | |
| if( $choice_number % 10 == 0 ) | |
| $choice_number++; | |
| $input['id'] = $option_field['id'] . '.' . $choice_number++; | |
| } | |
| $option_field->inputs = $inputs; | |
| } | |
| $new_options_tags = GFCommon::get_field_merge_tags( $option_field ); | |
| if( ! is_array( $new_options_tags ) ) | |
| continue; | |
| if( GFFormsModel::get_input_type( $option_field ) == 'checkbox' ) | |
| array_shift( $new_options_tags ); | |
| $option_tags = array_merge( $option_tags, $new_options_tags ); | |
| } | |
| $option_tags = wp_list_pluck( $option_tags, 'tag' ); | |
| $product_tag_groups[] = '( ( ' . implode( ' + ', array_merge( $product_tags, $option_tags ) ) . ' ) * ' . $quantity_tag . ' )'; | |
| } | |
| $shipping_tag = 0; | |
| /* Shipping should not be included in subtotal, correct? | |
| if( rgar( $pricing_fields, 'shipping' ) ) { | |
| $shipping_tag = GFCommon::get_field_merge_tags( rgars( $pricing_fields, 'shipping/0' ) ); | |
| $shipping_tag = $shipping_tag[0]['tag']; | |
| }*/ | |
| $pricing_tag_string = '( ( ' . implode( ' + ', $product_tag_groups ) . ' ) + ' . $shipping_tag . ' )'; | |
| return $pricing_tag_string; | |
| } | |
| /** | |
| * Get all pricing fields from a given form object grouped by product and shipping with options nested under their | |
| * respective products. | |
| * | |
| * @param mixed $form | |
| */ | |
| static function get_pricing_fields( $form ) { | |
| $product_fields = array(); | |
| foreach( $form["fields"] as $field ) { | |
| if( $field["type"] != 'product' ) | |
| continue; | |
| $option_fields = GFCommon::get_product_fields_by_type($form, array("option"), $field['id'] ); | |
| // can only have 1 quantity field | |
| $quantity_field = GFCommon::get_product_fields_by_type( $form, array("quantity"), $field['id'] ); | |
| $quantity_field = rgar( $quantity_field, 0 ); | |
| $product_fields[] = array( | |
| 'product' => $field, | |
| 'options' => $option_fields, | |
| 'quantity' => $quantity_field | |
| ); | |
| } | |
| $shipping_field = GFCommon::get_fields_by_type($form, array("shipping")); | |
| return array( "products" => $product_fields, "shipping" => $shipping_field ); | |
| } | |
| static function has_valid_quantity( $quantity_tag ) { | |
| if( is_numeric( $quantity_tag ) ) { | |
| $qty_value = $quantity_tag; | |
| } else { | |
| // extract qty input ID from the merge tag | |
| preg_match_all( '/{[^{]*?:(\d+(\.\d+)?)(:(.*?))?}/mi', $quantity_tag, $matches, PREG_SET_ORDER ); | |
| $qty_input_id = rgars( $matches, '0/1' ); | |
| $qty_value = rgpost( 'input_' . str_replace( '.', '_', $qty_input_id ) ); | |
| } | |
| return floatval( $qty_value ) > 0; | |
| } | |
| function add_merge_tags( $form ) { | |
| $label = __('Subtotal', 'gravityforms'); | |
| ?> | |
| <script type="text/javascript"> | |
| // for the future (not yet supported for calc field) | |
| gform.addFilter("gform_merge_tags", "gwcs_add_merge_tags"); | |
| function gwcs_add_merge_tags( mergeTags, elementId, hideAllFields, excludeFieldTypes, isPrepop, option ) { | |
| mergeTags["pricing"].tags.push({ tag: '<?php echo self::$merge_tag; ?>', label: '<?php echo $label; ?>' }); | |
| return mergeTags; | |
| } | |
| // hacky, but only temporary | |
| jQuery(document).ready(function($){ | |
| var calcMergeTagSelect = $('#field_calculation_formula_variable_select'); | |
| calcMergeTagSelect.find('optgroup').eq(0).append( '<option value="<?php echo self::$merge_tag; ?>"><?php echo $label; ?></option>' ); | |
| }); | |
| </script> | |
| <?php | |
| //return the form object from the php hook | |
| return $form; | |
| } | |
| static function has_subtotal_merge_tag( $field ) { | |
| // check if form is passed | |
| if( isset( $field['fields'] ) && is_array( $field['fields'] ) ) { | |
| $form = $field; | |
| foreach( $form['fields'] as $field ) { | |
| if( self::has_subtotal_merge_tag( $field ) ) | |
| return true; | |
| } | |
| } else { | |
| if( isset( $field['calculationFormula'] ) && strpos( $field['calculationFormula'], self::$merge_tag ) !== false ) | |
| return true; | |
| } | |
| return false; | |
| } | |
| } | |
| new GWCalcSubtotal(); |
Currently, there is no easy way to get the current total (let’s call it the subtotal) of the form for use in calculations. It’s possible but you’ll have to enter all of your product merge tags into a long and complicated formula to get the subtotal.
This snippet helps you avoid that hassle by providing a {subtotal} merge tag for use in your Gravity Form calculations.
{subtotal} merge tag is only available in fields that support calculations.How do I install this snippet?
Easy peasy. Just copy and paste the code above into your theme's functions.php file.
How do I use this functionality?
This snippet will add a new “Subtotal” merge tag to the merge tag select available for the “Formula” setting on Calculation fields. Selecting this option will insert the {subtotal} merge tag into your “Formula” setting. You can then use all available mathematical operations available to this field to manipulate this subtotal as needed.
Formula Setting: Subtotal Merge Tag
Formula Setting: Subtotal Used to Calculate TaxDid this resource help you do something awesome with Gravity Forms? Then you'll absolutely love Gravity Perks; a suite of 31+ essential add-ons for Gravity Forms with support you can count on.
Thanks for this,
trying to achieve the following:
Calculation: {subtotal} *0.15. (Add tax to product price). – WORKS PERFECT
Calculation 2: {subtotal} *0.025 (Add credit card fee). – HAVING PROBLEMS
TOTAL PRICE:
Problem is ‘calculation 2’ changes the subtotal which then makes it incorrect for calculation 1.
Any ideas how I can achieve this?
Thanks for your help.
Hey Michael, Looks like you are running into an issue with using two subtotal merge tags. Currently what is happening is the first calculation is running then replacing the subtotal with the new calculated subtotal. When you get to the next calculation it will now use the new subtotal in this calculation. You can accomplish this the easy way by getting Gravity Forms eCommerce Fields or you could actually reserve a subtotal field with just the {subtotal} merge tag, then use that fields price to create a new field with calculations that uses the new subtotal fields price merge tag ({Subtotal (Price):3.2}) to calculate the tax and fee. If you are still having issues after using the modifier this way, could you please drop us a support request. :)
I’m not having much luck getting this to work. I have a multi-page form with products on a few pages but the total for my calculation field is zero.
never mind. It was a formula error. Thanks for always being so awesome. Love you’re site and your code snippets.
Hello Dave,
Happy that you were able to get the calculation on your total form to work. Have a great day! :)
Can I able to use IF ELSE condition in merge tag calculation .please help me how we can do this. I am doing like below but it is not working for me. if($ 1-Year:90:48.88) 58.56 else 4.88
Gravity Forms doesn’t support if/else conditions in merge tags, but it does support conditional logic for number field. You could add conditional logic to a Product field and show/hide it based on the results of a calculation in a hidden number field.
You are great person, Thank you so much
❤️