https://www.machform.com/forums/ MachForm Community Forums Topic: Search facility en Mon, 04 May 2026 03:35:45 +0000 https://www.machform.com/forums/topic/search-facility#post-3316 Thu, 16 Oct 2008 20:48:06 +0000 gordonm 3316@https://www.machform.com/forums/ <p>Hi Yuniar</p> <p>Thanks, I will give that a go. </p> https://www.machform.com/forums/topic/search-facility#post-3312 Thu, 16 Oct 2008 12:52:16 +0000 yuniar 3312@https://www.machform.com/forums/ <p>Ah I see.</p> <p>Basically, you will need to write a search query which pull data from your <strong>ap_form_x</strong> table.</p> <p>Let say your person name and date fields are saved as "element_1" and "element_2" on the table.</p> <p>Then your search query would be something like this:</p> <pre><code>SELECT * FROM AP_FORM_3 WHERE element_1 like &#39;%keyword1%&#39; or element_2 like &#39;%keyword2&#39;;</code></pre> <p>That's the main query you will need to use. The rest you will need to build the search page along with the search box. </p> https://www.machform.com/forums/topic/search-facility#post-3303 Wed, 15 Oct 2008 17:14:10 +0000 gordonm 3303@https://www.machform.com/forums/ <p>Hi Yuniar</p> <p>Its would be a search on persons name and date only. I think I would be best creating a separate form tbh. </p> https://www.machform.com/forums/topic/search-facility#post-3293 Tue, 14 Oct 2008 15:19:53 +0000 yuniar 3293@https://www.machform.com/forums/ <p>This one would be pretty hard to answer. It depends on the complexity of your search functionality. But generally, it took quite some work indeed. </p> https://www.machform.com/forums/topic/search-facility#post-3283 Sun, 12 Oct 2008 03:25:18 +0000 gordonm 3283@https://www.machform.com/forums/ <p>How hard would it be to add a search facility to the forms? </p>