https://www.machform.com/forums/ MachForm Community Forums Topic: Can I start first entry_no at a number higher than 1? en Mon, 04 May 2026 01:29:53 +0000 https://www.machform.com/forums/topic/can-i-start-first-entry_no-at-a-number-higher-than-1#post-7214 Sun, 06 Sep 2009 10:02:08 +0000 philm 7214@https://www.machform.com/forums/ <p>no worries, I've fixed it </p> https://www.machform.com/forums/topic/can-i-start-first-entry_no-at-a-number-higher-than-1#post-7209 Sat, 05 Sep 2009 14:20:34 +0000 philm 7209@https://www.machform.com/forums/ <p>Hi,<br /> I'm trying to do a similar thing a I would like the form ID to be a membership number starting from 500. I've tried changing this through phpmyadmin. The field is auto increment but I cannot set a default value. Do I need to change something in the machform files to start the count from 5000?<br /> Thanks </p> https://www.machform.com/forums/topic/can-i-start-first-entry_no-at-a-number-higher-than-1#post-4568 Sat, 07 Feb 2009 00:12:19 +0000 redityo 4568@https://www.machform.com/forums/ <p>Hi Phil,</p> <p>Since entry_no in machform use auto increment field type, I think easy way to change the number with altering the table on your machform database. You can use this query :</p> <pre><code>ALTER TABLE ap_form_x AUTO_INCREMENT = 1000;</code></pre> <p>Where x is your form id, for example you have form id = 5, so the query should be like this :</p> <pre><code>ALTER TABLE ap_form_5 AUTO_INCREMENT = 1000;</code></pre> <p>to do this make sure you've backup your data first </p> https://www.machform.com/forums/topic/can-i-start-first-entry_no-at-a-number-higher-than-1#post-4566 Fri, 06 Feb 2009 23:05:42 +0000 philwareham 4566@https://www.machform.com/forums/ <p>Is there an easy way to make the first entry number sent to the form database to start at a numerical value of #1000, instead of just the default #1? Hope that makes sense!<br /> Cheers,<br /> Phil </p>