I am trying to setup a controlled access section on a form. My edit formula is @If(@IsMember(“[Admin]”; @UserRoles);@UserName;“”). The problem I am having is that users that have editor access, but are not members of the Admin group can still edit. Can you tell me what I am missing.
Thanks
Subject: Controlled Access Section
Why not just use the formula “[Admin]”?
Subject: RE: Controlled Access Section
Thanks that works!
Subject: Re: Controlled Access Section
You could just use “[Admin]” as the previous reply says, but the reason yours is not working is because you entered “” (i.e. Null) as the False condition. “” means everyone. If you wish to use the @if, which is appropriate at times, your false condition must be something besides “”. I tend to use “NoOne”, although you could use any text you wish.
Subject: Controlled Access Section
Please see Steve’s post for the correct formula. Your formula doesn’t work because you want it to evaluate as the document is opened, but instead it is evaluated as the document is saved, and applied when the document opens.