Format a Phone Number field

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 2
Joined: Tue Jul 20, 2010 9:39 am
PostPosted: Fri Jul 23, 2010 6:13 pm
Hi! This one is a stupid one. But I have tried and tried and cannot find the answer. I have a phone field in my contacts table when I import the file it loses all formating. No paren's no dashes etc....

I cannot find where I can reformat the field so it will have paren's and dashes (exp: (444) 465-8798). Can you please tell me how I would do this.....

I tried a Self() function....that would look for paren and spaces and dashes but in the end it changed my phone field to a 1 or a zero. (True or False) so that didn't work!

Can you help me with this one?
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sat Jul 24, 2010 9:02 am
You'll want to use an auto-enter calc to format this. We all have our own functions we use for this: mine are a bit elaborate as they'll do email addresses also and so they depend on a couple other custom functions. For something simpler, I'd search for "phone" at:

http://www.briandunning.com/filemaker-custom-functions/

Even though those are custom functions, unless the function is recursive (unless it uses its own name in its definition) you can use it in normal calcs.

Hope that helps.
John Sindelar
SeedCode

Return to SeedCode Calendar

Who is online

Users browsing this forum: No registered users and 4 guests

(855) SEEDCODE
[email protected]
Follow us: