Category Archives: Show-n-Tell+Thursday

You show me yours, I’ll show you mine…..

False Positives on Planet Lotus

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 | Leave a comment

Validating URL and Email Addresses with regexp in Lotus Notes

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 | Leave a comment

can’t use @ThisName in Hide-When formulas, LOTUS NOTES meta coding FAIL

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 | 2 Comments

Expanding Group Names for Lotus Domino using LotusScript

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 | 3 Comments

SNTT: a pseudo Computed for Display Rich Text Field in the Lotus Notes Client

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 | 2 Comments

Sacha Chua shares her Lotus Notes mail merge from a Microsoft Excel spreadsheet

By Ian | August 27, 2009

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!

Also posted in Code, Lotus Domino, Toronto | 1 Comment

SNTT : using LotusScript to launch file attachements (EmbeddedObjects) in Lotus Notes

By Ian | August 26, 2009

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 | 3 Comments

SNTT : Don’t hard code your Selectedable Years in a Lotus Notes dialog box.

By Ian | August 13, 2009

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 | Leave a comment

SNTT adding http onto URL strings in Lotus Notes

By Ian | August 13, 2009

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 | Leave a comment

Stopping Copy and Paste, in Lotus Notes, selectivity in Views

By Ian | July 30, 2009

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 | Leave a comment