Forum Discussion

AndrewAndrew2's avatar
AndrewAndrew2
Qrew Trainee
10 years ago

Converting a QB entered/formatted Phone number to a 10-digit number

I have a Phone Number Field that the user enters a phone number into. QB returns with a formatted number in the following format: (555) 555-1212 I am using this number in an Email field to send a...
Forms
NotificationsEmail
Tables and fields
DavidJung's avatar
DavidJung
Qrew Assistant Captain
8 years ago
Here is my further improvement on this for "international format" using a QB phone-number field as a source. This strips out extensions, uses an international prefix if there is one, applies country code for North America.

If([Phone]<>"",
If(NotRight([Phone], "(")<>"","+"&Trim(NotRight([Phone], "(")),
Case([Country],
"United States","+1",
"","+1",
"Canada","+1",
"Mexico","+52",
"")))
&
Left((NotLeft([Phone], "(")),")")&
Right((NotRight([Phone], "-")),3)&
Right(
If(Contains([Phone],"x"),NotRight([Phone],"x"),[Phone]), "-")
)