The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

A Couple FileMaker Functions To Help Track User Activity – FileMaker Today

Get real time updates directly on you device, subscribe now.

From Dwayne Wright PMP, PMI-ACP, CSM

Certified FileMaker Developer


EMAIL: This email address is being protected from spambots. You need JavaScript enabled to view it.

TWITTER: dwaynewright

YOUTUBE: FileMakerThoughts


Introduced With FileMaker 7

Returns A Numeric Result

The Get(UserCount) function returns the number of users / clients currently accessing the active FileMaker file. It will return a 1 if the file is not being shared, because there is only one user. If the file is being shared, it will return 1 for the host and then the number of clients or guests using the file via standard FileMaker networking. By standard networking, I mean the function will not count web, ODBC or JDBC connections as users.


Introduced With FileMaker 7

Returns A Text Result

The Get(UserName) function will return a text string of the user name as specified in the FileMaker general tab application preferences. On the surface, this can be a nice tool to build auditing information about who creates or modifies a record.

A Couple FileMaker Functions To Help Track User Activity However, there are some drawbacks to using this function instead of the Get(AccountName) function. It is not uncommon for more than one user to use the same computer. In a case such as this, the Get(UserName) function will return the same value for each user because the information in the General Preference area does not change.

On the flip side, a user can change this information and reflect that they are someone they are not. So many records can be flagged incorrectly or (heaven forbid) you use this function for security reasons, the security model could be defeated easily.

So in more cases in which you are tempted to use the Get(UserName) function, I’d recommend the Get(AccountName) function instead.


More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

© 2008 – 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.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More