All Collections
Essential Forms
Configuration and Usage
How to get decimals, commas, 0's and text in numeric fields in forms?
How to get decimals, commas, 0's and text in numeric fields in forms?
Geoff Moore avatar
Written by Geoff Moore
Updated over a week ago

How do I get decimals or cents in numeric fields?

On the Essential Forms main page click, Configure > Preferences, select the Data Fields tab, check the box on the lower portion of the page, Use Decimal Values In Numeric Fields. Click OK. You will need to re-enter your numbers on any forms currently open, but you should see decimals or cents displayed going forward.

Do you have a zeros setting which displays a β€œ0” in numerical fields in which nothing is entered?

No, you will have to manually enter "0" in each field.

Why do I not see commas in number values over a thousand showing up on the screen?

Due to a quirk in the way numeric fields are programmed, commas will not display on-screen, but they are added by default when the form is printed. In the Essential Forms window, if you click Configure > Preferences, and select either the Data Fields tab or the Print Options tab, you can verify that the Print Numeric Data Formatted With Commas box is checked and then click OK.

I need to type text into a numeric field. Is there a way to do this?

If the first character you type is a text character, the field re-formats as a text field. If a number has already been typed, it can be deleted and text then typed in.

I want to change the calculated numeric values in the "Total" or remove the 0's but the program won't let me put the cursor in the field.

On the Essential Forms main page click Configure>Preferences, select the Data Fields tab, uncheck the first box on the lower portion of the page, Perform Automatic Calculations. Click OK. The program should now allow you to put the cursor in the field and edit it.

Did this answer your question?