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. -----------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendyou 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
------------------------------
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
------------------------------
- Thank you so much! Works great!
------------------------------
NOEL HODGES
------------------------------
