MachForm Community Forums » MachForm 2

1. gordonm
   Member

   How hard would it be to add a search facility to the forms?

   Posted 16 years ago #
2. 

   yuniar

   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.

   ---

   MachForm Founder

   Posted 16 years ago #

3. gordonm
   Member

   Hi Yuniar

   Its would be a search on persons name and date only. I think I would be best creating a separate form tbh.

   Posted 16 years ago #
4. 

   yuniar

   Ah I see.

   Basically, you will need to write a search query which pull data from your ap_form_x table.

   Let say your person name and date fields are saved as "element_1" and "element_2" on the table.

   Then your search query would be something like this:

   SELECT * FROM AP_FORM_3 WHERE element_1 like '%keyword1%' or element_2 like '%keyword2';

   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.

   ---

   MachForm Founder

   Posted 16 years ago #

5. gordonm
   Member

   Hi Yuniar

   Thanks, I will give that a go.

   Posted 16 years ago #

RSS feed for this topic

Reply

You must log in to post.