Put Blank Value Back In Dropdown Back In Search & Report Page

[feliciacaspio]

When the Search & Report page first pulls up, the fields are all blank, which is very useful to return all the records in a database table. However, if a non-blank field is chosen for a dropdown box (data is pulled from another Table), you can't go back to the blank field for a "Select All" search criteria. The Caspio Table will not accept blank values as a record.

 

Any help appreciated!

 

[Jan]

Hello feliciacaspio,

 

I think, this article (Add an "Any" Option to a Dropdown) can help.

[feliciacaspio]

Perfect. Thanks!

 

I now understand why there is a "Text" and "Value" field. You run the query on the Value field. It was strange to me why you had to duplicate the typing.