Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

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

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?

  • 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

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?

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.

  • 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

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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.