Discussions

 View Only
  • 1.  Phone number to rich text formula format

    Posted 09-01-2022 16:44
    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
    ------------------------------


  • 2.  RE: Phone number to rich text formula format

    Posted 09-01-2022 18:34
    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
    ------------------------------



  • 3.  RE: Phone number to rich text formula format

    Posted 09-22-2022 13:29
    Thank you so much! Works great!

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