Display All Documents by Form Name

Databases that contain multiple forms can sometimes be cumbersome to managemaking it difficult to locate documents when errors occur. In other words, if the selection criterion for each view is based on the form, its possible that some documents may never be visible due to the view formula.

One method to manage this problem is to create a view, possibly restricted to just the database administrator or developer, that categorizes documents by the form name. This way, every document in the database will be accessible.

How It Works

By setting the first view column formula to Form, all documents in the database will be grouped together by form name. For example, lets say you have a service request database that includes the following forms:

  • Move Offices
  • Reset Password
  • Revoke UserID
  • Workstation Problem
  • Manager Lookup
  • Employee Lookup
  • System Configuration

In this example, the database includes four forms used to manage service requests (Move Offices, Reset Password, Revoke UserID, and Workstation Problem), two forms used to display custom dialog boxes (Manager Lookup and Employee Lookup), and a general form used to manage application settings (System Configuration). By creating a view where the selection formula is set to @All, all documents will be visible from a single view.


To implement, select the Create > Design > View menu options. When prompted, be sure the Copy style from view field is set to -Blank-. To change this value, click the Copy From button. Also make sure the selection conditions are empty. Give the view a unique name such as All Documents. Next, select the Select by Formula checkbox and click OK to create the view.

When the newly created view is displayed, the Designer client will immediately display the properties dialog for the view. Click on the default column to make this the active design element. Then in the properties dialog, name the column Form and switch to tab 2. Set the sort order to Ascending and display type to Categorized (see Figure 15.5). Close the properties dialog.

Figure 15.5. Example view sorted by all the various database forms

Finally, with the column still in focus, change the display type to Formula and add the following in the Programmers pane.


Save and close the view.

An Introduction to the Lotus Domino Tool Suite

Getting Started with Designer

Navigating the Domino Designer Workspace

Domino Design Elements

An Introduction to Formula Language

An Introduction to LotusScript

Fundamentals of a Notes Application

Calendar Applications

Collaborative Applications

Reference Library Applications

Workflow Applications

Web Applications

Design Enhancements Using LotusScript

Design Enhancements Using Formula Language

View Enhancements

Sample Agents

Miscellaneous Enhancements and Tips for Domino Databases

Data Management


Application Deployment and Maintenance


Appendix A. Online Project Files and Sample Applications

Appendix B. IBM® Lotus® Notes® and Domino®Whats Next?

Lotus Notes Developer's Toolbox(c) Tips for Rapid and Successful Deployment
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
ISBN: 0132214482
EAN: 2147483647
Year: N/A
Pages: 293
Authors: Mark Elliott

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net