Telephone Number Input Mask? Possible? Easy?

[B.Gordon]

I would like to make my telephone fields simple for users. Can I define a calculation to mask the telephone number so users simply enter the nine digits and it shows them as (###) ###-####. There must be some code somewhere I can recycle to make this happen.

Thanks!

[-Queue-]

Use an auto-enter calculation on your phone field with 'Do not replace existing value for field' deselected.

Let( phone = Filter( theField; "0123456789" );

"(" & Left( phone; 3 ) & ") " & Middle( phone; 4; 3 ) & "-" & Middle( phone; 7; 4 ) )

where theField is the name of the current field, your phone field.

When a number is entered, it will be auto-formatted when you exit the field.

[MoonShadow]

International formatting can cause you some grief.

Business Tracker allows defining phone formats to account for this if need be and the field data can adjust accordingly.

[Lee Smith]

Hi queue,

You know, if you have never tried to deal with this in a previous version, you would not appreciate the simplicity of your solution.

I'm beginning to appreciate some of the new toys in v7.

Le

[B.Gordon]

Perfect! Thank you.