Is there any way of using filemaker as a password generator. For my login system it is required that users have a random generated password, can I create this password in Filemaker or is there any software that can generate a password that can be placed into Filemaker

Thanks

There is no built-in way to generate or script creation of file-level passwords in FM6. You might see if New Millennium's Password Administrator can do any of this.

In FM7, you can script the creation of accounts and passwords, then use the Random function to help create a password.

sorry - I undestand that filemaker cannot generate and then input a password to itself.

However can a field in the database be used to generate a reasonable password? Can the random function use characters and numbers? Or is there a piece of software that can generate the password then place it into this filemaker field.

Thanks

You can generate random numbers easily enough:

password (calculation, number result) = Truncate(Random * 1000)

But I'm not sure about letters. I suppose you could generate a series of random numbers between 1 and 26 and convert them to letters with a big case statement (or between 1 and 52 to get upper and lower case.)

But I'm not sure about letters.

Middle ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" , Max ( Int ( Random * 26 ) , 1 ) , 1 )

Let me not take credit for this; i got the idea from someone else on the forums, but forgive me, i can't remember who.

J

You will never get "Z" with that formula.

The correct formula is:

Middle ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" , Int ( Random * 26 ) + 1 , 1)

Or, in general:

Middle ( textstring , Int ( Random * Length ( textstring ) ) + 1 , 1)