Add-on: List Number Format
GravityWP List Number Format is a Gravity Forms add-on that turns List Field columns into number columns. Use it for order lines, expenses, hours or any other list of numbers: you choose the number format and rounding, limit values to a range, calculate a column from other columns in the row, show column totals and use column sums and row counts in other calculations.
What you can do with List Number Format
- Number format per column: point decimals (9,999.99), comma decimals (9.999,99) or currency, in single-column and multi-column List Fields. Other columns stay plain text.
- Rounding: up to 5 decimals, rounded closest, up or down, with Fixed point notation to keep trailing zeros.
- Range: a fixed minimum and maximum, or in multi-column List Fields a Min Formula and Max Formula based on other columns in the same row.
- Column totals: a total row at the bottom of the list, also shown in the entry, in
{all_fields}and in Gravity PDF documents. - Row calculations: a read-only column calculated with a formula, for example quantity times unit price.
- Calculation merge tags:
{List:1.2}for the sum of column 2 and{List:1}for the number of rows, in Number field formulas. Gravity Forms calculates them again on submit, so payment add-ons such as Stripe get the correct amount.
Get started
- Install and activate List Number Format, and activate your license.
- Open a form in the Gravity Forms form editor and add or select a List Field.
- Check Enable Number Format for the List Field, or for each column of a multi-column List Field.
- Choose the number format, rounding, range and column total, and save the form.
Documentation
- Enable Number Format: all settings of a number column, including Fixed point notation, Enable Range Calculation, range instructions and validation on submit.
- Calculation Merge Tags – List Field Calculations: calculated columns per row, column sums and row counts in Number field formulas, and calculations on submit.
- Compatibility with Other Plugins: GP Populate Anything, GP Nested Forms, GravityView Edit Entry, Gravity PDF, payment add-ons, GravityWP List Dropdown and Field to Entries.
- Developer Hooks: JavaScript filters and actions, the init function and PHP filters.
Requirements
- Gravity Forms 2.4.24.1 or later
- PHP 7.0 or later
Frequently Asked Questions
Yes. You enable number formatting per column, so a List Field can mix number columns with plain text columns.
Only while the form has no entries; after the first entry the Number Format setting is disabled.
Yes. Use a merge tag such as {List:1.2} in a Number field formula to get the sum of column 2 of List Field 1, or {List:1} for the number of rows.
Calculation Merge Tags – List Field Calculations
How to calculate with Gravity Forms List Field columns in List Number Format: calculated columns per row, column sums and row counts in Number field formulas, and calculations on submit.
Compatibility with Other Plugins
Which plugins List Number Format works with: GP Populate Anything, GP Nested Forms, GravityView Edit Entry, Gravity PDF, payment add-ons, GravityWP List Dropdown and Field to Entries, and the Gravity Forms entry editor.
Developer Hooks
JavaScript filters and actions, the re-initialization function and PHP filters of List Number Format, with their parameters and examples.
Enable Number Format
Turn a Gravity Forms List Field column into a number column: number format, rounding and direction, fixed point notation, fixed or calculated range, range instructions, column total and calculation.