|
|
|
|
|
|
|
|
|
|
|
|
|
|
Managing database ACLs from a browser (continued)
Beside the "name" field, create an editable text field named "acles". We'll use this field to store all the ACL entries (usernames) as compiled by our LotusScript agents. Similarly, create a field named "dbroles" to store the database role names.
Now create a computed text field named "dbpath" and give it the formula:
This will create a Web-accessible path to the current database that we can use to build URLs referencing this database and form.
In the example back in Figure B, I created some descriptive text and a computes text field with the formula "@DBTitle" to let users know exactly which database they are managing the ACL for.
Next, create a field to hold the value for the maximum Internet user access level for this database. This is a dangerous setting to let Web users change, because if they set the maximum level below "Manager" they won't be able to use this form anymore to change the ACL. Name this drop-down list field "mxInet". The choices for this field should be the following text list:
No Access | 0
Depositor | 1
Reader | 2
Author | 3
Editor | 4
Designer | 5
Manager | 6
|
Next to this field create a button "Set" which has the formula:
@Command([ToolsRunMacro];"Inetlvl")
|
This will call an agent to set the ACL's max Internet access level.
We now need to create a field to hold the users already listed on the ACL. We're going to make this a drop-down list and setup the form so that whenever a username is selected in this field all the other fields on the form will be updated to reflect the settings of that user. The choices formula for this form should be:
The first line of this formula takes the values in the acles field and turns them into a Notes List using the string "*!*" as the delimiter between entries. I chose this string because it's highly unlikely that it will ever occur in someone's Domino username. The second line constructs a choice list for the field in the format "Daniel Koffler | CN=Daniel Koffler/O=Koffler Consulting" where the part to the left of the vertical bar is the display name for the choice and the right hand portion is the user's hierarchical name URL encoded so that it can be passed in the query string. The default value formula for this field should be:
@URLEncode("Domino";name)
|
When you select one of the values in this field, we want the form to recalculate based on the ACL settings for the username selected. Because we're going to get all of our information from agents, we need to pass the value of the username we are looking for to the agent. To do this we need to add an entry to the onChange event of the "users" field, it should be set to the following JavaScript:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Find unused Lotus Notes groups and clean up your address book
Have you ever wanted to get rid of old Lotus Notes groups that were cluttering up your address book, but you weren't sure if they were used? Find Unused Groups can help.
Find Unused Groups will check your ACL, mail, multi purpose and server groups to help you determine if they are used, and who uses them.
Learn how to easily clean up your address book. |
-- Advertisement --
Integrate your Notes Applications with Microsoft Office and Symphony
Integra for Notes Integrates Microsoft Office and/or IBM Lotus Symphony
Requires NO change to the design of the appliation or Installations of DLL's and EXE's
- Integra is a ready to use solution, enhance static reports with Excel data analysis, pivot tables, macros
- User friendly aproach, using a point and click access to features
- Reports from any Lotus Notes databases
- Runs reports through a Notes client, web browser and scheduled basis
- Allows use of LotusScript for advanced data manipulation
- Enables self service reporting capabilities to end-users
Learn more at www.integra4notes.com. |
|
|
|
|
|
|
|
|
|
|
