Formula Language Enhancements

This section is dedicated to Formula Language customizations and includes a wide variety of enhancements and working source code that can be incorporated into the projects in this book or any other Notes database.

All code provided in this section is also provided on the companion Web site in a code library database. In many cases, working examples and buttons can be clicked to illustrate each customization module. The code and buttons can also be copied directly into your database. Before implementing any of the solutions, let's spend a moment discussing the content of this chapter.

In some cases, integrating code into a Lotus Notes database may require a reference to a database object such as a form name, field name, view name, or target search string. All of these references must be replaced with the actual design elements in your database and are illustrated in all bold, capital letters.

The following list contains those references that will need to be replaced throughout this Formula Language chapter.

DATABASE.NSF Substitute with a valid Lotus Notes database file name

EMAIL Substitute with a formatted, valid Internet email address

FIELDNAME Substitute with an actual field name

FORM Substitute with an actual form name

PATH Substitute with a valid directory path or folder name

ROLENAME Substitute with a valid role specified in the Access Control List

SERVER Substitute with a valid Domino server name

VALUE Substitute with a text string or numerical value

VIEW Substitute with an actual view name

A working example of all customizations can be found in the developer's toolbox in the BookCodeLibrary.NSF database. See Appendix A for additional information.