Numeric field not accepting decimals
-
We are trying to enter dollars/cents and decimals, for example, .5 – into the numeric field with no success. It keeps saying, “enter a valid value.”
I’m sure I am missing something obvious. Any help would be appreciated!
Thank you!
Louanna
-
Yes, that’s correct, numeric fields are generally for integers only. If you want to change the numeric format that the field accepts, you need to modify the database directly, using phpMyAdmin or similar. Change the datatype of the field from BIGINT to DECIMAL (4,2) …the first digit is the number pf places before the decimal point, so set that as needed.
OH, and one more thing (I really gotta write this up as a tutorial!) you will want to give your numeric field a “step” attribute. In the manage database fields page, in the definition for your field where you want dollars and cents, put
step::0.01in the “values” parameter. That will set the field to an increments of cents, rather than dollars, and the decimal will be accepted.
The topic ‘Numeric field not accepting decimals’ is closed to new replies.
