Please help in Notes Formulas - v4.6x 1

[hm1234]

Dear All,
I am new to Application Development and am trying to modify an existing database created by some other developer. I need a Notes formula to implement the below requirement. I think it is pretty straightforward to use @if command, but I am not able to get it. Please help. Thanks in advance

There are 2 Roles - [RoleA] and [RoleB]
There are 4 views - view1, view2, view3, view4

If a user is a member of both [RoleA] and [RoleB], display view1.
If a user is a member of [RoleA], display view2
If a user is a member of [RoleB], display view3
If a user is not a member of any [Roles], display view4

 

[JottEssTee]

Hi,
@if works like '@if(condition1; action1; condition2; action2;...;else-action).
if you use the @userroles function together with @contains and queue the conditions in the right order, this should not be too much of a problem. If it is, look up the sysntax for the @formulas in the designer help.

 

[pmonett]

Try this :

WkRole1Check:=@if(@contains(@userroles;"[RoleA]");1;0);
WkRole2Check:=@if(@contains(@userroles;"[RoleB]");1;0);
WkRoleBoth:=WkRole1Check+WkRole2Check;
@if(
WkRoleBoth=2;@command([OpenView];"view1");
WkRole1Check=1;@command([OpenView];"view2");
WkRole2Check=1;@command([OpenView];"view3");
"view4")

 

[lespaul]

pretty spiffy pascal! i'm always impressed by your lotus codes & formulas! have a star on me! Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!