Jump to content
  • 0

Limiting Search Results





I'm a newbie, only been working with Caspio for a few days.

I'm really sorry if this answer is elsewhere, but I have looked and looked but can't find it.


My problem is that I want to limit the results shown in a search return.


Essentially I have a y/n checkbox field in my table which is "It's OK to display this record in search results."


Then I have a few text fields, which I want the user to do an OR sort of search on.  (That bit is fine.)


I want the user to do a normal search, but only return records matching any of the other search criteria if the checkbox field is Y in that record.  And I don't want them to have to specify that it needs to be Y, it must be hidden. (As if they do that, then I suppose they could also choose N, and the records which should not be shown would be revealed.)  I will choose the Y or N for each record when entering the records into the database.


Thanks for your help.



Link to comment
Share on other sites

2 answers to this question

Recommended Posts

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.

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.

  • Create New...