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

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

Recommended Posts

Posted

Hi jtwilber,

"(" & Left(Abs(TextToNum(PhoneRaw)),3) & ") " & Middle(Abs(TextToNum(PhoneRaw)),4,3) & "-" & Right(Abs(TextToNum(PhoneRaw)),4)

Replace "PhoneRaw" with your field name where the phone number is now.

Lee

wink.gif

Posted

Ok now be gentle with me, I'm totally new. Am I displaying two fields in

the layout??? or is this a script in the phone field... explain in dummy terms and I'll be forever indebted.

Thank you Lee.

JWilber

Posted

Hi JWilber,

You need two fields:

One of the fields is where you enter the raw number, and the other is a calculation field that will create the format you want.

PhoneRaw number

cPhone Calculation, text result, =

"(" & Left(Abs(TextToNum(PhoneRaw)),3) & ") " & Middle(Abs(TextToNum(PhoneRaw)),4,3) & "-" & Right(Abs(TextToNum(PhoneRaw)),4)

Note: substitute your field name or names for any fields you already have.

HTH

Lee

cool.gif

Posted

Put the calculation field on top of the data entry field, and set its field format to Not Allow Enty (right click, then Field Format. Line the fields up precisely (same size, type face, etc). Make sure to take the top field (the calc) out of the tab order. When the user clicks in the field, the bottom data entry becomes active, but when the user is out of the field, the formatted # will be displayed.

Steve

Posted

Thanks Lee... I understand but it sure seems odd that you can not just put a mask (like Access) over a single field for formating. If this is the case do you use the two fields and the formula above in your own work or just accept unformated phone numbers.

Posted

Steve just told you how to do this, if you need more information, ask away.

Lee

wink.gif

Posted

Hi,

There is also a pretty cool file to make your own phone masks, available at fmfiles.com.

Really useful when you're dealing with multiple phone masks...

Posted

Thanks. Very helpful. Any other sites out there that could prove invaluable to me as I ramp up. Also, do are fm developers making $ or starving.

This topic is 7848 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.