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
------------------------------