Michael Brown - Blogging for Dominos

In the past when reserving a Room you were not able to tell when selecting a room from within the Meeting Invitation what the "Owner Restrictions" were set to. You always had to request the room and then wait to see if you received an Accept, Decline or forwarded to room owner for approval. In ND7 Lotus tried to improve this by adding an icon (red circle with a line through it) next to all rooms that have some level of restriction applied to them. The problem is you can't tell the difference between a room that is restricted versus a room that is disabled and even if you are listed as the owner of the room it still shows with as if it's may be restricted. I decided to try and rework the view to see if I could improve on this. I made two different attempts due to limitations I had in programming within a column.

My first attempt is simply showing a different icon based solely on the type of "Owner Restrictions" specified on the Room Document. If you open the ($Rooms) view in the NAB, you can modify the column formula behind the 7th column over. Here's my sample.

@If(AutoProcessType ="D";92;
AutoProcessType = "0";114;
AutoProcessType = "1";120;
AutoProcessType = "2";120;|
AutoProcessType = "3";179;11)

A room that has "None" set as the Owner Restriction will show with a Green Circle.
A room that has "Disabled" set as the Owner Restriction will show a Deny icon.
A room that has "Owner Only" or "Specified People" set as the Owner Restriction will show a Yellow Circle.
A room that has "Autoprocessing" set as the Owner Restriction will show a Forwarding icon.

My second attempt is to show the rooms that are available to the user based on rather or not their name shows as a person who is the owner of a room or listed as a specific person who can reserve the room without owner approval. In addition it shows a different icon if the room requires the invitation to be forwarded to the owner for approval or if the room is just disabled. The only caveat with this formula is it will not work if a group name has been specified in any of the "Owner Restriction" fields when setting up the room.

@If(AutoProcessType ="D";92;AutoProcessType "0";114;
(AutoProcessType="1"&(@Contains(@UserName;AutoprocessForwardTo)=1));114;
(AutoProcessType="1"&(@Contains(@UserName;AutoprocessForwardTo)=0));115;
(AutoProcessType="2"&(@Contains(@UserName;AutoprocessUserList)=1));114;
(AutoProcessType="2"&(@Contains(@UserName;AutoprocessUserList)=0));115;
(AutoProcessType="3"&(@Contains(@UserName;AutoprocessUserList)=1 | @Contains(@UserName;AutoprocessForwardTo)=1));114;179)

A room that has "None" set as the Owner Restriction will always show a Green Circle.
A room that has "Disabled" set as the Owner Restriction will always show a Deny icon.
A room that has "Owner" set as the Owner Restriction will show a Green Circle if you are listed explicitly as an owner; otherwise, it shows a Red Circle.
A room that has "Specified People" set as the Owner Restriction will show a Green Circle if you are listed explicitly as an owner or specific person; otherwise, it shows a Red Circle.
A room that has "Autoprocessing" set as the Owner Restriction will show a Green Circle if you are listed explicitly as an owner or specific person; otherwise, it shows a Forwarding icon to everyone else because it will forward you request to the room owner.
Remember, these formulas will not work if you include a Group Name in any of the Owner Restriction fields because I haven't figured out how to make a column formula perform a lookup to expand the contents of the group.