AnsweredAssumed Answered

Remove phone number masking on new record

Question asked by MarkPerrine on Aug 10, 2014
Latest reply on Aug 11, 2014 by philmodjunk

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

Outcomes