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. 
 

[TellMeWhy]

On 7/31/2021 at 6:04 AM, Kuroshi said:

 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. 
 

Can you elaborate? Is this just one field or all fields? You can probably use Criteria and Rules and set the other one to match for blank values and hide it or show it depending on the other field

[ParkLoey]

Hi @Kuroshinot sure if this will help but i found out that there's an option to match blank values when the search field is blank. Maybe this will work for you too. Just put a placeholder or hint to leave the field blank if they want to search up records with blank values.

[imJihyo]

Hey there @Kuroshi!

Looks like @Tubby's recent forum post might work for you. You can check the solution here: