If User Name is > 20 character then...

[tbfilemaker]

Problem:

I am attempting to create a work around for not allowing users onto a server if they have a "User Name" setting in the Preferences > Application greater than 20 characters. It turns out that some individuals have long user names which is crashing our FileMaker Server 5.5 application.

Proposed Solution:

Create a jump script within FileMaker Pro 6 to place on the client machines with the following:

If User Name is > 20 characters then show message, "Please see your local Administrator to reconfigure your User Name."

Else

Go to file on server.

Note: it would be ideal if one file worked for all users.

Any insight or any ideas on how to accomplish this would be greatly apprecaited.

Thank you kindly.

Edited February 4, 2010 by Guest

[Fitch]

Have you tried

Length( Status (CurrentUserName) ) > 20

[tbfilemaker]

Fitch- Thanks for the pointer, a variation of that function worked like a charm.

Here is my final script:

Set Field ["filemaker user name","Status(CurrentUserName)"]

If ["Length (filemaker user name) > 20"]

Show Message ["Invlaid User Name, please change..."]

Else

Open ["Database.fp5 (*)"]

Thanks for all of your suggestions, it is really appreaciated.

Edited February 5, 2010 by Guest