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.
Contact Information
Blogger, podcaster, writer, and geek Chris Toohey covers topics from application development to the latest must-have-gadgets.
Latest Updates

More on Mailer...
More on Junction Lite...
More on Remote Console...

More on Controller API Utility...
Products & Applications
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!



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!
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!