If you have a large domain with hundreds of rooms and dozens of organizational units, this Formula lookup can help you perform a narrow search for a specific room in a certain OU. The code can be used on custom forms or when customizing your mail template for meetings.
xxReserve := @PickList( [Custom]:
[Single]; "<Replica ID>" ; "($Rooms)" ;
"Please select the products you want to order" ;
"Get a Room";2;"<OU Category>");
FIELD RoomToReserve := @Trim(@Unique(xxReserve));
@If( xxReserve = "";
@SetField("RoomToReserve";xxReserve);
@SetField("RoomToReserve";
@Trim(@Unique(xxReserve))));
@True
Here, the trim and unique code only needs to be computed once:
xxReserve := @Trim(@Unique
(@PickList( [Custom]:[Single]; "
<Replica ID>" ; "($Rooms)" ;
"Please select the products you want to order" ;
"Get a Room";2;"<OU Category>")));
FIELD RoomToReserve := xxReserve;
@SetField("RoomToReserve";xxReserve);
@True
—Erika H.
Do you have comments on this tip? Let us know.
Related information from SearchDomino.com:
This tip was submitted to the SearchDomino.com tip library by member Larry Stover. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.
This was first published in November 2005