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
      ------------------------------