We have a sticky situation involving a user that accesses an application over a browser using authentication. He is a member of a group in the ACL. We have a field that we want everyone in the group in which he is a member to be able to see the contents of except him. We can’t just take him out of the group because it is used in so many places and we want to keep him in the group for all of those reasons except this particular one. I want to use @UserName in a “Hide paragraph when formula is true” to achieve what we want but Designer Help says not to use that formula in a public view, will this work if the user accesses the application authenticating over the web?
Subject: it will work over the web on a form, not a view
If you try this on the view, I think the @username will return the name of the designer who coded the view, not what you want.Doing this on a form will work fine.
You can also investigate Roles:
create another group and put your user into this group, and give the group an ACL role. This will be “additive” to the other ACL for the group.
good luck.