https://www.machform.com/forums/ MachForm Community Forums Topic: Form List Sort Method en Wed, 06 May 2026 11:05:07 +0000 https://www.machform.com/forums/topic/form-list-sort-method#post-4364 Thu, 22 Jan 2009 11:07:11 +0000 tom472 4364@https://www.machform.com/forums/ <p>What might be helpful to gnioec in reference to his question about sorting by 'date_created' - correct as you mentioned form _id would be the same.<br /> But it sounds like gnioec has his latest created forms as his current ones, so just a reverse on the default sort might do the trick. Like this:<br /> <pre><code>$query = &quot;select form_id,form_name,form_active,form_email from &lt;back&gt;ap_forms&lt;back&gt; order by form_id desc $limit&quot;;</code></pre> <p>Just a thought.</p> <p>--Tom </p> https://www.machform.com/forums/topic/form-list-sort-method#post-4300 Thu, 15 Jan 2009 12:30:35 +0000 yuniar 4300@https://www.machform.com/forums/ <p>Actually, there are other variables, however I don't think the other variables would be relevant for sorting your form (ex: form_description, form_redirect, form_success_message, etc)</p> <p>If you need to sort by date created, then using form_id would have the same effect. form_id is a sequential number. </p> https://www.machform.com/forums/topic/form-list-sort-method#post-4294 Wed, 14 Jan 2009 20:03:25 +0000 gnoiec 4294@https://www.machform.com/forums/ <p>Thank you. That is exactly what I was looking for. One more question though. Am I strictly limited to the variables form_id, name, active, and email? Or are there others? (for example, date_created)</p> <p>Thanks for your help,<br /> Matt </p> https://www.machform.com/forums/topic/form-list-sort-method#post-4185 Thu, 08 Jan 2009 09:35:30 +0000 redityo 4185@https://www.machform.com/forums/ <p>Hi Matt,</p> <p>What order do you need ? by default machform have form list order by form_id. You can change the order by editing "manage_form.php", try to search on line 105 and you will see this code : </p> <pre><code>$query = &quot;select form_id,form_name,form_active,form_email from &lt;back&gt;ap_forms&lt;back&gt; order by form_id asc $limit&quot;;</code></pre> <p>if you want to order by form name you can change it to</p> <pre><code>$query = &quot;select form_id,form_name,form_active,form_email from &lt;back&gt;ap_forms&lt;back&gt; order by form_name asc $limit&quot;;</code></pre> <p>and make sure you've replace &lt;back&gt; tag with backticks character first </p> https://www.machform.com/forums/topic/form-list-sort-method#post-4173 Wed, 07 Jan 2009 20:24:44 +0000 gnoiec 4173@https://www.machform.com/forums/ <p>Is there any way to sort the list of forms that I created? It defaults to the very first form I created (which is no longer active), and I have to go to page 2 to access my current form.</p> <p>Thanks,<br /> Matt </p>