Displaying user login name in filemaker pro database

Posted on 2007-09-28
Last Modified: 2008-01-09
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.
Question by:dozenne
    LVL 9

    Accepted 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.

    LVL 28

    Expert Comment

    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

    Author Comment

    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

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now