Seaching

Question

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 ?

------------------------------Trevor Kent------------------------------

ChayceDuncan · Answer

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

Sign up