https://www.machform.com/forums/ MachForm Community Forums Topic: AUTO INCREMENT FIELD en Wed, 06 May 2026 06:33:03 +0000 https://www.machform.com/forums/topic/auto-increment-field#post-2348 Tue, 15 Jul 2008 07:37:48 +0000 redityo 2348@https://www.machform.com/forums/ <p>is there any error message show in your page? I have try that code on my server and it works fine. can you show me the url of your machform ?</p> <p>or maybe you can send me "view-functions.php" file to customer.service[at]appnitro.com, I will check it for you </p> https://www.machform.com/forums/topic/auto-increment-field#post-2344 Mon, 14 Jul 2008 23:29:12 +0000 dennisturner 2344@https://www.machform.com/forums/ <p>Thanks. I have entered this code and posted to my site. I guess I need to read more about PHP to learn how to implement this information. I put the auto increment field as the first field on my form. But It does not get show on the page with the number. Obviously there is something that I am not doing correctly.</p> <p>I also tried to set a different fields defualt value to: [#{entry_no}]. Since this value would work - I used the format needed for the email setup. This did not work either. </p> https://www.machform.com/forums/topic/auto-increment-field#post-2325 Fri, 11 Jul 2008 11:02:03 +0000 redityo 2325@https://www.machform.com/forums/ <p>Hi .. </p> <p>you can make some modification on "includes/view-functions.php" files to make auto increment value, try to insert this code in line 38 - 39</p> <p>I assume, you want to get auto increment value in form_1 in element_1. You also can make your own invoice number logic to that code :)</p> <pre><code>//get auto increment value $query = &quot;SELECT max(element_1) max_id FROM ap_form_{$_GET[&#39;id&#39;]} &quot;; $result = do_query($query); $autoValue = 1; while($row = do_fetch_result($result)){ $autoValue = $row[&#39;max_id&#39;] + 1; } if ($element-&gt;id == &#39;1&#39; &#38;&#38; $_GET[&#39;id&#39;] == 1 ) $element-&gt;default_value = $autoValue; else $element-&gt;default_value = $element-&gt;default_value;</code></pre> https://www.machform.com/forums/topic/auto-increment-field#post-2322 Fri, 11 Jul 2008 07:14:54 +0000 walags 2322@https://www.machform.com/forums/ <p>you can set the default value of a field to be that of a session variable </p> https://www.machform.com/forums/topic/auto-increment-field#post-2319 Fri, 11 Jul 2008 01:17:06 +0000 dennisturner 2319@https://www.machform.com/forums/ <p>Is there any way to add an auto incrementing numeric field to a form? One that could be used for an invoice number or receipt number. </p>