Jump to content
  • 0

How to show results when the other filter is not clicked or left blank?


Jared
 Share

Question

Hello! Im Jared, Im new to caspio and Im working on a simple database for researches of our department. I have created a single datapage for it with two filters, Year Presented  and Type. I managed to get some results when the two filters only  have values on it like for example (2016 and Commercialization) but when I leave either of the two and only search using one criteria there are no result to show. 

Question: How can I show results when I only search using one criteria?

 

Please help me :<
Thank you!
image.png.eb664a9b9e6700c5ac708216fcddddda.png
image.thumb.png.0a53189c48608e463a3f0558d1424f02.png
image.png.c86be690b8af0edeff89296676a4b6ba.png
image.thumb.png.c6710bc009c238928031dcf1ce97ad25.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

There could be a couple things doing this.

First, check your values in the first dropdown, Year Presented. It looks like the display value is set to ' - ' which is fine, but you want to make sure the 'value' part is set to nothing.

Next, you'll want to check the advanced tab on your fields. There should be an option to choose what to do when the field is left blank. Make sure to choose 'ignore field in search criteria'.

If you're still having a problem, if you could take a screenshot of your form datapage wizard on the search page showing the values for Year Presented, that would be great. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...