Forum Discussion

Qrew Cadet

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

Formulas and functions

MarkShnier__You

Qrew Legend

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

Qrew Cadet

3 years ago

Thank you so much! Works great!

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