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!

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.

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.

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

Perfect! Thank you.