AnsweredAssumed Answered

how to make 14 digit (xxx) xxx-xxxx phone # fields when entering phone #'s in a field

Question asked by LarryStokes on Nov 19, 2010
Latest reply on Nov 21, 2010 by RickWhitelaw

Title

how to make 14 digit (xxx) xxx-xxxx phone # fields when entering phone #'s in a field

Post

I need to know how to create the formula, value, or calculation for the 14 digit (xxx) xxx-xxxx phone # fields in my contacts table of my database. I want to be able to just type in the 10 digits of the phone numbers (including area code) by entering only the 10 digits. I just created a database and inputted all the contact phone numbers as straight numbers (xxxxxxxxxx) until I can get a response that will allow the data to display properly. Thanks for the help. 

Also I would need to know in what particular area of FileMaker Pro 11 to place this information into and very specifically how to write out the formula or calculation or ??? (from A-Z). In effect I need a walk through.  I'm a newbie to File Maker. I would appreciate any help.

LarryJ

 

Outcomes