PhoneMask ( number )

Phone Mask

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

Timothy Brown
Antidote Solutions
http://www.antidotesolutions.com

Sample input:

1516 555 133322

Sample output:

(516) 555 - 1333 x22

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

Let( [TempNum= Filter(number; "0123456789");
//remove leading 1
Num = If(Left(tempnum;1) = 1; Middle(tempnum;2;99); tempnum);
      
Phone = "("& Left(num;3) &
             ") "& Middle(num;4;3) &
              "-"& Middle(num;7;4) &
// if it exceeds a length assume it is an extension 
               If(Length(num)> 10; " x"&Middle(num;11;99);"")];

If(Length ( Num ) < 10; 
           // if number is to short less than 10 digits display it in red as error
      TextColor ( phone ; RGB ( 255 ; 0 ; 0 ) ); 
           // remove color format
      TextColor ( phone ; RGB (0 ; 0 ; 0 ))))

This allows for a phone number to be masked when called. It is perfect to be used in the auto entry calculation

Comments

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

PhoneMask ( number )

Comments

Support this website.

Support this website.