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
_
none

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)

/* Created 7/29/2017 By Robert Schaub
Too_Many_CAPS ( Field1 ; Field2 ; Field3 ; Field4 ; Field5 ; Field6 ; Field7 ; Field8 ; Field9 ; Percent )
If you do not want all 9 fields use empty quotes in the parameter. */

Case(
not IsEmpty(Field1)  and 
Length( Filter(Field1; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field1)  > Percent

or 
not IsEmpty(Field2)  and 
Length( Filter(Field2; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field2)  > Percent

or 
not IsEmpty(Field3)  and 
Length( Filter(Field3; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field3)  > Percent 

or 
not IsEmpty(Field4)  and 
Length( Filter(Field4; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field4)  > Percent 

or 
not IsEmpty(Field5)  and 
Length( Filter(Field5; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field5)  > Percent 

or 
not IsEmpty(Field6)  and 
Length( Filter(Field6; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field6)  > Percent 

or 
not IsEmpty(Field7)  and 
Length( Filter(Field7; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field7)  > Percent 

or 
not IsEmpty(Field8)  and 
Length( Filter(Field8; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field8)  > Percent 

or 
not IsEmpty(Field9)  and 
Length( Filter(Field9; "QWERTYUIOPASDFGHJKLZXCVBNM") ) /
Length(Field9)  > Percent ; 


"It appears that you are using too many uppercase letters, Please clean up your text. Please do not use all CAPS, " & " More than "  & GetAsText(Round(Percent;2) )& "% of at least one field has too many CAPS"
 ;"")

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.

Comments

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

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

Comments

Support this website.

Support this website.