Question asked by bleyden on Dec 10, 2017
Latest reply on Dec 10, 2017 by bleyden

So, I followed the instructions in this article on the KB to create a mask for phone numbers, but seem to be having some trouble.  I placed the mask field over the other field as instructed, and gave it a white background.

Calculation:

Choose(Length(Parent 1 Home Phone);

"(###)###-####";

"("&Parent 1 Home Phone&"##)###-####";

"("&Parent 1 Home Phone&"#)###-####";

"("&Parent 1 Home Phone&")###-####";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;1)&"##-####";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;2)&"#-####";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;3)&"-####";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;3)&"-"&Middle(Parent 1 Home Phone;7;1)&"###";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;3)&"-"&Middle(Parent 1 Home Phone;7;2)&"##";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;3)&"-"&Middle(Parent 1 Home Phone;7;3)&"#";

"("&Left(Parent 1 Home Phone;3)&")"&Middle(Parent 1 Home Phone;4;3)&"-"&Middle(Parent 1 Home Phone;7;4))

Problem:

When I am in the field, I can enter a phone number like is shown below:

When I click out of the field, I get this:

Any thoughts on what would be causing this? I copied and pasted the calculation from the KB article and just swapped it out with the field name that I use in my database.