Brian Dunning's FileMaker Custom Functions

PasswordChecker ( Password ; UpperCaseLetters ; LowerCaseLetters ; Numbers ; SpecialCharacters ; MinLength )

Check if a given password complies with the rules you set

  Average rating: 4.4 (26 votes) Log in to vote

Martin D. Brunner   Martin D. Brunner
none
http://none.com

Share on Facebook Share on Twitter

  Sample input:
PasswordChecker ( "Guggus+,1" ; 1 ; 1 ; 1 ; 1 ; 8 )

PasswordChecker ( "Gug+,1" ; 1 ; 1 ; 1 ; 1 ; 8 )
  Sample output:
1

0

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

PasswordChecker ( Password ; UpperCaseLetters ; LowerCaseLetters ; Numbers ; SpecialCharacters ; MinLength )

This function checks if a given password complies with the rules you set for passwords to be used in your solution.

Parameters:
Password Text Password you want to check
UpperCaseLetters Number How many Upper Case Letters are required in the password?
LowerCaseLetters Number How many Lower Case Letters are reuqired in the password?
Numbers Number How many Numbers are required in the Password?
SpecialCharacters Number How many Special Characters are required in the password?
MinLength Number How long must the password be in minimum

The result given back is a boolean: 1: comply, 0: doesn't comply

 

Comments

Jeep Watson   Jeep Watson, Baltimore
Mar 13, 2015
Your SpecialCheck has a wrong reference:

≥ Numbers ; 1 ; 0 ) should be ≥ SpecialCharacters ; 1 ; 0 )
 
Martin   Martin, Zürich
Mar 13, 2015
Correct - sorry, my bad and thanks for letting me know!
 
Andy Hibbs   Andy Hibbs, Norfolk, UK
Jan 7, 2016
We did have a problem that was resolved by adding GetAsNumber () around MinLength when passing variables to the parameters. To be safe we added this to all the parameters within the Let and it has worked well since.
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.