4 Replies Latest reply on Aug 11, 2014 9:28 AM by philmodjunk

    Remove phone number masking on new record

    MarkPerrine

      Title

      Remove phone number masking on new record

      Post

           I finally figured out how to set up phone number masking using the FMP authorized knowledge base.  Now when I add a new record in Layout Mode I get the following (see pic):

           How do I remove the "(###) ###-####" from showing on a new record?  I just want it to appear blank when starting a new record.

           ******

           FYI - here is the calculation formula I used in the masking field:

           Choose(Length(CPhone2);
           "(###) ###-####";
           "("&CPhone2&"##) ###-####";
           "("&CPhone2&"#) ###-####";
           "("&CPhone2&") ###-####";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;1)&"##-####";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;2)&"#-####";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;3)&"-####";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;3)&"-"&Middle(CPhone2;7;1)&"###";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;3)&"-"&Middle(CPhone2;7;2)&"##";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;3)&"-"&Middle(CPhone2;7;3)&"#";
           "("&Left(CPhone2;3) &") "&Middle(CPhone2;4;3)&"-"&Middle(CPhone2;7;4))

      Screen_Shot_2014-08-10_at_11.21.08_AM.jpg