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 Glasses
Glasses Grey
In my search bar I put "Glasses Grey"
I want only to get the first and 3rd records ?
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
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.
Qrew LegendThe 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.
