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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
Try this

List("",
Part([Phone],1, "() -"),
Part([Phone],2,  "() -"),
Part([Phone],3,  "() -"),
Part([Phone],4,  "() -"),
Part([Phone],5,  "() -"),
Part([Phone],6,  "() -"))
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
    ------------------------------