Possible To Show A Search Form And An Initial Dataset On Page Load?

[ccvortex]

Right now I have my dataset displayed on my website as a 25 row table that uses pagination like normal,  (see: http://www.bangladeshworkersafety.org/factory-information/factory-search ) but I would also like the user to have the ability to search the data as well. Is it possible to have a search form above the table?

 

When creating the dataset I only see the option to have a user searchable database or displayed based upon certain criteria... not both.

 

Thanks.

 

[jonathanr]

Hi ccvortex,

 

To add a search form above a report, you will need to create 2 DataPages.

 

We have an article on Caspio How-to that explain how to build this solution.

http://howto.caspio.com/tech-tips-and-articles/parameters/add-a-search-interface-to-results-sets-page/

 

I hope this help.

 

Regards,
Jonathan

[ccvortex]

I'll chk it out, thx for the link.

[ccvortex]

I see right away a difference between what I have and what is needed for this. The instructions call for creating a data sheet but I already have an existing one. Do I have to use a newely created one or can I use an existing datasheet and then just hook a search data sheet to it?

[MayMusic]

The report needs to be a predefined report, so for the existing one you can check it to be a predefined report and then receive all the search parameters in Configure Filtering Fields screen

[cheonsa]

Hi all,

 

Good news! With the release 15.0, you can now have the search form and results on the same page. 

 

Refer to this link for the other impacted areas: https://howto.caspio.com/release-notes/caspio-bridge-15-0/

 

Regards,

kristina