Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6783 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

I'm using this calc for my Phone Number custom function. I got this either off this site or CC support forum. Everytime I enter a number I get an error message. I then re-input the same number and it works fine.

Case

(IsEmpty ( Phone Number );" ";

Length(Phone Number) = 7;Left(Phone Number;3) & "-" & Right(Phone Number;4);

(Length(Phone Number) = 10); "(" & Left(Phone Number;3) & ") " & Middle(Phone Number; 4; 3) & "-" & Right(Phone Number;4);

"Wrong number format")

Can anyone tell me what's wrong?

Thanks,

Al

Edited by Guest
Posted

I just tested this as a calculation and it works (it should work then as a CF)

is your field TEXT result, and is it big enough to show the results. (i.e. if you see a ? in there, then it needs to be widen.

HTH

Lee

Posted

I take it you are putting the result back in the Phone Number field? If so, have a look to make sure your field is really empty when you start entering data.

Why do you set it to a space when it is empty?

Posted

What exactly is the error message? And i think it may or may not have to do with your space when its empty like Oldfogey suggested.

~Genx

Posted (edited)

As I stated I copied this from either this forum or CC forum. I deleted the space from the calc and it seems to work fine now.

Thanks for all your input.

Edited by Guest
  • 2 months later...
Posted

When I copy and paste this calculation and try to enter data I get a dialog box telling me the field is not modifiable. What am I doing wrong?

FM 8 advanced on Mac 10.4.6

Posted

Did you set it up as a Custom Function or simply a calculation within a field? Is the field set as text? Can you post a copy/clone of your file or show us pictures of your field set up?

Posted

Your field should be a text field (or anything thats not a calc or summary) with auto enter calculation checked (with your custom function calc in here) and do not replace contents unchecked.

This topic is 6783 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.