Phone number to rich text formula format

Question

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

markshnier__you · Answer

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

Thank you so much! Works great!------------------------------NOEL HODGES------------------------------

Forum Discussion

Phone number to rich text formula format