The target audience for this course is application developers who have experience creating or modifying single database applications with Lotus Domino Designer 6, 7, or 8.
This course builds on the skills the IBM Lotus Domino 8 Application Development course. Through instructor lecture and studentcentered activities and exercises, students learn to use IBM Lotus Domino Designer 8 to develop multidatabase applications. The course explores advanced formula techniques including looping and user interaction with the application. The course explains different methods for accessing data sources outside the current Domino database including other Domino databases and relational databases. Other topics include adding workflow functionality to route documents and notify users that a document requires their attention, and security issues such as encrypting data. This course also examines navigation elements such as links, outlines, and framesets that bind the components of the application together and allow users to locate information quickly and easily.
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 the @Prompt Function Introducing The @Prompt Function Examples of User Prompts The @Prompt Function @Prompt Styles Topic 2B: Working with the @DialogBox Function The @DialogBox Function Using the @DialogBox Function Creating a Form for @DialogBox 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 for @Db Functions 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 Using @DbColumn Using @DbLookup Optional Keywords for @DbLookup Optional Keywords for @DbLookup Topic 7B: Using @PickList Advantages of @PickList Styles of PickLists Displaying a View with @PickList Displaying a Domino Directory View with @PickList 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: Using @Db Functions to Access an ODBC Data Source Accessing Relational Data from IBM Lotus Domino with ODBC Comparing the @Db Functions that use ODBC Using @DbColumn Using @DbLookup Using @DbCommand 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 Using @MailSend 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 Using @MailSend Without Parameters Using the Present Send Mail Dialog Property Using the MailSend @command 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 Useful @functions for 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
After completing this course, students 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 the @Prompt and @DialogBox functions. · 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 realtime 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.