Ian Irving's Code and Culture from Toronto
Suppose you need to ensure that a value is unique for a field for a given form and the documents created by that form. Like a “CompanyName” field on a “Company” form. How would you go about that in the Lotus Notes client? Continue reading SNTT : Test for Unique values in a Lotus Notes Form field
Back in February I posted Structured DBlookup’s in Lotus Notes. Very popular. Implicit in that was that the same could be applied to DbColumn’s, but the web (and Google) is all about being explicit, so here we go : 12345678class Continue reading SNTT Structured DbColumn’s in Lotus Notes
As an update to Export any Lotus Notes View to CSV or Excel, automagically, and as an answer to a being asked how you would do this, here is some similar code to export a view from the web brower Continue reading SNTT : Export any Lotus Notes View to Excel from Domino Web, automagically
Here is a some very generic code which will work on any Lotus Notes View to print out the contents to a Comma Separated Value (CSV) file, or as an Excel File, with minimum formating, as a general export routines. Continue reading SNTT : Export any Lotus Notes View to CSV or Excel, automagically
I needed to display for “regular” users information that was maintained database wide (preferable via a profile form). Although the usual “@Command( [EditProfileDocument] ; formname; uniqueKey )” worked fine for the db admin people to edit/maintain the information, there was Continue reading Opening a Lotus Notes Profile Document in Read Only mode
A quick and dirty way for doing this. No error checking, big assumptions about the input to the prompt being right. 12345nd := @Prompt([OKCANCELEDIT]; "Enter the New Date"; "YYYY/MM/DD."; @Today); @If (nd ="";@Return("");""); y := @Left (nd;"/"); m := @Left(@Right Continue reading Q&D Action button to set Date Value with Lotus Notes Formula Language