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

text field


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

Recommended Posts

  • Newbies

I'm using FMP 5 to do a school report, and i need to to know how to limit total number of words or characters. when a user is trying to input more then that, it would give an error message.

any help would be great.

thanks in advance

Link to comment
Share on other sites

quote:

Originally posted by blue_bug:

I'm using FMP 5 to do a school report, and i need to to know how to limit total number of words or characters. when a user is trying to input more then that, it would give an error message.

any help would be great.

thanks in advance

Use field validation. When you're in the Define Fields dialog, select your field and click Options. Click the Validation tab. Click on the check box for "Validated by calculation" and a calc dialog will come up. Let's say that your field is named EntryField and the length you want to be a maximum is 25 words. Then enter the following calc:

WordCount( EntryField ) <= 25

If you want to limit it to 500 characters, use:

Length( EntryField ) <= 500

If the user enters text in the field that violates the validation (renders the equation false), then a dialog will come up. The one provided by FileMaker is pretty generic, but you can check the box for "Display custom message if validation fails:" in the Validation tab. You also have the choice to either just warn the user, but allow him to override the validation, or to make is "Strict" so that the field must conform to the validation

Chuck

Link to comment
Share on other sites

  • Newbies

thank you for taking your time to reply to my question.

i've got to that so far, but that is when more problem comes up.

with the dialog, there will be "revert" "yes" "no" to pick from, and my targeted users are the teachers that have no idea of how to use this software, and will no know which to pick from.

revert will remove all that they have put in,

no will just allow them to override

yes will send them back to do changes.

is there any way to remove the "revert"?

thank you again

Link to comment
Share on other sites

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