Status (Current User Name)

[John May]

I am experimenting with using the "Status(CurrentUserName)" function to autofill a field in a file. I'd like to do this because I have user passwords defined to only allow record access to users based on that field, and if they exit the record without setting that field correctly, they lose access to the record.

I've gone to Edit,Preferences,Application,General, and put a value in the "Custom" box, but the application keeps returning the "System" name. I quit the application and restarted it, but still get the same results. I have NOT tried restarting the computer (I'm using FM6 on Mac 9.1), but that seems a bit extreme.

Should I be able set this parameter and have it show up as Status(CurrentUserName)?

[jasonwood]

I don't know the direct answer to your question, but might it be easier to require users to enter a user name in a global field (indirectly--through a script)? This way more than one user could use a single terminal, and you still know who it was.

[John May]

Thanks for the suggestion. I can see the merits of a solution of that type. However, before I resort to that, I'd like to see if I can avoid having the user have to log in twice.

[LiveOak]

I tried it with FM 6 and FM 5.5 under OS 8.6 and it seems to work fine. How are you "autofilling" the field? If you are using a calculation field set to Status(CurrentUserName), make sure it is unstored.

-bd

[John May]

A-HA!

The "make sure it is unstored" part was what I was missing.

Thanks!