https://www.machform.com/forums/ MachForm Community Forums Topic: Reset ID number on the forms en Sun, 03 May 2026 23:30:42 +0000 https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-21770 Mon, 15 Sep 2014 19:26:42 +0000 yuniar 21770@https://www.machform.com/forums/ <p>This will work on individual form only. It won't reset all your forms, unless you choose to delete them one by one. </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-21757 Sat, 13 Sep 2014 10:35:40 +0000 darnellsmith 21757@https://www.machform.com/forums/ <p>Does this deleting and resetting of form IDs work for an individual form or across all forms in the database? What if I just want to reset one form back to 1 after deleting all the content? </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14837 Tue, 22 May 2012 20:27:47 +0000 MvdL79 14837@https://www.machform.com/forums/ <p>Thanks man! That worked.</p> <p>* bookmarked for future reference * </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14835 Tue, 22 May 2012 20:02:01 +0000 yuniar 14835@https://www.machform.com/forums/ <p>Try to delete all forms again and then run these queries:</p> <pre><code>DELETE FROM ap_forms; DELETE FROM ap_form_elements; DELETE FROM ap_element_options; DELETE FROM ap_element_prices; ALTER TABLE ap_forms AUTO_INCREMENT = 1;</code></pre> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14831 Tue, 22 May 2012 13:57:21 +0000 MvdL79 14831@https://www.machform.com/forums/ <p>Awesome thanks!</p> <p>//sidenote</p> <p>In (my) version of Machform 3.2 the variable 'MF_CONF_TRUE_DELETE' was already set to 'true' (by default installation).</p> <p>//update</p> <p>I deleted all forms, checked the config file (as mentioned above), but it was set correct and ran the SQL from PhpMyAdmin. It said it worked. Went back to Machform and created a new form, but it starts with ID 2, instead of ID 1...? Any ideas? </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14827 Mon, 21 May 2012 22:55:12 +0000 yuniar 14827@https://www.machform.com/forums/ <p>to reset the ID numbers of the forms, you will also need to do the above modification with config.php file.<br /> set this value:</p> <pre><code>define(&#39;MF_CONF_TRUE_DELETE&#39;,true);</code></pre> <p>then once you have all the forms deleted already, run this SQL query:</p> <pre><code>ALTER TABLE ap_forms AUTO_INCREMENT = 1;</code></pre> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14819 Mon, 21 May 2012 20:01:05 +0000 MvdL79 14819@https://www.machform.com/forums/ <p>And how do you do this with the ID numbers of forms?</p> <p>I deleted all forms, because I was still test driving my forms, but when I create a new form, it will continue with the numbering instead of starting with 1 again.</p> <p>Please explain how to reset this as well. I think, after explaining, it's should be stickied as well. ;) </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14357 Sun, 15 Apr 2012 09:12:42 +0000 Panort 14357@https://www.machform.com/forums/ <p>Thank you very much. I am using V3.1 and so far I like it a lot. Thanks for your quick response. I did what you instructed and it is going back to 1. </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14354 Sat, 14 Apr 2012 11:03:54 +0000 yuniar 14354@https://www.machform.com/forums/ <p>If you are using v3, you don't need to do the above.<br /> So, within v3, by default when you delete any entries they aren't actually being deleted from the table.</p> <p>To disable this functionality, thus deleting the entries permanently, you need to edit your config.php file, search for this line:</p> <pre><code>define(&#39;MF_CONF_TRUE_DELETE&#39;,false);</code></pre> <p>change it to become:</p> <pre><code>define(&#39;MF_CONF_TRUE_DELETE&#39;,true);</code></pre> <p>You can then reset the ID numbers simply by deleting ALL entries.<br /> If you already have empty entries, submit a new entry and then delete the entry by clicking "Select all entries in this form" and hit the delete button.</p> <p>That would delete all entries within that form and reset the ID number.</p> <p><img src="http://farm6.staticflickr.com/5443/7075537437_038b2371dd_o.png" /> </p> https://www.machform.com/forums/topic/reset-id-number-on-the-forms#post-14352 Sat, 14 Apr 2012 10:28:07 +0000 Panort 14352@https://www.machform.com/forums/ <p>I tried this </p> <p>&lt;&lt; To reset entry ID number, you need open PHPMyAdmin. Go to your database and run this SQL<br /> ALTER TABLE ap_form_x AUTO_INCREMENT = 1;<br /> Change "x" with your form id, it should be like this "ap_form_2"&gt;&gt;</p> <p>but it did not work. I had deleted all the entries and then ran the SQL as described above and the ID number did not reset. Any other suggestions?<br /> We use the forms to sign up for different golf days. When that day is over I reuse the form after deleting the names instead of making a new form every week. I would like the ID number to reset so we can see quickly how many have signed up each golf day. </p>