Latest Updates

Products & Applications

Showtime
My Blackberry Enterprise Server Push Utility for the Lotus Notes Client, allows you to create Jobs for individual Channel, Message, and Browser Content Pushes, as well as allows you to delete Pushed Channel Icons from defined recipient devices.

Time Tracker
The idea is simple. At the start of your day - upon completion of your first task - create an entry highlighting what you did and whether you feel it was an efficient or inefficient use of your time. Based on several requests, you can also select the priority, apply categories, or even align your time against a project.

For Lotus Notes Client v8.0 and above, you can use the Time Tracker Widget to make this process even easier!

Zephyr
My Configuration-based Rich Text Mail Merge and Emailing Utility, Zephyr allows you to create rich, data-driven emails to support automated workflow - all via Microsoft Word Mail Merge-like architecture. Dear <firstname> allows you to personalize each email message not only to the individual recipient, but also to the individual application workflow event!

xCopy
xCopy is a simple configurable xCopy client for the Lotus Notes client. By creating and defining xCopy Profiles, you can batch process your file backup or remote upload jobs. With the addition of the xCopy sidebar widget, you can easily kick-off these jobs, and modify both the xCopy Profiles and xCopy itself.

Community & Resources

Lotus Technical Information & Education Community

The Lotus Technical Information & Education community is comprised of IBM, business partner, and customer subject matter experts who use product wikis, published articles, white papers, community blogs and the latest in social media to build and share high quality technical content.

OpenNTF.org - Open Source Community for Lotus Notes Domino

OpenNTF is devoted to enabling groups of individuals all over the world to collaborate on IBM Lotus Notes/Domino applications and release them as open source.

developerWorks Lotus : Wikis

Share your deployment experiences and best practices in our wikis and help IBM to create scenarios for successful deployments. Contribute to the community by collaborating on shared content and leverage the shared knowledge from that community.

Quicktip: Web DBLookup API

03/03/2008 03:50:49 PM by Chris Toohey

This is quick-and-dirty, and something that I just put together for a friend of mine who's working on an ever-expanding (scope, that is...) project. It's simple and gets the job done, but can offer both an insight into more advanced architectures as well as a near-limitless application.

Let's take a look at the @DBLookup Function in all it's glory:

@DbLookup( class : cache ; server : database ; view ; key ; fieldName ; keywords )

We'll go with the cookbook method:

Ingredients

  • 1 Form Design Element
  • 1 Navigator Design Element

Long list - I know.

So, we'll start by creating a blank Navigator design element named "dblookup". Now, create a Form design element called "$$NavigatorTemplate for dblookup", setting the Content Type to "text/plain", and adding the following fields:

  • SaveOptions
    • Set to "0", since I don't want this to ever generate content - just render it!
  • Body
    • Which will be a Computed Rich Text field - see Formula below...

The Body Formula:

@DbLookup( @URLQueryString("class") : @URLQueryString("cache") ; @URLQueryString("server") : @URLQueryString("database") ; @URLQueryString("view") ; @URLQueryString("key") ; @URLQueryString("fieldName") ; @URLQueryString("keywords") )

Disgusting isn't it?!

It's usage:

db.nsf/dblookup?open&cache=NoCache&view=someviewname&key=somekeyvalue&fieldName=returnfieldName&keywords=%5BFAILSILENT%5D

This, as you can see, will do a "NoCache" DBLookup in the current database against the someviewname View for somekeyvalue, returning the value from the NotesItem returnfieldName, and returning "" (blank) when the lookup fails.

The reason that I'm using Plain Text as the Content Type is to allow for usage with AJAX functions, and the Rich Text is used to allow bigger lookups. Need it to do something more, expand away!

 
Duncan BradleyName:Duncan BradleyComment

Why go to the trouble of the navigator & $$navTemplate when you can do it with just a form called dblookup? One less element to worry about!

Patrick KwintenName:Patrick KwintenWebsite:http://quintessens.wordpress.comComment

I see the sense of using a navigator in stead of a form for a form is for me something you present to the end user or something you use for creating documents on the background.

Great code!

RobName:RobWebsite:dowork.comComment How about a form with a hidden field into which you can load any formula language you wish; a whole script with @for and @while perhaps? Then the query save agent would do an eval on it and return the result. Of course you might have some security issues ... Rob:-]

(not published)




Evaluate this Formula: @LowerCase(@Text("FOO"))