Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Assistant Captain
2 years ago

WildCard Search in Tables



Is it possible to do a wild search in regular table view?

Let's say I want to search for 

pras* + eggs
or 
egg + olive


Prashant is my name
Prashant eats eggs with butter
Prashant goes for rock climbing
Prashant makes eggs with olive oil

------------------------------
Prashant Maheshwari
------------------------------

3 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    np,
    the syntax AND and OR in upper case have meaning as filter operators.

    pras AND eggs

    will give you hits where the search in any columns meet the criteria. The hits do not need to be on the same column.

    pres OR eggs will give more hits as it's an OR operator

    The search is not case sensitive.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Assistant Captain
      Mark , 
      my big fat thanks !!

      ------------------------------
      Prashant Maheshwari
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        ya pretty handy and certainly most regular users would not think to try that.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------