@UserName doesn't return the username!

Is there any formula language function that will give me the name of the currently logged-in user in order to control which documents appear in a view (in the view’s selection formula)? @UserName seems to return the name of the agent signer, NOT the currently logged in user, when the view runs on a server (as opposed to a local database). I need a hook to the current user; this view also needs to run on the web so it can’t be a private view.

I don’t expect there is a solution to this problem but I thought I’d ask just in case.

Subject: never use selection data from outside the displayed documents!

never use a selection parameter like username or time/date! you might get huge problems with the view index if many users are accessing the view.

your view should contain a first categorised column with @username

create a form with a hidden names field ‘nmCurrentUser’(computed @Username) on top and a second field called ‘SaveOptions’ with the numbervalue of 0.

Then insert an embedded view. in the ‘Show single Category’ property enter the fieldname ‘nmCurrentUser’ (without quotes). this works for the client.

For web you’ll just have to add RestrictToCategory=xxx to the opening url

Subject: Thanks

I appreciate your comments!