Here's a fun one:

- FileMaker 3 server

- FileMaker 4.1 clients

Each time my users open a FileMaker file, they have to enter LoginID and password into a STAFF_ACCESS.FP3 file that i created. In it, i use a text field to capture Current Date, Current Time, and Current File data to a logfile. One thing I would love to know is what computer did they log in on. I don't want to use the Status(CurrentHostName) function because Host Names are easily changed. I'm more interested in the computer's IP address. Anyone find a way to capture a user's IP address in a calc? I'm trying to avoid external applescripts.

[ February 11, 2002, 01:25 PM: Message edited by: minitrue ]

This description is not clear. To beging with, I presume the files into which the users are connecting are hosted by FM Server? YOu seem to imply that. If so, current host name will return the name of the server, not the guest. Perhaps you meant Status Current User name?

FWIW, you can use DialogMagic and SecureFM to set the exact name of the user into the Preferences-->Application-->UserName box and then prevent its being changed.

You could use the Apple System Profiler to extract the machine ID or the IP address, but you said you didn't want to use AppleScript. Also, if you're using DHCP, the IP will change.

Do you ahev any flexibility on this?

Old Advance Man

You're right. i guess i wasn't clear. thank you. the files are on FMP3 Server and everyone on the network has a static ip. i was using the Status(CurrentUserName) function but users kept on changing their computer names ("Coolest #1 Accounting Dept. Computer!") which is a pain. Thanks for the info on DialogMagic and SecureFM. Neither has ever crossed my radar before - i'll definitely check them out. In the meantime I'll have to break out the AppleScript reference. Thanks.