Numeric field not accepting decimals

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.

• This reply was modified 7 years, 6 months ago by xnau webdesign. Reason: oops...meant bigint

Oh, and of course units or dollar signs, etc. won’t be allowed.

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.01

in the “values” parameter. That will set the field to an increments of cents, rather than dollars, and the decimal will be accepted.

• This reply was modified 7 years, 6 months ago by xnau webdesign.

I just published a tutorial on making this kind of change, should be clearer than my posts here.

Setting Up a Currency or Other Decimal-Type Field

Hello,
Thank you so much for making yourself available to support this plugin.
I was able to follow your directions and I made the updates and it’s accepting decimal input now.
Thanks again!
Louanna