Skip to main content
Question

Phone number to rich text formula format

  • Sep 1, 2022 8:44 PM UTC
  • 0 replies
  • 129 views

Forum|alt.badge.img+8
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------