Forum Discussion

QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
5 years ago

Searching on formatted phone number = no records found :-(

I recently received this question on one of my Quick Base Junkie YouTube videos... "I'm using QB and for some reason when I search the database by phone I keep having to take out the dash & parenth...
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Edward, can you expand on your use case.  Are you trying to search on just he numeric part of he phone # ?  for example the # is (800) 555-1212 and you are trying to search on 5551212  and not getting hits?  ​​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
EdwardClark's avatar
EdwardClark
Qrew Member
5 years ago
Mark,

Thanks for the reply.

I try searching both (800) 555-1212 and 8005551212 and neither produces a result.

Hope this helps.

------------------------------
Edward Clark
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    phone numbers do not default to being searchable.  Look for this setting in field properties
    Searchableble
    Include this field when searching/filtering this table


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • EdwardClark's avatar
      EdwardClark
      Qrew Member
      5 years ago
      Mark,

      I just did this and still no joy.

      ------------------------------
      Edward Clark
      ------------------------------
      • MichaelTamoush's avatar
        MichaelTamoush
        Qrew Captain
        5 years ago
        I had the same trouble, however I didn't realize phone numbers were not defaulted to searchable. When I changed that, I can confirm that I am able to search. However, I do have to search the numbers only (meaning, adding a parentheses or hyphens yield no results).

        It is curious that you still cannot search....

        ------------------------------
        Mike Tamoush
        ------------------------------