Hey,
I was just wondering why my forms will not let me enter decimal points? Is this a chronoforms issue, or a database issue? I tried to enter the number 2.5 into my form which works, when I use regular integers without decimal places. Any ideas?
I was just wondering why my forms will not let me enter decimal points? Is this a chronoforms issue, or a database issue? I tried to enter the number 2.5 into my form which works, when I use regular integers without decimal places. Any ideas?
Hi Jeff,
You probably need a decimal field in the database, ChronoForms only offers Integer field types so this will need a bit of hand tweaking.
Bob
You probably need a decimal field in the database, ChronoForms only offers Integer field types so this will need a bit of hand tweaking.
Bob
Hand tweaking of the code, or in the database? Because I did try change the database of the hours field to a decimal field and it did not seem to work.
Hi Jeff,
I was thinking of the database, probably needs something like a DECIMAL[6,2] i.e. 9999.99 max. As an alternative you could tweak the code to multiply the submission by 100, store as an integer and divide by 100 when you display.
Bob<br><br>Post edited by: GreyHead, at: 2007/12/04 17:34
I was thinking of the database, probably needs something like a DECIMAL[6,2] i.e. 9999.99 max. As an alternative you could tweak the code to multiply the submission by 100, store as an integer and divide by 100 when you display.
Bob<br><br>Post edited by: GreyHead, at: 2007/12/04 17:34
This topic is locked and no more replies can be posted.
