https://www.machform.com/forums/ MachForm Community Forums Topic: How to fix number entry en Sun, 03 May 2026 23:05:43 +0000 https://www.machform.com/forums/topic/how-to-fix-number-entry#post-23618 Mon, 13 Jul 2015 13:31:15 +0000 yuniar 23618@https://www.machform.com/forums/ <p>Yes, by default large numbers are being displayed using scientific notation.<br /> If you need to display the number completely, there is some small adjustment that can be done.</p> <p>Using phpMyAdmin or any other database management tool, go to your MachForm database and run this SQL query:</p> <pre><code>ALTER TABLE ap_form_15032 CHANGE element_20 element_20 DOUBLE(16,0) NULL DEFAULT NULL COMMENT &#39;Number&#39;;</code></pre> <p>The above assume your form id number is 15032 and your number field id is "element_20".<br /> You need to adjust it with your own form id and number field id. </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-23598 Fri, 10 Jul 2015 05:01:41 +0000 kathylinscott 23598@https://www.machform.com/forums/ <p>Any update on this in the last 6 year or way to fix it? I am a little irritated that there was not a warning or guide on the actual form that this was a common error. I set no mins or max so shouldn't I be allowed to have as many numbers as I want? </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-4000 Sat, 13 Dec 2008 05:55:55 +0000 microvb 4000@https://www.machform.com/forums/ <p>Perhaps you can provide a different field type which validates the field as numeric, however passes the information as text. </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-3936 Tue, 09 Dec 2008 09:22:49 +0000 redityo 3936@https://www.machform.com/forums/ <p>Hi,</p> <p>Ron is right !, since you are using number field size it will display exponential number for big number. I suggest to use "single text" field instead of number field .</p> <p>Thank's Ron </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-3935 Tue, 09 Dec 2008 08:47:18 +0000 rmaksood 3935@https://www.machform.com/forums/ <p>Thank you very much Ron for the quick replay. Yes……. I select the field size to large. Still it converts to power of ten. I am going to try as a text field as you recommended. </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-3934 Tue, 09 Dec 2008 08:26:36 +0000 rscott7706 3934@https://www.machform.com/forums/ <p>As an addendum to my note, did you try a number field, but select the "Field Size" "Large"?</p> <p>That may do it.</p> <p>Ron </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-3933 Tue, 09 Dec 2008 08:24:40 +0000 rscott7706 3933@https://www.machform.com/forums/ <p>Just as a user, and not well versed in the program yet, may I suggest that you have a "Number" field here when it may be better to use a "Single Line Text" field.</p> <p>The number field will attempt to display this as a number, and being so large, it converts it to powers of ten.</p> <p>If it doesn't disturb what your trying to do (capture a credit card number), the text field may be better.</p> <p>Ron </p> https://www.machform.com/forums/topic/how-to-fix-number-entry#post-3932 Tue, 09 Dec 2008 07:58:17 +0000 rmaksood 3932@https://www.machform.com/forums/ <p>Hello Yuniar,<br /> Thank you very much for the wonderful program. It is working great other this small problem. Client entered their credit card number and when I went to retrieve, it looks like this 1.24512544568456e+15. Please let me know how I can fix this problem.<br /> Thanks again </p>