GravityWP – Count

Yes, you need to install the Gravity Forms Plugin for this plugin to work.

Yes, you can use GFCharts to make calculations instead. It’s easy to make the same calculations with GFCharts and you can easily use JavaScript to change the output format or number value. Download GFCharts here (affiliate link)

Thanks to the wonderful support of GravityView (affiliate link) we also added a filter for approval status:

[gravitywp_count formid="2" number_field="4" is_approved="yes"]

is_approved: Do you want to count only for the approved entries in GravityView? Or only the entries that are not approved? Add is_approved=”yes” or is_approved=”no” to your shortcode attributes.

Yes, Gravity Flow (affiliate link) is also supported. To simply show the number of entries that are at a specific Gravity Flow step, use this shortcode:

[gravitywp_count formid="2" workflow_step="5"]

You have to use the workflow step ID to filter the number of entries that are currently pending on that step. You can use the GravityWP – Merge Tags plugin to easily find the ID (or even the shortcode to use). The plugin will provide a page with all the details of Gravity Flow steps for every form, including the shortcode to use.

Or, the more difficult variant, you can open the step you want to filter on and check the url. It will be something like this:

gravitywp.com/wp-admin/admin.php?page=gf_edit_forms&view=settings&subview=gravityflow&id=2&fid=5

The last number in the url (the ‘fid=5’) shows the ID of the workflow step.

workflow_step: Fill in the workflow step ID here to use as a filter.
workflow_step_status: This is a comma seperated string. You can use one or both of the following options: pending,complete.
workflow_step_is_current: this can be set to true or false. If set to false, it will count everything that is in workflow steps after the selected workflow_step (including the selected workflow_step).

GravityWP Count won’t work without extra code when you use the Gravity Encryption plugin on your site

If you only want to show the total entries or the count of a number field for the currently logged-in user, you can use

created_by="current"

Here you find the shortcodes to count the total of entries (with or without filters). You will notice that you don’t have to fill in decimals or decimal points, because these shortcodes only count the total of entries (which is always a whole number). It is possible to define a thousand seperator.

[gravitywp_count formid="2" thousands_sep=","]

or use the default (thousand separator is a comma):

[gravitywp_count formid="2"]

formid: This is the id of the form you want to target your shortcode at. It’s in orange. This will also accept a comma-seperated array of form id’s.
thousands_sep: The thousands seperator is to, what it says, the notation you use to seperate thousands. In the USA this is a comma, in Europa this is a point. For example a million in USA is: 1,000,000.00 and in Europe it is: 1.000.000,00. You can define the thousands seperator in the shortcode.

You can use filters to only show the calculations you want (based on fields in the form). To use one filter, use this shortcode:

[gravitywp_count formid="2" filter_field="3" filter_value="IT developer" thousands_sep="," ]

filter_field: this is the Field ID you want to use in your filter. Go to your Gravity Form, go to the Field (text, dropdown, radio button) you want to use as your filter and write down the Field ID number to use in filter_field in your shortcode.
filter_value: write here the exact value that is in your text, radio button or dropdown. If you clicked ‘show values’, use the text under Value (don’t use the label).

With 2 filters

[gravitywp_count formid="2" filter_field="3" filter_value="IT developer" filter_field2="5" filter_value2="41 and older" thousands_sep="," ]

filter_field2: this is the Field ID you want to use in your second filter.
filter_operator2: an optional comparison operator, possible values: =, is, contains, is not, isnot, <>, like, not in, notin, or in. Defaults to =.
filter_value2: write here the exact value that is in your text, radio button or dropdown (for the second filter!). If you clicked ‘show values’, use the text under Value.

You can use up to 5 filters.

Here you find the shortcodes you can use to calculate the totals of number fields in multiple Gravity Forms entries.

Count and display a number field calculation (without filters):
If you want to retrieve the total sum of the values of a number field from multiple entries, use this shortcode:

[gravitywp_count formid="2" number_field="4" decimals="2" dec_point="." thousands_sep="," ]

or use the default shortcode (2 decimals, dec_point =”.” and thousands_sep=”,”):

[gravitywp_count formid="2" number_field="4"]

number_field: This is the ID of the number field you want to target. Make sure this is a number field!
decimals: This is how many decimals you want to show (after the point (if you are in the US or England) or after the comma (if you are in Europe or the rest of the world)). You can type 0 (zero) if you only want to show whole numbers. You can type 1, 2, 3, 4 or 10 or more to show more decimal numbers.
dec_point: This is what decimal point you want to use. In the USA and England this is a point. In Europe, the comma is used to show the decimal point. For example: USA: 1.23 and Europe: 1,23.

If you want to use the Count Plugin and filter on 1 field (text, dropdown, radio button), use this shortcode:

[gravitywp_count formid="2" number_field="4" filter_field="3" filter_value="IT developer" decimals="2" dec_point="." thousands_sep="," ]

Two filter fields:
If you want to use the Count Plugin and filter on 2 fields (text, dropdown, radio button), use this shortcode:

[gravitywp_count formid="2" number_field="4" filter_field="3" filter_value="IT developer" filter_field2="5" filter_value2="41 and older" decimals="2" dec_point="." thousands_sep="," ]

You can pass in multiple form id’s as an array, like so:
[gravitywp_count formid=”1,2,3″]

It is also possible to apply filters to this.

Yes, this is possible. You can pass in a relative date in the parameters start_date and end_date.
Visit https://www.php.net/manual/en/datetime.formats.relative.php for a list of possible date formats.

For Product Fields, we advice you to use ‘contains’ as a filter_operator. The reason is that the product name and the price are stored together in the database, seperated by a pipe symbol.
Eg. a field has a product name ‘Produkt A’ with a price of ‘$10’. This is stored as ‘Produkt A|$10’. You have to enter the precise value to get the correct results.
With ‘contains’ you have the option to only enter (a part of) the product name, or the price as a value.

Yes, you can use the following data to filter the results:

Filter hook is named ‘gwp_count_result’. Followed by the callback function which holds 3 arguments:
1: $formatted_value, the default output value of the count.
2: $raw_value, the raw unformatted output value of the count.
3: $formids, an array with the ID’s of the coounted forms.

Example: For form with ID 1, unformatted values are compared with the number 10. Values lower than 10 are returned as formatted and in a red styling.
When the value is 10 or higher, the formatted value is returned without a styling.

add_filter(
    'gwp_count_result',
    function( $formatted_value, $raw_value, $formids ) {

        if ( $raw_value < 10 && $formids['0'] === '1' ) {
            return '<span style="color:red;">' . $formatted_value . '</span>';
        } else {
            return $formatted_value;
        }
    },
    10,
    3
);