Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
2 years ago

Phone number to rich text formula format

Hi,

I need to change a phone number (555) 555-5555 to this format instead 555-555-5555 .

It seems quickbase default format is with () and Im not sure how to get rid of them.

------------------------------
NOEL HODGES
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    you will need to create a new formula text field 

    var text MyTel = ToText([Std Tel]); // insert your own Tel field here.

    var text RemoveOneBracket = SearchAndReplace($MYTel,"(","");
    SearchAndReplace($RemoveOneBracket, ") ","-")

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • NOELHODGES's avatar
      NOELHODGES
      Qrew Cadet
      2 years ago
      Thank you so much! Works great!

      ------------------------------
      NOEL HODGES
      ------------------------------