SSNumb ( number )
Formats Social Security Number
Average rating: 4.0 (32 votes) Log in to vote
Custom Database Design
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Formats Social Security numbers in the format xxx-xx-xxxx. Results displays in red if improper number of numerical digits.
Barry Sommers, Staten Island NY
Apr 15, 2009
Unable to use the above calc code since it is for FM Advanced only. I am using "regular" FM 9.3. (Tried it... it won't work)
Do you have a calc code for auto formating SS numbers that will work with my version of FMP ???
Much appreciate any help you may offer.
John Leyman, Loma Linda, CA
Sep 20, 2011
You won't be able to make custom functions without FM Pro Advanced, but you can make a calculated field with the some formula:
NumOnly= Filter(number; "0123456789");
SSNumb = Left(NumOnly;3) &"-"
& Middle(NumOnly;4;2) &"-"
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.