Standardize Phone Number Display
Convert numbers in a phone field to standard display. For example, when I type in 4257083456, it automatically gets converted to (425) 708-3456
Gene Ferris commented
In my case, in addition to entering new numbers, I have a legacy db from 2012/3 with hundreds of phone and fax numbers in various formats.
My wish, going forward, option to force format in data entry form fields/subfields selectable from a list. My current desire would be "." or "-" sub field delimiters, and Diane's (xxx) xxx-xxxx
Bigger wish, for the format update to be applied to the entire db, either en masse or when records are accessed or exported.
Is there a utility macro that could perform this translation??
My reason for this wish... I am developing a print version of our membership directory with pages for each of our 9 buildings (8 to 14 Membership records per page) plus Alpha list .
Joanna Straub commented
Yes, please convert numbers to standard format. Also make it so I can click on a phone number in the app and it will dial the phone number!
Stephen Herron commented
Add telephone number formatting similar to your date format.