Enable Number Format

Enable Number Format is the List Field setting of the GravityWP List Number Format add-on that turns a Gravity Forms List Field column into a number column. Use it when visitors enter amounts, quantities or hours in a list and you want every row to hold a valid number, with rounding, a range and a column total.

When the List Field Number Format add-on is activated, you’ll get an extra option when selecting a Gravity Forms List Field.

Turn on number format for a List Field column

1. Open the form in the form editor and select the List Field.
2. For a single-column List Field, check Enable Number Format under Number Format in the field settings.
3. For a List Field with Enable multiple columns checked, check – Enable Number Format below the columns in the Columns setting, for each column that should hold numbers. Other columns stay plain text.
4. Choose the settings described below and save the form.

Settings

• Click on the ‘Enable Number Format‘ checkbox
• You have different options:
  • Number Format: point decimals, comma decimals and Currency.
  • Rounding: Up to 5 numbers after the decimal.
  • Rounding Direction: Round closest, Round up, Round down
  • Range: Define a minimum and maximum number.
  • Enable Range Instructions: When clicked it will show instructions about the minimum and maximum number.
  • Enable Column Total: Will add an extra row at the bottom of your list with the column total calculation.

Single-column and multi-column List Fields have almost the same settings:

Number format

Choose how numbers are written:

• 9,999.99: point as decimal separator, comma as thousands separator.
• 9.999,99: comma as decimal separator, point as thousands separator.
• Currency: the currency set in Forms → Settings.

When a visitor leaves an input, the value is rewritten in the chosen format. You can change the number format only while the form has no entries; after the first entry the dropdown is disabled, with the note “Changing the format is only possible when the form has no entries.”

Rounding and rounding direction

Rounding sets the number of decimals: Do not round, or 0 to 5 decimals. For the Currency format you can choose 0 or 2 decimals.

When you choose a number of decimals, Rounding Direction appears: Round closest, Round up or Round down.

Fixed point notation

Fixed point notation keeps the trailing zeros, so every value shows the same number of decimals. With Rounding set to 2, 5.5 shows as 5.50 and 7 as 7.00.

The option appears when Rounding is set to 1 to 5 decimals and the number format is not Currency.

Range

Enter a Min and a Max value to limit the numbers visitors can enter. Leave one of them empty to set only a lower or an upper limit.

A value outside the range gets a warning below the input as soon as the visitor leaves it, for example “This column cannot be more than 10”. When the form is submitted, the value gets an error message (see “Validation when the form is submitted” below).

Range instructions

Check Enable Range Instructions (single-column List Field) or Enable Instructions (multi-column List Field) to show the range below every input of the column, for example “Please enter a value between 1 and 10.”

Range instructions work with a fixed Min and Max. When Enable Range Calculation is checked, the option is hidden.

Enable Range Calculation

In a multi-column List Field, Enable Range Calculation replaces the fixed Min and Max with a Min Formula and a Max Formula. Each row then gets its own limits, calculated from other columns in the same row.

1. Check Enable Range Calculation for the column.
2. In Min Formula and Max Formula, use Insert Merge Tag to add columns of this List Field, listed as – (Column row value). The dropdown lists columns that have Enable Number Format checked. Use the buttons for +, -, /, *, (, ) and .. You can leave one of the formulas empty.
3. Click Validate Formula to check each formula.

Example: an order list (List Field ID 1) with the columns Product, In stock and Quantity, with Enable Number Format checked for In stock and Quantity. To make sure nobody orders more than the stock, set the Quantity column’s Min Formula to 1 and its Max Formula to:

{Order Items:1.2}

A visitor who enters 12 in a row where In stock is 10 sees “This column cannot be more than 10”.

Enable Range Calculation is not available for single-column List Fields; use a fixed Min and Max there.

Enable Column Total

Enable Column Total adds a total row at the bottom of the list with the sum of the column. The total updates while visitors enter values, and it is also shown in the entry, in merge tag output such as {all_fields} and in Gravity PDF documents.

To use the sum of a column in another field, see Calculation Merge Tags – List Field Calculations.

Enable Calculation

In a multi-column List Field, Enable Calculation turns the column into a calculated column: you enter a Formula with other columns in the same row or other form fields, for example quantity times unit price. The column becomes read-only and is calculated for every row, including rows added later. See Calculation Merge Tags – List Field Calculations for the setup.

Validation when the form is submitted

For number columns with a range (a fixed Min or Max, or range formulas), List Number Format checks every row on the server when the visitor submits the form or goes to the next page. The List Field then gets one of these error messages:

• A value that is not a number in the column’s format: “The column ‘Price’ requires a value in 9,999.00 format.” In a single-column List Field: “Requires a value in 9,999.00 format.” The example number follows the number format and rounding of the column.
• A value outside the range: “The column ‘Quantity’ requires a value between 1 and 10.”, “… greater than or equal to 1.” or “… less than or equal to 10.”

For calculated ranges, the limits are calculated again on the server with the values of the submitted row.

Demo List Field Number Format

Demo

Advanced Merge Tags

Checkbox Images

Radiobutton Images

Star Rating

Ranking

Unique ID

Copycat

Address autocomplete

Autocomplete

GP Limit Dates

Preview Submission

Word Count

Likert Scale

List Field Number Format

Make a choiceEnable Number FormatMerge TagsBoth

Likert Scale

Gravity Forms Survey Field Likert Scale

	Strongly disagree	Disagree	Neutral	Agree	Strongly agree
First row
Second row
Third row
Fourth row
Fifth row

Word Count

Single Line Text

Paragraph Text

Preview Submission

Your name(Required)

GP Limit Dates

Date

Select your date between today and 1 month ahead. You can only select Tuesdays, Wednesdays and Thursdays in this period. That’s what this plugin does, and more. For example you can set fixed dates, ranges from today, etc.

Date +365 days

This date must be exactly 365 days in the future.

Advanced Merge Tags

Text(Required)

Date

Copycat

Field 1

Field 2

Example

Copy Field 1 to Field 3

Example

Copy Field 2 to Field 3

Example

Copy Field 1 to 3 and Field 2 to 4

Field 3

Field 4

Address Autocomplete

Address

Street Address City State / Province / Region ZIP / Postal Code AfghanistanÅland IslandsAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBonaire, Sint Eustatius and SabaBosnia and HerzegovinaBotswanaBouvet IslandBrazilBritish Indian Ocean TerritoryBrunei DarussalamBulgariaBurkina FasoBurundiCabo VerdeCambodiaCameroonCanadaCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos IslandsColombiaComorosCongoCongo, Democratic Republic of theCook IslandsCosta RicaCôte d'IvoireCroatiaCubaCuraçaoCyprusCzechiaDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEswatiniEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHeard Island and McDonald IslandsHoly SeeHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsle of ManIsraelItalyJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKorea, Democratic People's Republic ofKorea, Republic ofKuwaitKyrgyzstanLao People's Democratic RepublicLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacaoMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth MacedoniaNorthern Mariana IslandsNorwayOmanPakistanPalauPalestine, State ofPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarRéunionRomaniaRussian FederationRwandaSaint BarthélemySaint Helena, Ascension and Tristan da CunhaSaint Kitts and NevisSaint LuciaSaint MartinSaint Pierre and MiquelonSaint Vincent and the GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSint MaartenSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth Georgia and the South Sandwich IslandsSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan MayenSwedenSwitzerlandSyria Arab RepublicTaiwanTajikistanTanzania, the United Republic ofThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTürkiyeTurkmenistanTurks and Caicos IslandsTuvaluUgandaUkraineUnited Arab EmiratesUnited KingdomUnited StatesUruguayUS Minor Outlying IslandsUzbekistanVanuatuVenezuelaViet NamVirgin Islands, BritishVirgin Islands, U.S.Wallis and FutunaWestern SaharaYemenZambiaZimbabwe Country

Unique ID

Text

Unique ID Alphanumeric

Unique ID Numeric

Unique ID Sequential

Unique ID Sequential with Text Prefix

Unique ID Random with Text Suffix

Star Rating

Example ranking (order) field

• First Choice
• Second Choice
• Third Choice
• Fourth Choice
• Fifth Choice

Star Rating

Star Rating

ExcellentPretty goodNeutralNot so greatTerrible

Checkbox Images

Checkbox images

Checkbox Images

Radiobutton images

List Field Number Format – Activate Number Format

9,999.99 Number Format

Add Remove

9.999,99 Number Format

Add Remove

Valuta Number Format

Add Remove

---

Rounding

Round up

Round down

 

Add Remove

List Field Number Format – Merge Tags

List single column (Field ID: 1)

Add Remove

Column total

Total number of rows

---

List multiple columns (Field ID: 7)

Quantity

Price

Total

 

Add Remove

Column 1 total

Column 2 total

Column 3 total

Next

Examples Modifiers:

:gwp_remove_accents	{Text:59:gwp_remove_accents}
:gwp_urlencode	{Text:59:gwp_urlencode}
:gwp_length	{Text:59:gwp_length}
:gwp_word_count	{Text:59:gwp_word_count}
:gwp_case to=upper	{Text:59:gwp_case to=upper}
:gwp_case to=lower	{Text:59:gwp_case to=lower}
:gwp_case to=lower_first	{Text:59:gwp_case to=lower_first}
:gwp_case to=upper_first	{Text:59:gwp_case to=upper_first}
:gwp_case to=upper_words	{Text:59:gwp_case to=upper_words}

Examples Merge Tags:

Date Field	{Date:63}
First day of next month
Next Monday
Monday this week

{Your name:72} rules

{Your name:72} on Names.org {Your name:72} on Behind the Name

Previous Submit

Frequently Asked Questions