Skip to main content
Solved

Add hyphens to phone number field

  • August 22, 2024
  • 0 replies
  • 380 views

Forum|alt.badge.img+4

Hi All,

I have a phone number type field that you have to manually enter an individual's phone number w/ hyphens. Is there a way to use a formula phone number field to auto add the hyphens when a number is keyed into that field (and possibly add parentheses around the area code)? I haven't found anything yet that works.

Thanks in advance!

-Scott

Best answer by sfountain

Just checked the International checkbox in the field properties and it does not format as I was hoping for!

 

This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

Can you explain the issue? Typically if you have a phone number type field it formats for display nicely regardless of spaces and hyphens entered it not entered. 


Forum|alt.badge.img+4
  • Author
  • Registered
  • August 22, 2024

Hi Mark,

Certainly, as the field is today, you have to manually add the parentheses as well as the hyphens for a 10 digit number. So for example, it you enter 555555555 it will show as such. I wasn't sure if there was a formula that as you enter the number it would convert it to (555) 555-5555

 

I had multiple users ask if this is a possibility to alleviate them adding in those special characters/key strokes every time they enter a phone number.

Hope this answers your question?

Thanks,

-Scott


MarkShnierYou
Forum|alt.badge.img+24

I don't believe there is a way to have the data entry format dynamically as it's being entered character by character.

 

I don't believe there is a way to have the data entry format dynamically as it's being entered character by character.

But when you save the record it displays properly, right?  


Forum|alt.badge.img+4
  • Author
  • Registered
  • August 23, 2024

hmm interesting, i am using a legacy form and i don't see the same. i'm just using the simple phone number field type and don't see any formatting type options within the field properties.

I did however just check out a new form, and it does appear to format as I'd want to.

Might be time to convert the legacy form over to the new!

 

Thanks again, Mark!!


Forum|alt.badge.img+4
  • Author
  • Registered
  • Answer
  • August 23, 2024

Just checked the International checkbox in the field properties and it does not format as I was hoping for!