Discussions

 View Only
  • 1.  WildCard Search in Tables

    Posted 08-05-2022 14:38


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


  • 2.  RE: WildCard Search in Tables

    Posted 08-05-2022 14:55
    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
    ------------------------------



  • 3.  RE: WildCard Search in Tables

    Posted 08-05-2022 15:08
    Mark , 
    my big fat thanks !!

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



  • 4.  RE: WildCard Search in Tables

    Posted 08-05-2022 15:11
    ya pretty handy and certainly most regular users would not think to try that.

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