Phone function puts formating in.

[hugh71158]

Hi all,

sorry if this is posted in the wrong place.

I am using a Custom Function in FM10 Adv., and when I create a new record all of the phone fields are populated immediately with the formatting of the function.

For example, if I select (###) ###-#### in my preferences setup, when I create a new records I get ()- before any numbers are entered.

Can anyone tell me what I am doing wrong? Info below.

Thanks.

Case(

not IsEmpty(Format);

Let(

[@NumbersOnly = Filter(Phone; "0123456789");

@NewFormat = Left(Format; Length(Format) -1);

@NewNumber = Left(@NumbersOnly; Length(@NumbersOnly) -1)];

Case(

Right(Format; 1) = "#";

PhoneFormat(@NewNumber; @NewFormat) & Right(@NumbersOnly; 1);

PhoneFormat(@NumbersOnly; @NewFormat) & Right(Format; 1)

)

)

)

[bcooney]

How about adding to the calc a check for an empty phone field? Change the beginning of the calc from

not IsEmpty (Format);

to

not IsEmpty (Format) and not isempty (Phone);

[hugh71158]

I'll go try it now!

Thanks.