February 3, 201213 yr From a google search, I see there is no easy way to see which various accounts are currently logged in from around the globe either on IWP or locally. Get (User How would I setup a startup script to Get (Accountname) and paste it into a field along with logon time and then delete that data from the field with an exit script. I have tried 'IF' but I just can't get it to work. Thanks so much, Maria
February 3, 201213 yr A simple table "Log" with three fields: Account, TimeStamp, Event. In a startup script Go to Layout "Log" New Record Set Field "Account", Get (AccountName) Set Field "TimeStamp", Get (CurrentTimestamp) Set Field "Event" ; "Login" In a Closing Script: Go to Layout "Log" New Record Set Field "Account", Get (AccountName) Set Field "TimeStamp", Get (CurrentTimestamp) Set Field "Event" ; "Logout" Don't delete anything. Why do you need this?
February 3, 201213 yr Author Thanks a million. I have many employees working on the same databse from differnet parts of the world. I just like to know who is online and working Thanks again
February 3, 201213 yr In a Closing Script: Go to Layout "Log" New Record I was wondering why wouldn't you enter the closing timestamp in the same record that opened the session?
February 3, 201213 yr I use a logging script as above, but keep in mind it's not 100%. Users can quit a file without running the On Close script, usually inadvertantly as a result of a crash or a dead battery in a laptop. FileMaker Server will list the users logged into a database. Dont know if there's a script (system, not FileMaker) out there to capture that info though that would be nice.
February 3, 201213 yr Author Ok, all done as you have stipulated... but I just have a long list of users logging in and out and I really don't know who is actually online without having to study the list. Why shouldn't I delete anything? Couldn't I run a closing script that; Go to Layout (Log) Enter Find Mode Set Field (Log:Account; Get(AccountName) Perform Find Delete Record Exit application Wouldn't that just leave me with a list oif the users currently logged in? Thanks so much, Maria
February 3, 201213 yr Sounds OK. Or, as comment suggests, enter a logoff timestamp in the last record for that Get (AccountName).
Create an account or sign in to comment