Brian Dunning's FileMaker Custom Functions

FormatPhone ( phone )

Auto formats all US based phone numbers, along with extensions.

  Average rating: 4.6 (37 votes) Log in to vote

Sravan Puttagunta   Sravan Puttagunta
Mann Consulting

Share on Facebook Share on Twitter

  Sample input:
FormatPhone (3333333333123)
FormatPhone (1-333-333-3333x123)
FormatPhone (333-333-3333 123)
FormatPhone ((333)333-3333 123)
FormatPhone (333-333-3333x123)
  Sample output:
1(333) 333-3333 x123

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Useful for entering phone numbers



Jens Rasmussen   Jens Rasmussen, København K
Jul 3, 2009
I can't see what this does that Proper doesn't do.
Vince Dolan   Vince Dolan, St Paul
Jul 3, 2009
It appears to give you the option to call out the number of "capped" words, where as Proper "caps" them all. Not sure of its actually utility though.
Matt   Matt, Northern Vermont
Jul 9, 2009
Just what we need. Another phone number formatter. What does this make? Eight for North American numbers?
Will Loving   Will Loving, Dedication Technologies, Inc.
Aug 23, 2010
No need to be snide Matt. Everyone is entitled to their take and to try their hand at things.
Luis Gonzalez/AFS Group,Inc   Luis Gonzalez/AFS Group,Inc, Miami, Fl
Dec 21, 2010
I am sorry that I haven’t seen these comments before, but what we need is constructive ones. So, every one just pls. limit it to make all the community to grow.
Paul   Paul
Aug 20, 2013
Neat bit there where a missing area code (often left out in legacy data and in fast data entry because it is always the same) gets interpolated into the phone number. Slick and just what I needed! thanks.
Adam   Adam, Los Angeles, CA
Feb 5, 2015
I appreciate it very much and it works great!!!

Matt I wish I was as smart as you, but I am not and so I appreciate help when I can get it. Please do not hack in my computer for saying that!

Thank You
Sep 23, 2019
didn't help me; I wound up breaking the phone number into text field with embedded 3 parts

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: