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
CassieHubble's avatar
CassieHubble
Qrew Cadet
7 years ago
I can not for the life of me get this to work. 

List("",
Part([Guardian-Cell Number],1, "() -"),
Part([Guardian-Cell Number],2,  "() -"),
Part([Guardian-Cell Number],3,  "() -"),
Part([Guardian-Cell Number],4,  "() -"),
Part([Guardian-Cell Number],5,  "() -"),
Part([Guardian-Cell Number],6,  "() -"))

Striped Cell Number
(555) 555-1212
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Syntax error or wrong results?
  • CassieHubble's avatar
    CassieHubble
    Qrew Cadet
    7 years ago
    No error. I still get the (555)555-1212 and not 5555551212.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Silly question, but are you sure you are looking at the right field for the result.  The one with the formula?
  • CassieHubble's avatar
    CassieHubble
    Qrew Cadet
    7 years ago
    Not at all. I have checked the formula, I have checked the formula of the field Im pulling from. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Is the field type formula text?
  • CassieHubble's avatar
    CassieHubble
    Qrew Cadet
    7 years ago
    It's a phone number field. I was finally able to get Matthew Neil suggestion to work. Thank you so much for your help.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Right so you needed it to be text so it won�t put back the brackets :)