Seaching
How in a search bar can I set it up to search for different words that would be in a field but not in the exact order.
Let say I have a the following 3 records
Grey Sun Glasses
White Glasse...
Forum Discussion
In your search you can use AND OR syntax as a way to make Quickbase interpret it that each should be evaluated in conjunction.
So you could do in your search: Glasses AND Grey
And you should get the response you're looking for. Order doesn't matter so you could do Grey AND Glasses to get the same result.
Casing does matter, so make sure you do AND or OR instead or and / or
------------------------------
Chayce Duncan
------------------------------
Sorry I should have mentioned that this is either in a search widget, on a home page , a <ask the user> as part of a table report or as a "Search Records " bar at a top of a table report.
I confirmed adding AND or OR does not do what I am looking for.
------------------------------
Trevor Kent
------------------------------- MarkShnier__You
Qrew Legend
The AND and OR will work but they must be written in upper case. Such as
glasses AND grey
The search terms can be upper or lower lowercase, they are not case sensitive, but the AND must be in upper case.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------I stand corrected the AND and OR work just great.
------------------------------
Trevor Kent
------------------------------
