Jump to content

formating fields


yaron

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

Recommended Posts

Hi, Im extremly new to filemaker and have the folowing question:

Can I make layout that will format my input?

for example I enter "abc" and after moving to another field it will be showed/saved as "ABC"

(making all the letters upper)

same idea - can I enter a phone number 2121119483

and after moving to another field it will format it to (212)111-9483

thanks alot

Link to comment
Share on other sites

Second part first.

This topic has come of several times in the past, just do an Advance Search using [color:blue]+Phone +Number +Format as the keywords, be sure to include the pluses as shown.

start with this post by [color:red]comment

Here

Your example is pretty short. I'm not sure if you are wanting to have everything Upper Case, or just part of it? (i.e. ABC Distributing, or ABC DISTRIBUTING). If it is the later, then just format the field as Upper Case. You can also use the Auto Enter, and UPPER Function, with the do not Replace existing values, if any. If it is the First example, then you are going to have to let us know.

HTH

Lee

Edited by Guest
Link to comment
Share on other sites

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