Home       About Genii       Products       Downloads       News & Events       Support       Weblog   
July, 2008
SMTWTFS
  01 02 03 04 05
06 07 08 09 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
July, 2008
June, 2008
May, 2008
April, 2008
March, 2008
February, 2008

Show all 63 months


Search the weblog

Ben Langhinrichs
E-mail address - Ben Langhinrichs

Photograph of Ben Langhinrichs



©2003-2008 Genii Software Ltd. All rights reserved. The rights to all logos, images, etc. are owned by their respective owners.

The views expressed in this weblog are mine alone, but since I am President and Owner, they necessarily also reflect the views of Genii Software, Ltd.
Genii Weblog
Genii Weblog

@DbColumn/@DbLookup on rich text tables

Wed 17 Sep 2003, 11:20 PM

I thought I'd focus on a few of the things we are trying out with our new @Midas Formulas, which is beta.  If you would like to sign up for the beta test, we are planning on sending out a new beta release shortly.  If you are already signed up, even if you haven't received a beta yet, you will be contacted automatically.

@DbColumn/@DbLookup on rich text tables
One of the really interesting features is the ability to treat rich text tables as data, a mantra some of you who have seen me speak at Lotusphere may have heard before.  Why shouldn't you be able to retrieve data from tables in rich text fields?  Why shouldn't you use commands most Notes developers are very familiar with for retrieving that data?

Well, with @Midas Formulas, you can do this.  For example, if a table such as this one from the Partnerworld site were in a rich text field called Body on the current document:
IBM Value Package for DevelopersAnnual fee
North America, Europe, Middle East, Africa $595 
Latin America $750 
Asia Pacific region$350


you could specify a command such as:

prices := @DbColumn("Midas"; @DbName; @DocumentUniqueID; "Body"; 2; "Format='Currency' SkipTitle='Yes' ");

and prices would be three numeric values in a multi-value list.
You could also specify a formula such as:

price := @DbLookup("Midas"; ""; @DocumentUniqueID; "Body"; "Latin America"; 2);

and price would be a string "$750"

Pretty cool, eh?  You can do this to avoid using separate documents for rows of data.  What is particularly cool is that exactly the same lookups would work with exactly the same results if your table looked like this:
IBM Value Package for DevelopersAnnual fee
North America, Europe, Middle East, Africa $595 
Latin America $750 
Asia Pacific region$350


Even the use of background colors, text attributes and graphics, which help make the data more presentable when the rich text field is displayed, do not prevent use of @DbColumn and @DbLookup.  So, does that make you think maybe you would like to take a look at @Midas Formulas?

What's been said:

51.1. hallo (01/30/2004 01:21 PM)

hallooaoaoao

Have your say:

Name *:
E-mail:
e-mail addresses will not be displayed on this site
Notify me of other comments

Comment *:


<HTML is not allowed>
Linking: Add links as {{http://xxx|title}}, and they will be activated once approved
Blocked? Unable to post a comment? Please read this for a possible explanation...

Copyright © 1996-2008 Genii Software Ltd. All Rights Reserved. Some images courtesy of BigFoto.com  Nedstat