On our Notes client we have a department wide address book (Names.nsf) that has all the contacts and mail groups within the department. I have a DB used on the client that has a Readers field that pulls up the window for the user to choose a person within the department wide address book. What I want to do is only allow the user to open up the ‘People’ view within Names.nsf and not both people and mailgroups. (I don’t want to give them the ability to choose a mailgroup.)
I was thinking of doing this through a @DBColumn formula, but is there an easier way that someone knows will work?
Subject: Address Book dialog box
You could use the @PickList function to force selections from any address book view you want. For example
@PickList( [Custom]; “”:“names.nsf” ; “($VIMPeople)” ; “Select Document Readers” ; “Select the people you want to have read access to this document” ; 1)
will let your users choose multiple people from the address book.
I’d recommend that you manipulate the value that you place in the Readers field so that you (a) add a role such as [Admin] so that you can always get back into these protected documents and (b) format the names in full distinguished name style (“CN=John Doe/O=Acme”). You can probably use @NameLookup and @Name for the latter.
Another alternative would be @DBColumn as you mentioned. This would be unwieldy if your directory is any reasonable size, however.
A third approach would be to use a canned lookup such as @PickList( [Name] ) but then to test the type of entry returned and to force the user back into the dialog if they don’t choose a person.
Hope this gives you some options!
Rupert Clayton
Chicago