Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

When defining a field, is there a validation calculation you can use to limited the field to max. 10 characters for example.

Also, will this disable the ability to carriage return within a field?

Posted

In the field definition optins click the VALIDATION tab

check off the Validation By Calculation Box

define the calculation as Length(your_field)=(your limit)

You can even check off the:

"display custom message if validation fails" Box

and enter a message of your choice

Posted

Allow me to try it again:

In the field definition options click the VALIDATION tab

check off the "Validation By Calculation" Box

define the calculation as: Length(your_field)=10

You can even check off the Box

"display custom message if validation fails"

and enter a message of your choice

This should work

Posted

I have attempted to use the "Length(field_name)=10" option but the problem is that I am using a repeting field. It dosn't seem to work correctly all the time.

If I enter to many chars, the validation works. However, if I revert the field or OK it & modify to within the allowed char length - The field validation still reports the error?

Posted

The validation "Length(field_name)=10" requires the field to be EXACTLY 10 characters long. Are you sure you don't want "Length(field_name) <= 10"?

-bd

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