Search using 'Any' or Blank values

[Kuroshi]

 Hi. I am trying to build a search form that will allow me to search 'Any' and display all the records and search 'Blank' records as well. Is there a needed criteria for this?  Thanks. 
 

[Barbie]

Ho @Kuroshithe workaround that I can suggest is creating multiple DataPages and filtering them based on your criteria. Then on your search dropdown options, you can configure it to be dynamically redirected to *9the filtered DataPages based on criteria.

Hope this helps.

[Barbie]

By the way, you may refer to this article for more information: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/

 

Thanks.

[Barbie]

Hello @Kuroshi,

I have tried checking for another workaround. And here are the steps:
you may need to use criteria in your Search page fields. The check box would be the first criterion. If this box is checked, it will only show blank values. If not, it will show you all of the results. Please refer to these sample screenshots:
1. Add criteria to the field:

2. On the criteria 1, set it as a checkbox and make the 'Comparison type' to 'Is Blank':
3. Lastly, on the second criteria, set it as a dropdown and add 'Any' as an option in the 'Custom Values'. Here's a screenshot:

 

Hope this works for you as well. 

 

- Barbie

[astroboy]

Hi, I just want to insert this HowTo article that seems related to what you are trying to achieve: https://howto.caspio.com/tech-tips-and-articles/common-customizations/adding-an-any-option-to-a-dropdown/

Cheers!

[astroboy]

9 hours ago, Barbie said:

Ho @Kuroshithe workaround that I can suggest is creating multiple DataPages and filtering them based on your criteria. Then on your search dropdown options, you can configure it to be dynamically redirected to *9the filtered DataPages based on criteria.

Hope this helps.

Also, regarding dynamic redirection based on the selected dropdown value, you may also try passing the parameter on exit and then redirect it to an HTML DataPage to receive the parameter and use that value to identify the redirection page. In my case, I always use the code inside this documentation as reference and tweak a little to make it work:

https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/