By Ian | September 25, 2009
Once upon a time, 2006, there was “Show ‘n Tell Thursdays – A Project Of The Lotus Notes And Domino“, and the SNTT tag is still used, but Planet Lotus is where the action is now, an aggregation of Lotus related blogs and news.
Recently False Positives was accepted for inclusion as part of that community. [...]
Also posted in Code, Lotus Domino, Site |
By Ian | September 17, 2009
I needed to recreate this from scratch, and so I’m documenting this here for the next time.
Most of the credit should go to Julian Robichauxand his ls2j examples db, and in particultar the JakartaOroWrapper Library
My “invention” involves creating a isValidateURL and isValidateEmailAddress Regular Expression (or regexp ) routines that worked for me.
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647Uselsx "*javacon"
Use [...]
Also posted in Code, Lotus Domino |
By Ian | September 11, 2009
I had hoped to use the “@ThisName” to get the suffix of the field name “Comment_1″ and hide it if the Field “Status_1″ is “Pending” by doing this :
1234Suffix := @Right(@ThisName; "_");
EmpListFieldName := "Status_" + Suffix;
Status_value := @GetField(EmpListFieldName);
@If( Status_value = "Pending";@Return(@True);@Return(@False));
but it didn’t work
finally traced it down to the “@ThisName” formula and [...]
Also posted in Code, Lotus Domino |
By Ian | September 8, 2009
I needed to find the people that belonged to a given lotus Notes group. It couldn’t be a simple lookup since other groups can and frequently are also members of a group, so it needed to be be recursive.
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556Function expandGroupListMembers(GroupName) As Variant
Dim session As New NotesSession
Dim db As NotesDatabase
Dim gView As NotesView
Dim memberList As [...]
Also posted in Code, Lotus Domino |
By Ian | September 3, 2009
As in last weeks posting, I wanted to have help verbiage centrally maintained (without developer innervation) but always displayed update in the end user document (the final end user). Easy enough to do with text or on the web, but doing this with rich text (pictures and text markup) on the Notes Client [...]
Also posted in Code, Lotus Domino |
Toronto’s Connector extraordinaire Sacha Chua developed this super-nifty Lotus Notes script which does a flexible mail merge from a Microsoft Excel spreadsheet to Lotus Notes, as documented and shared in Lotus Notes mail merge from a Microsoft Excel spreadsheet.
Keep on Coding, Sharing, Story telling, and Connecting!
I wanted to launch a excel (xls) file which was stored in a Profile document, from a Notes Client (tested in r8.5 but I see no reason this will not work in versions going back to r5)
(Making it available to all users of a certain type of document with making hundreds of replicate copies, and [...]
Also posted in Lotus Domino |
Hard coding is bad, bad , bad. Very bad, okay? (see Avoiding Hard Coding of Group Names).
Here’s a quick and dirty way to have a drop down dialog which selects the “Year” and not be hard coded.
1234currentYear := @Year(@Now );
@Text(currentYear-1) :
@Text(currentYear) :
@Text(currentYear+1)
which results in a multip value list of (for this year) “2008″ : [...]
Also posted in Lotus Domino |
The challenge was to have end users enter url’s (or uri’s) for content and have it presented as a link on the read only end part of the site. The problem is that means having “http” (or “https”) -which indicates Hypertext Transfer Protocol – appended to the string, if it was not supplied by [...]
Also posted in Lotus Domino |
Previously, I showed how to globally Stop Copy and Paste, in Lotus Notes using formula language, at the database event level. I also mentioned how to allow some documents to be pasted in. (in the Notes Client)
What if you wish to just shut down copy and paste in a few views but not all? [...]
Also posted in Lotus Domino |