How to show who is logged on?

[Ivan Tan]

Hi , i would like to show on the top of my screen the current user logged onto the database. Sort of like a Welcome Ivan. Please remember to log off.

Does anyone knows how to do it? What field? Merge Field? Global? or Calc?

Thank u thank u

[-Queue-]

Create an unstored text calculation of Get(AccountName). Then you can put it in a text block as a merge field as in Welcome <<AccountNamecalc>>. Please remember to log off.

[Ivan Tan]

I should have slap myself silly. The solution came so fast!

[Steven Cappiello]

Could we take that one step further... ?

How could we build something that would show all the users currently logged into the database ?

[Steven Cappiello]

I *guess* this shouldn't be too hard.. perhaps have an accounts table with a global field for "logged in status", and have that turned "on" by a startup script when the user logs in.. then have a relationship from the accounts table to a T.O. of itself, with a text field set to "logged in" that matches against users that actually are logged in, and add another relational criteria... account ID not equal to account ID so you don't see yourself as one of the people logged in..

does this make sense ? or is there a better way ???

[Steven Cappiello]

This worked perfectly! I'm still curious to find out if there's a better way..