Hide When forumla with @UserRoles not working

HCL Domino Domino Forum
1

Hi,

I have to hide a controlled access section based upon the combination of the following conditions in Notes client database:

Hide the section that contains the BillToNo field if the user does have the DBA role assigned, however the DBA should be able to see the empty field so they could put the Bill To No. Once DBA inputs the number then it should be visible for all.

Here is the formula and for some reason the section keep showing up for all non DBA users:

@If(@IsMember(“[DBA”;@UserRoles);@False;BillToNo !=“”;@False;@True)

Does some one see any error in the above code?

Thanks,

Armand

2

Subject: Hide When forumla with @UserRoles not working

Hi

Your description is somewhat confusing as you say that the DBA role can’t see the section, but then that they can.

I assume you mean that only the DBA can see the field/section until it’s been filled in, then anyone can see it.

Don’t bother using @if or @false/@true in your ide-whens, there’s no point. If the formula is true or false the relevant section will be visible/hidden. So use:

@isnotmember(“[DBA]”;@userroles) & BillToNo=“”

The above can only be true when the field is empty and the user isn’t a member of the role, which should be what you want, as long as I’ve understood you correctly

Dan

3

Subject: RE: Hide When forumla with @UserRoles not working

Thanks it worked great.