Incorporating The Account Name In FileMaker User Messages

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Get ( AccountName) will become a very popular function to identify who a user is within a FileMaker file. It's very secure because it uses the login information the user used to open the file. Since you can put multiple tables in one FileMaker file, it's easy to use Account Name in multiple places.

So here is a script that will give a different message by who the user is. If you are Dwayne Wright, it tells you that you don’t have access. If you are Stanley, it tells you to go on in. If you are not Dwayne or Stanley, it asks who are you.

If["Get ( AccountName)= "Dwayne Wright""]
Show Message ["You are not allowed in here, talk to Stanley."]
If["Get ( AccountName) = "Stanley, The Security Guard""]
Show Message ["No problem, come on in."]
Show Message ["Who the heck are you?"]
End If
End If

NOTE: In the Show Message script step, you can use a calculated result in many areas of the crafted message. That means you could incorporate the Get ( AccountName) function in the message title, body and even the button labels!

More info about the author and FileMaker in general, contact me at

© 2007 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.