Brian Dunning's FileMaker Custom Functions

Too_Many_CAPS ( Field1 ; Field2 ; Field3 ; Field4 ; Field5 ; Field6 ; Field7 ; Field8 ; Field9 ; Percent )

Checks multiple fields at the same time to see if the percentage of capital letters are too high.

  Average rating: 4.7 (6 votes) Log in to vote

Robert Schaub   Robert Schaub

Share on Facebook Share on Twitter

  Sample input:
Too_Many_CAPS (
Projects::Project Name ; Projects::Project Address ; Projects::Project City ; Projects::Project Description;Projects::Project Information ; Projects::Project Notes ; Projects::Project Type ;""; "";.3 )
  Sample output:
if one of the fields is greater than the defined percentage. Returns message

It appears that you are using too many uppercase letters, Please clean up your text. Please do not use all CAPS, More than .3% of at least one field has too many CAPS

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Some users just refuse to turn of the CAP lock. It makes for an unprofessional look in the screen. I have created a field using the custom function and place it in the layout with no entry access on the field. It is also much larger Red Bold text with no borders and no fill. If the function is true it will display the message until the user goes back and remove some of the caps.

I have created up to 9 fields, If you do not want all 9 fields use empty quotes in the parameter. The calculation may not be pretty, but i works for now. Until I come up with a better way.



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: