Phone Formatting

Format a phone number field in FileMaker using an auto-enter calculation. Full video series at philosophy-of-...

[@MichaelHernandez-sb5jb]

I am a complete novice in FileMaker Pro, zero coding knowledge. I was hoping you would help. I have a field with numbers only (19 number characters) and am wanting to create a mask 05-07-35-0003-006-035.020 with the capability of having a zero (at times not always 10-06-14-0004-001-010.000). If user only enters 16 number characters, 3 zeros will automatically be added at end (after decimal). Your help will be greatly appreciated.

[@JohnMarkOsborne]

Let( @Number = Filter(TIP::number; "0123456789"); Left(@Number; 2) & "-" & Middle(@Number; 3; 2) & "-" & Middle(@Number; 5; 2) & "-" & Middle(@Number; 7; 4) & "-" & Middle(@Number; 11; 3) & "-" & Middle(@Number; 14; 3) & "." & Case(Length(@Number) = 19; Right(@Number; 3); "000") )