Developing IBM Lotus Domino Applications - Intermediate Skills

Skills taught:
After completing this course, you should be able to:
Use formula language to inspect and manipulate text values and lists, and use iterative statement functions.
Implement functions that interact with users through different types of dialog boxes using .
Implement advanced view design features to enhance how Lotus Notes displays documents.
Examine and use several IBM Lotus Domino design elements as navigation structures, including links and imagemaps.
Create and embed an outline.
Work with framesets and frames.
Access data in Lotus Domino databases by using formula language and profile documents.
Use the formula language to access data sources using the Microsoft Open Database Connectivity (ODBC) interface.
Examine Domino Enterprise Connection Services (DECS) and implement real-time data mapping between an IBM Lotus Domino application and a relational database.
Implement workflow in Lotus Domino applications.
Secure Lotus Domino application data by controlling access and encrypting data.
Course outline:
Lesson 1: Working with Strings, Lists, and Loops
Topic 1A: Writing Formulas to Manipulate Text Values
Useful Functions for Inspecting and Searching Text
Inspecting and Searching Strings
Useful Functions for Parsing a String
Examples of Parsing a String
Topic 1B: Working with Lists
Creating Lists
List Operations
Using the List Subscript Operator
Useful Functions for Inspecting Lists
Useful Functions for Modifying Lists
Useful Functions for Converting Lists
Topic 1C: Creating Iterative Formulas
Iterative Statement Functions
Using a For Loop
Using a While Loop
Using a DoWhile Loop
Lesson 2: Writing Formulas to Interact with the User
Topic 2A: Using
Introducing
Examples of User Prompts

Topic 2B: Working with

Using
Creating a Form /
Topic 2C: Using Layout Regions
Layout Regions
Creating a Layout Region
Adding Elements to a Layout Region
Lesson 3: Advanced View Design
Topic 3A: Using a Background Image in a View
Background Images
Background Image Formatting Options
Adding a Background Image to a View
Topic 3B: Hiding a View Column
Hiding Columns
Using a Formula to Hide a Column
Topic 3C: Modifying View Elements
Highlighting View Documents
Programmatically Setting Colors in a View
Creating a View Column to set the Colors of a Row
Using Values to Specify the View Text Color
Using Values to Specify the View Background Color and Text Color
Hiding the Color Column
Expanding a Column to Use the Available Width
Topic 3D: Working with Embedded Elements
Adding an Embedded Editor to the Form
Preventing a Document from Being Saved
Combining Embedded Elements
Embedded Schedulers
Lesson 4: Adding Navigational Elements Using Links and Imagemaps
Topic 4A: Linking to Other Documents and Pages
Types of Links
Creating a Link Hotspot on a Page or Form
The Hotspot Resource Link Properties
Named Element Links
Creating a Named Element Link in the Properties Box
URL Links
Creating a URL Link
Topic 4B: Creating Imagemaps
Imagemaps
Describing Hotspots on an Image
Creating a Hotspot on an Image
Lesson 5: Working with Outlines
Topic 5A: Creating an Outline
The Outline Design Element
Process of Creating an Outline
Create an Outline
Default Outlines
Creating a Default Outline
Topic 5B: Adding Outline Entries
Outline Entries
Creating a Hierarchical Outline
Creating an Outline Entry
Topic 5C: Modifying Outline Entries
Setting Outline Entry Properties
Indenting and Outdenting Outline Entries
Topic 5D: Embedding an Outline
Embedding Outlines
Embedded Outline Properties
Formatting an Embedded Outline
Lesson 6: Creating a Frameset
Topic 6A: Adding a Frameset to an Application
What are Frames?
What are Framesets?
Structuring a Frameset
Guidelines for Designing Framesets
Creating a Frameset
Topic 6B: Adding Content to a Frame
Specifying Frame Information
Specifying a Content Source
Using a Target Frame
Specifying the Default Target Frame
Target Frame Precedence
Placing a Page in a Frame
Topic 6C: Launching an Application Frameset
Setting Database Properties to Launch a Frameset
Topic 6D: Adjusting Framesets
Adding New Frames to a Frameset
Launching Individual Elements in a Specific Frame
Opening Documents in a Frame
Setting a Target Frame
Lesson 7: Accessing Data in IBM Lotus Domino Databases
Topic 7A: Accessing Data from a View
Common Arguments
Options for Caching the Results of a Lookup
Guidelines for Caching the Results of a Lookup
Specifying a Database for Lookups
How Lotus Notes Searches for a Replica


Optional Keywords
Optional Keywords /
Topic 7B: /
Advantages
Styles of PickLists
Displaying a View
Displaying a Domino Directory View /
Topic 7C: Working with Profile Documents
Introducing Profile Documents
Characteristics of Profile Documents
Guidelines for Using Profile Documents
Designing a Form for Creating Profile Documents
Creating a Profile Document with Formulas
Reading Data in Profile Documents
Updating Data in Profile Documents
Lesson 8: Accessing Non-Domino Data
Topic 8A: Introducing Microsoft Open Database Connectivity
Using ODBC
Working with ODBC Drivers
ODBC Driver Configuration
ODBC Driver Configuration
Example dBase Table
Topic 8B: to Access an ODBC Data Source
Accessing Relational Data from IBM Lotus Domino with ODBC
Comparing that use ODBC


/
Lesson 9: Mapping Data Between IBM Lotus Domino and Relational Databases
Topic 9A: Introducing IBM Lotus Domino Enterprise Connection Services
Data Mapping
Data Mapping in Lotus Domino
Using DECS
How DECS Communicates with the External Data Source
Capabilities of DECS
Topic 9B: Working with DECS
The DECS Server Task
Working with the DECS Administrator Database
Topic 9C: Using Data Connection Resources (DCRs)
Working with DCRs The DECS Administrator Database and DCRs
Using DCRs
Creating a Data Source Resource for ODBC Access
Creating a DCR
Basic Properties of a DCR
Optional Properties of a DCR
Associate a Form with a DCR
Mapping Fields to External Table Fields
Importing External Data
Enabling a Lotus Domino Database to Use DCRs
Lesson 10: Adding Workflow to IBM Lotus Domino Applications
Topic 10A: Defining Workflow
Benefits of Automating the Process
Elements of Workflow
Using a Workflow Diagram
Example of an Expense Reimbursement Workflow Diagram
Workflow Elements of the Expense Reimbursement Process
Topic 10B: Routing Workflow Objects in IBM Lotus Domino
The Routing Process
Ways to Route Documents
Making a Mail Database Known to the Router
Making an Application Database Known to the Router
Topic 10C: Designing Workflow
Triggering Workflow
Identifying the Recipient
Identifying the Data to Send
Sending the Data
Topic 10D: Notifying Users
Sending a Doclink /
Topic 10E: Routing Entire Documents
Examples of Routing Entire Documents
Configuring the Application to Route Documents
Enabling Recipients to Read Documents
Using a Form Formula in a View
Topic 10F: Sending the Current Document
Defining the SendTo Field
Creating a SendTo Field
Parameters
Using the Present Send Mail Dialog Property
Using the
Using the Send Document Simple Action
Using the MailOptions Field
Forcing a Document to Route Using a MailOptions Field
Topic 10G: Tracking Documents
Collecting Information on the State of a Document
Creating a History Log
Adding a Tracking Field to a Form
Creating a Tracking View
Lesson 11: Securing IBM Lotus Domino Application Data
Topic 11A: Limiting Who Can Read and Edit Sections
Using Access-Controlled Sections
Creating an Access-Controlled Section
Limiting Who Can Edit a Section
Topic 11B: Signing Documents and Mail
Enabling Signing Documents and Mail Messages
Creating a Sign-Enabled Field
Signing an Access-Controlled Section
Topic 11C: Encrypting Domino Data
Determining What to Encrypt
Types of Encryption Keys
Using Public and Private Keys
Using Secret Keys
Topic 11D: Creating and Distributing Secret Keys
Creating a New Secret Encryption Key
Distributing Encryption Keys with E-mail
Exporting a Secret Encryption Key to a File
Merging an Encryption Key Received by E-Mail
Importing an Encryption Key Received as a File
Topic 11E: Encrypting Fields
Enabling Encryption for a Field
Applying Encryption
Applying Encryption Automatically
Providing a List of Secret Encryption Keys in a Field