[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1486
  • 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.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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