Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

PhoneFormat ( Phone ; Style )

Formatting for North American Style Numbers and Toll Free

  Average rating: 4.2 (34 votes) Log in to vote

Ferrell Beleshko - Show more from this author Terra Software Corporation http://www.terrasoftware.com

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

// PURPOSE: To allow for a simple and quick Phone formatting calc during development. // AUTHOR: Ferrell Beleshko // DATE: 7/18/2005 during ETS // COMPANY: Terra Software Corporation http://www.terrasoftware.com // CALCULATION WITHOUT THE ADDED DOCUMENTATION IS AT THE BOTTOM //Using LET to reduce the amount of code in the calc Let( // Filter is a function that allows you to filter a text field content based on the range you hard or softcode. The P is simply used to reduce the code in the calc. p = Filter ( Phone ; "0123456789" ) ; //Regional 10 digit Format - North American Style Case (Style = "Regional"; // Checks to make sure 10 Digits have been used, if not a text message in Red result in the Phone Number Field. Case( Length ( p ) < 10; p &TextColor ( " 10 digits Required" ; RGB ( 255 ; 0 ; 0 ) ); "(" & Left( p; 3) & ") " & Middle( p; 4; 3) & "-" & Middle( p; 7; 4) & Case( Length ( p ) > 10; " xtn " & Middle( p; 11; 999)) ) //Toll Free Number Format ; Style = "800"; // Checks to make sure 11 Digits have been used, if a fail or false is found The Colour Red and the text message in the calc get set to the Phone Number Field. This calc is is the same as above except we have accounted for the extra digit in a toll free number. Case(Length ( p ) < 11; p & TextColor ( " 11 digits Required" ; RGB ( 255 ; 0 ; 0 ) ); Left( p; 1) & "-" & Middle ( p; 2 ; 3 ) & "-" & Middle( p; 5; 3) & "-" & Middle( p; 8; 4) & Case( Length ( p ) > 11; " xtn " & Middle( p; 11; 999)) // I Personally like to put "Calc Error" here in case something really goes wrong but you can make the message whatever you like it to be. ); TextColor ( "Calc Error" ; RGB ( 255 ; 0 ; 0 ) ) )) /*Calculation without the added Documentation: Let( p = Filter ( Phone ; "0123456789" ); //Regional 10 digit Format - North American Style Case (Style = "Regional"; Case( Length ( p ) < 10; p &TextColor ( " 10 digits Required" ; RGB ( 255 ; 0 ; 0 ) ); "(" & Left( p; 3) & ") " & Middle( p; 4; 3) & "-" & Middle( p; 7; 4) & Case( Length ( p ) > 10; " xtn " & Middle( p; 11; 999)) ) //Toll Free Number Format ; Style = "800"; Case(Length ( p ) < 11; p & TextColor ( " 11 digits Required" ; RGB ( 255 ; 0 ; 0 ) ); Left( p; 1) & "-" & Middle ( p; 2 ; 3 ) & "-" & Middle( p; 5; 3) & "-" & Middle( p; 8; 4) & Case( Length ( p ) > 11; " xtn " & Middle( p; 11; 999)) ); TextColor ( "Calc Error" ; RGB ( 255 ; 0 ; 0 ) ) )) */ Click to copy

This functions formats the Phone number for you for both Regional and Toll Free Numbers. This version also contains a RED text Missing Digits message.

If you want skip all the documentation just go to the bottom of the function and you will see a clean version of the calc inside the last note.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. 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 20 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: