The Problem: Drowning in My Own Automation As an IT Pro, I run a lot of automation. Scheduled agents, background jobs, sync processes — code I’ve written over the years that quietly does its job across various databases. Almost all of it has one habit in common: when something happens (good or bad), it […]
Continue Reading
If you’ve been running HCL Notes and Domino for any length of time, you already know the platform has a habit of quietly sitting on years — sometimes decades — of company knowledge. Support tickets, policy documents, contracts, project notes, client history. It’s all in there. The problem has always been finding the right piece […]
Continue Reading
If you’re running HCL Notes/Domino on the 12.0.2 stream, there’s a fix pack sitting in the HCLSoftware download portal right now that’s worth ten minutes of your attention. HCL released Fix Pack 8 (FP8) for 12.0.2 on May 7, 2026, with language kits following a day later, and it’s not a minor cleanup release. It […]
Continue Reading
If you have ever tried to open a document, run an agent, or replicate a database in HCL Notes (formerly IBM Lotus Notes) and Domino, you have probably run into this exact message: “Database has not opened yet.” It is one of the most common — and most misunderstood — error messages in the entire […]
Continue Reading
HCL Notes doesn’t provide a direct way of working with a master-details scenario, may be because it’s not a relational database system where Primary-Foreign-Key relationship entails the designer platform to provide some efficient mechanism to entertain this particular scenario. So we need to devise some alternate methodology to achieve it. So in order to […]
Continue Reading
While developing in IBM/HCL Notes you may stumble across the situations where your search of documents requires more than one key. The custom function placed below provides you with the same facility. Its prototype is pretty simple, it gets the form name, first field name and its key value, and second field name and its […]
Continue Reading
Notes doesn’t provide a simple way to show a multi-line rows based on a field or column which has multiple rows. There’s a work-around though, a bit tricky but works the perfect way. Let’s give it a whirl!!! In the View Properties box: From the 3rd tab, Set a number for “Height” value under Rows […]
Continue Reading
IBM Notes’ Formula Language is a powerful and versatile tool which can do almost everything a robust programming language may offer. It is used in forms, views, agents and almost all design elements and it can also be invoked from Lotus Script. Formula language provides this powerful functionality through a wide range of @functions. These […]
Continue Reading
The following function returns a List of Names (users) given a comma-separated-value string of levels: 0-No Access, 1-Depositor… 6-Managere.g: Levels = “1,2,3,4” or “4,5,6” or “5”The users having one of these access levels are returned in a list.
Continue Reading
The following function removes the duplicate values from a profile field, or any multi-value field (FieldName), in a profile document or a regular notes document. Function RemoveDuplicateValue(Source As NotesUiDocument, FieldName As String) Dim Indexresult As Variant Dim UniqueArr As VariantIndexresult=Source.Document.GetItemValue(FieldName) ”Get the field values into arrayUniqueArr= Arrayunique(Indexresult,1) ”Copy array but with unique items only. Call […]
Continue Reading