Using the Formula Language

By Steve Kern

  • Overview of the Formula Language
  • Knowing Where to Use @Functions and @Commands
  • Formula Syntax
  • Limitations of the Formula Language
  • Working with Statements
  • Using Logical @Functions
  • Working with Date and Time @Functions
  • Working with Strings
  • Getting Session and User Information
  • Working with Documents
  • Retrieving Data with @DbColumn and @DbLookup
  • Working with Lists
  • Getting User Input
  • Controlling the Flow of a Formula
  • Error Handling

The Formula language has been around since the inception of Lotus Notes. In some respects, it is an offshoot of Lotus 1-2-3, which, if you'll recall, is loaded with commands prefaced with the @ symbol. The Formula language has three primary constructs ”@Functions, @Commands, and five keywords. Although you can program Domino applications in other languages, in a number of locations you can use only the Formula language.

Notes and Domino 6 has extended the Formula language, adding many new and enhanced @Functions and @Commands, as well as enhancements to the language rules. As discussed in Chapter 3, "The Integrated Development Environment," the autocomplete functionality added to the Programmer's pane is a welcome addition.


Because there are so many @Functions and @Commands, it is not possible to cover each and every one. instead, this chapter concentrates on the ones you will use frequently.

Part I. Introduction to Release 6

Whats New in Release 6?

The Release 6 Object Store

The Integrated Development Environment

Part II. Foundations of Application Design

Forms Design

Advanced Form Design

Designing Views

Using Shared Resources in Domino Applications

Using the Page Designer

Creating Outlines

Adding Framesets to Domino Applications

Automating Your Application with Agents

Part III. Programming Domino Applications

Using the Formula Language

Real-World Examples Using the Formula Language

Writing LotusScript for Domino Applications

Real-World LotusScript Examples

Writing JavaScript for Domino Applications

Real-World JavaScript Examples

Writing Java for Domino Applications

Real-World Java Examples

Enhancing Domino Applications for the Web

Part IV. Advanced Design Topics

Accessing Data with XML

Accessing Data with DECS and DCRs

Security and Domino Applications

Creating Workflow Applications

Analyzing Domino Applications

Part V. Appendices

Appendix A. HTML Reference

Appendix B. Domino URL Reference

Lotus Notes and Domino 6 Development
Lotus Notes and Domino 6 Development (2nd Edition)
ISBN: 0672325020
EAN: 2147483647
Year: 2005
Pages: 288 © 2008-2020.
If you may any questions please contact us: