My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
   
SUBSCRIPTION STATUS
If you are a subscriber to this publication, sign-in to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Go to Article

TECH NEWS

IBM Lotus Notes 6 Tables and Formula Language

New in Notes 6 is the ability to access tables via the Notes Formula language. Here's what you need to know.

By Christopher Pepin, IBM collaborative software strategy program manager


New in IBM Lotus Notes 6 is the ability to access tables via the Notes Formula language. The new @GetFocusTable function returns the table name, row number, or column number for a table that is in focus (i.e., that contains the cursor). To see this function in action, first assume you have a table on a form (figure 1).

In the "OnHelp" event for the form, add the following Formula language code:

rownumber := @GetFocusTable([CellRow]);
@If(rownumber = "0"; @Prompt([Ok]; "There
  is no table in the document"; "Your
  cursor is not located in a table");
@Do(
columnnumber := @GetFocusTable(
  [CellColumn]);
tablename := @GetFocusTable([TableName]);
tablenamedisplay := @If(tablename0 = "";
  "Table has no name"; tablename);
@Prompt([Ok];  "Table";
"Your cursor is located in table: " +
  tablename + ". Your cursor is located
  in row number: " + rownumber + ", column
  number: " + columnnumber)))

When the user has the cursor in the table and presses the F1 key, a dialog appears that shows the table name, row number, and column number of the table (figure 2).

The @GetFocusTable formula works in toolbar buttons and field formulas when the document is in edit mode. It works only in a document in read mode if text or an object is selected in a table. This function doesn't work in Domino Web applications.

Figure 1: A simple table -- Shows how the new Formula Language constructs to manipulate tables.

Figure 2: Prompt box -- The result of executing the @GetFocusTable code.

This tip comes from Christopher Pepin's "Notes 6 Table Enhancements" in LOTUS ADVISOR MAGAZINE. The article provides an in-depth look at the new table features in Notes 6 and shows you how to use them to access and share data more efficiently. Subscribers can read the full article online at http://Advisor.com/doc/14158.


Chris PepinChris Pepin is a senior information technology architect in the IBM office of business transformation and chief information officer (BT/CIO). Chris' responsibilities include the internal deployment of collaboration technologies for IBM's 370,000 employees world-wide.

Printer-friendly
page layout

IBM Lotus Notes 6 Tables and Formula Language

No reader comments ... yet.

    What do YOU think about this topic? Share your advice and thoughts using this form.

    Your Name

    REQUIRED : PUBLIC

    Your E-Mail

    REQUIRED : PRIVATE

    Job, Company

    OPTIONAL : PUBLIC

    City, State, Country

    OPTIONAL : PUBLIC

    Your Web Site

    OPTIONAL : PUBLIC

    Your Comment

    Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.


    Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

    ARTICLE INFO

    Web Edition: 2004 Week 32, Doc #14479

    FREE ACCESS FREE ACCESS

    Keyword Tags: Application Development, Development, IBM, IBM Lotus, IBM Lotus Notes, IBM WebSphere, Lotus @Formula Language, Programming, Software Development, Tables

    Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
    Portions copyright ©1983-2010 Advisor Media, LLC. All Rights Reserved.
    Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
    ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, LLC in the United States and/or other countries.
    Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
    Hosted by Prominic.NET Website powered by
    LOTUS SOFTWARE
    oa PEPIC24 posted 2004-8-2 mod 03/15/2010 03:10:33 AM ztdbms/ztdbms
    domino-144.advisor.com my.advisor.com 03/21/2010 10:29:38 PM