SeedCode Support Forum

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?

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.