https://www.machform.com/forums/ MachForm Community Forums Topic: Number Field Converting Number Entered en Mon, 04 May 2026 02:52:42 +0000 https://www.machform.com/forums/topic/number-field-converting-number-entered#post-24084 Thu, 17 Sep 2015 08:29:43 +0000 atypicalv 24084@https://www.machform.com/forums/ <p>Found this answer in another area, this solution works for anyone else with this issue:</p> <p>Yes, by default large numbers are being displayed using scientific notation. 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> <p>ALTER TABLE ap_form_15032 CHANGE element_20 element_20 DOUBLE(16,0) NULL DEFAULT NULL COMMENT 'Number';</p> <p>The above assume your form id number is 15032 and your number field id is "element_20". You need to adjust it with your own form id and number field id. </p> https://www.machform.com/forums/topic/number-field-converting-number-entered#post-24064 Tue, 15 Sep 2015 05:49:16 +0000 atypicalv 24064@https://www.machform.com/forums/ <p>Greetings. Having a strange issue with a form that was working fine, but is now changing the number input into a number field.</p> <p>On the form, the field is set as a number field to collect cc numbers, limited to 15-16 digits. When a 16 digit number is entered (such as Visa/MC), the number is converted when you click continue and go to the preview screen before submitting the form. The format it changes to is like such: 4.80213990221813e+15</p> <p>With Amex numbers (15 digit) it does not change them, and the form was working fine until recently. Have not made any changes to the form or code.</p> <p>MachForm 4.3. Any help is appreciated, thanks. </p>