• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1500
  • Last Modified:

Displaying user login name in filemaker pro database

Using Filemaker 8.5 and 9.0 now on Mac OSX

Is there a command or steps to show the name of the person logged into the database.  I don't want it to pull the computer login name but the "logged in" name that the person uses to access the filemaker application.

Example: login: HarryPotter
password: xyz

displays in the database as "Hi HarryPotter" somewhere in the header.
1 Solution
Get(accountname) will give you the login username if you are logged in through an external server.

Set field(Text field,get(accountname)) in a script

in an auto calculation just use get(acountname)

For a header create a Global calculation field, place get(accountname) in the calculation and select the Text dropdown at the bottom of the calculation dialog.

I personnaly use a global variable $$user = get(acountname) to keep the users' name. I hate to waste fields!
but this can't be placed on a layout unfortunately; to do this follow jvaldes advice, ie a global field
dozenneAuthor Commented:
Just noticed that if you leave it as a global calculation field then if you log in as someone else it keeps the previous login name up there.

Great solution but clicking on storage option at the bottom of the calculation setup box and checking "do not store calcualtion results" instead of the global allows it to refresh on each login with the current users login name there.

Great help though!  I kept trying the insert "current user name" and it kept pulling up the computer login id.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now