Multiple Search Fields

[wdandrewsshpg]

Hi All,

Is it possible to set up multiple search fields as a parameter for one field and display all results from those that match? 

Thanks! Bill

[sandy159]

Hi @wdandrewsshpg,

If I understand you correctly, you are talking about the Keyword Search across multiple fields. You may check the article on how it can be implemented:
https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/

Feel free to update this thread if you were looking for something else or if you have questions. 

Regards

[wdandrewsshpg]

Hi Sandy, Thank You! No that is not what I was asking for, but your answer to another user about setting up multiple criteria fields was exactly what I needed. Thank You!
Bill

[cheonsa]

Hello!

Just to provide more details on this, adding criteria to the Results Search Form can allow field to accept multiple values. 

 

[BenjaminS]

I have followed the above mentioned HowTo (to be precise, I followed a more detailed description at https://someapp.com/np/apps/workflow/single_search_field.html). However, I am using URL deployment, so I deployed the Submission form as an iframe in the header (as described here https://howto.caspio.com/tech-tips-and-articles/results-and-details-on-two-separate-web-pages/).

It works in principle, but ...

1) I need to refresh the browser after clicking search in order to show the results.

2) The second (and any additional) search acts as an AND search, i.e., it will only search within the results and it will further narrow the results; to make a new search, first an empty search must be made (click search with empty search box) to return the results to original state.

In other words, it is a half baked solution.

I have two questions. Is the described behaviour the same if the two DataPages are deployed on a webpage? And more importantly, does anyone have any tips on how to make the URL deployment solution to behave properly?

Thanks guys

Benjamin

[Tubby]

On 4/25/2023 at 8:45 AM, BenjaminS said:

I have followed the above mentioned HowTo (to be precise, I followed a more detailed description at https://someapp.com/np/apps/workflow/single_search_field.html). However, I am using URL deployment, so I deployed the Submission form as an iframe in the header (as described here https://howto.caspio.com/tech-tips-and-articles/results-and-details-on-two-separate-web-pages/).

It works in principle, but ...

1) I need to refresh the browser after clicking search in order to show the results.

2) The second (and any additional) search acts as an AND search, i.e., it will only search within the results and it will further narrow the results; to make a new search, first an empty search must be made (click search with empty search box) to return the results to original state.

In other words, it is a half baked solution.

I have two questions. Is the described behaviour the same if the two DataPages are deployed on a webpage? And more importantly, does anyone have any tips on how to make the URL deployment solution to behave properly?

Thanks guys

Benjamin

For your second item, I think a way around that is to reset the parameters in the deployment URL of the DataPage so it removes the values passed by the previous search before applying the new filters: https://howto.caspio.com/parameters/resetting-parameters/

I'm not sure about the 1st problem though with preventing the other DataPages inside the web page from reloading but maybe this helps: https://stackoverflow.com/questions/17886578/refresh-part-of-page-div