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
TimEgerton's avatar
TimEgerton
Qrew Trainee
5 years ago
Hi Mark,

How can I include "+" at the front of the number to get +6787777777

Thanks
Tim

------------------------------
Tim Egerton
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
"+"
&
List("",
Part([Phone],1, "() -"),
Part([Phone],2,  "() -"),
Part([Phone],3,  "() -"),
Part([Phone],4,  "() -"),
Part([Phone],5,  "() -"),
Part([Phone],6,  "() -"))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------