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.