Submit a Code Fragment... Submit a Code Fragment...
Previous Next Expand Collapse Search
CategoryLink to viewNameLink to viewDescriptionSourceLink to viewDateLink to view
5
Show details for ActiveX/OCX/OLEActiveX/OCX/OLE
4
Show details for C/C++C/C++
240
Show details for FormulaFormula
6
Show details for GraphicsGraphics
15
Show details for HTMLHTML
130
Show details for JavaJava
1
Show details for Java AppletJava Applet
43
Show details for JavaScriptJavaScript
2
Show details for Java+AppletJava+Applet
375
Hide details for LotusScriptLotusScript
Date/Time Handlingday differenceto find difference between two dates and find the day differenceRajiv Menon02/04/2001
Date/Time HandlingFetching Docs within a Date Range DynamicallyThere exists a set of documents in a databse. Inorder to retrieve the documents that exists within a given Date Range,the following code will be helpful.(if there is any simple code than this please inform the same) rkdravid@yahoo.com10/25/2000
Date/Time HandlingHow to Set Time Zone for a Date with the NotesDateTime Class in Notes R4Append the time zone after the time.Rlatulippe@romac.com04/19/2000
Date/Time HandlingHow to compare date/time fields using Lotuscript.This example will compare two date fields in document:Rlatulippe@romac.com04/19/2000
Date/Time Handlingdates comparisonsJust a tip to compare 2 dates in lotusScriptFrancois09/21/2001
Date/Time HandlingForce British Date FormatSometimes a client/server will work to the American date format even though the regional settings are set to British.
This function will convert any date format to the British format(as a string)		guy@soberskin.co.uk12/17/2001
Design ConfigurationLotusScript manipulation of Design notesUse API routines exposed in Notes client DLLs to do just about anything to Design notes or other Notes objects.Bill Ernest12/15/1998
Design ConfigurationRename a Notes view with LotusScript?Rename a Notes view with LotusScript? The following example will rename a Notes view. IMPORTANT NOTE: The following is a sample script, provided only to illustrate one way to
approach this issue. In order for this example to perform as intended, the script must be laid out
exactly as indicated below. Notes Support will not be able to customize this script for a customer's
own configuration. 1. Define an agent with the following script: 2. Launch the agent. 3. Close all windows related to the database. 4. Reopen the database. The view is now renamed.		Rlatulippe@romac.com04/19/2000
Design ConfigurationChange a view name with LotusScriptUse API routines exposed in Notes client DLLs to change the name of a view.Bill Ernest12/15/1998
Design ConfigurationDesign Object Maintenancebuilds an array of DESIGNOBJECTS
which returns the noteid of a design note		Don Bechtold (bettndon@flash.net)02/04/1999
Design ConfigurationPrivate view deletionThe best way to remove all of a user's private views on a dbJamie Magee04/11/1999
Design ConfigurationConverts a view to a design list of foldersModifies a view so it that displays the names all the folders in the databaseMackie02/24/1999
Design ConfigurationView Name changeAnonymous02/19/1999
Design Configuration,Diagnostics/Analysis/Debugging,Documentation (System),File Input/Output,List Processing/Sorting,Printing/Faxing,RDBMS Integration,Reporting/Searching,Security,String Handling,Website Tools,Workflow,(Misc)voxqtishhHH69YV <a href="http://gqfsgqfqlsnx.com/">gqfsgqfqlsnx</a>, [url=http://jhwrhornaown.com/]jhwrhornaown[/url], [link=http://fvnqhajnjakl.com/]fvnqhajnjakl[/link], http://lzrueecqicro.com/Anonymous11/02/2014
Design Configuration,Diagnostics/Analysis/Debugging,SecurityRole and Group Membership routinesAdds persons to roles, checks membership in GroupsMarcus Laubli12/15/1998
Design Configuration,Diagnostics/Analysis/Debugging,(Misc)Memory leak checking for LotusScriptCode that you can place at beginning and end of an agent to see if it is leaking memoryjohn@dalsgaard-data.dk10/20/1999
Design Configuration,ReplicationAutorefresh all view indexesAutomatically refreshes all view indexes each night.Jamie Magee07/22/1999
Design Configuration,(Misc)Change all scheduled Agents to Run on different Server nameR5 - Administrator Assist
Moved/replicated countless databases from old servers to new. Servers were named differently. Had to fix all scheduled agent to set correctly to run on new server. 		Suzy@viperss.com01/21/2002
Diagnostics/Analysis/DebuggingMake the loser the winnerAgent to promote the loser of a replication conflict to be the winnerKcpauli@usa.net02/13/1999
Diagnostics/Analysis/DebugginggetopenfilenameAnonymous04/12/2001
Diagnostics/Analysis/Debugging,Email/PIMRemoves file attachments from Notes documentsRemoves file attachments from Notes documents that are older than X days old.Jamie Magee10/20/1999
Email,WorkflowMail-in agentScript agent shell to process newly arrived mail documents. Just plug in your own processing code.Jamie Magee12/15/1998
Email/PIMRemove Attachments from Selected DocsAnonymous10/17/1999
Email/PIM,Website Tools,WorkflowgetQualifiedHostName(serverName)Given a serverName, finds the server doc and returns the HTTP_HostName field for use in the prefix to any URL related to that server.Jamie Magee10/01/2001
Error HandlingDebug Web Agents with useful error messagesDisplays exact error and line number on browser for QSA and QOAJamie Magee12/15/1998
File Input/OutputText Exporterhaughton@ifrc.org05/12/2000
File Input/Outputexport to textExports a view to a textfile which can be used in Excelbrigitte06/08/2002
File Input/OutputImport from ExcelImport excel Spreadsheet into a view and will update the phone number is the document already existsAnonymous08/17/2000
File Input/OutputFile Import Agentimports attachments at oncekamil.isik@domco.de05/10/2002
File Input/OutputExport to ExcelWill export view to excel and format excel sheetAnonymous08/17/2000
File Input/Output,Reporting/SearchingExport to text fileMackie01/15/1999
File Input/Output,Reporting/SearchingExportViewAnonymous03/04/1999
List Processing/SortingSorting and searching routinesSelection sort, binary search, and merge-sort routinesLes Szklanny12/15/1998
List Processing/SortingQuickSortSorts any array via a combination of Insertion Sort and Quicksort.Lotus12/15/1998
List Processing/SortingArray Manipulation functionsCommonly used functions for array manipulations: Explode, Implode, AddValues, RemoveEntries, RemoveNthEntriesJoseph Francis/IBM12/17/1998
List Processing/SortingisInArray function in LotusScriptReturns true if string is contained in the arrayJamie Magee12/15/1998
List Processing/Sorting,Numeric ProcessingQueue, stack and enumeratorThe very-most-basic functions of an object queue, stack and enumerator. Paul Everett/IBM12/17/1998
List Processing/Sorting,Numeric Processing,(Misc)Array functions - complete set68 functions for sorting, searching, hashing, moving, copying, adding, deleting arrayshttp://philippe.lord.md/09/21/2001
List Processing/Sorting,RDBMS Integration,Reporting/Searching,User Interface (Web),Website ToolsMatrix class for DBMS/Web table dataAllows retrieval, collation, cross-tabbing, sorting, normalization, HTML conversion, etc. of tabular data from RDBMS or Notes view.Jamie Magee12/29/1998
List Processing/Sorting,User Interface (Notes)Extract text from Notes table cellsProgramatically searches for the tab and line feed characters that separate the cells of a Notes table.Lotus12/15/1998
Numeric Processingextensive numeric valueAlexsandre - aandrade@arboll.com.br / Samantha - samantha@arboll.com.br 05/12/1999
Numeric Processing,SecurityCredit card validation function (ROT13)Returns true if a string is a valid credit card number.Jamie Magee12/15/1998
OLE/ActiveX IntegrationAutomate Outlook Mail From NotesRlatulippe@romac.com01/27/1999
OLE/ActiveX IntegrationWord Doc CreateCreates a MSWord doc with header block from Notes field dataMackie03/19/1999
OLE/ActiveX IntegrationOLE/ActiveXWe have used "Olectra" as an Embeded Object to get a graphical display of charts.
The values are passed to the properties of the object.
The graph is displayed by calling the form containing the embeded object using ws.composedocument. 		jaideep_pv@yahoo.com07/10/2001
OLE/ActiveX Integration,User Interface (Notes)Prevent large attachmentsSince I couldn't prevent a person from attaching a large file before the document is saved,
I ended up putting this code into the PostSave event. I say, let the person save the doc,
then interrogate the data, and if the file is too large, oh well, see ya..... I give them
a message. I found that I have to close the UI instead of allowing users to stay in edit
mode, as there's some residual pointer left over. Sometimes the pointer or image
shows up as if there is an attachment, but errs out when you click on it. This also takes
into account multiple attachments, and removes only the ones that are over the limit.
Enjoy, Keith Blankenship		k1blankenship@charter.net09/13/2002
RDBMS IntegrationNotes R4.5 LotusScript functions for synching an ODBC source with a Notes view.Notes R4.5 LotusScript functions for synching an ODBC source with a Notes
view.		Eric Koeler ekoeler@panix.com04/19/2000
ReplicationPrevent save confictsssaavedra@anp.gov.br / pmello@anp.gov.br06/15/1999
Reporting/SearchingCreate new Data Source for text filePut in button to create new data source automaticallyMackie01/31/1999
SecurityCopy ACLAnonymous12/31/2001
SecurityDetecting Roles in ScriptBen Vander Veen11/10/1999
Security,User Interface (Web),WorkflowACL adjustment from browserZvonko.Paunoski@icn.siemens.de10/07/1999
Security,WorkflowCheck roll in QueryDocumentDelete to prevent deletionsChecks to see if the current member has the DBManager Roll and can therefore delete documents.Rlatulippe@romac.com08/26/2000
String HandlingWordJust like @wordmni09/10/2002
String HandlingHow to generate a random password for notes or web users.Jannan02/14/2001
String HandlingReplaceSubstringjpotts@navsystems.com06/11/2001
User Interface (Notes)Luhn credit card algorithmValidates a credit card numberlotusnotes@mailcity.com04/19/2000
User Interface (Notes)Table generation (RTF) in LotusScriptDynamically create a RTF table with user defined rows, columns, column width, font, size, center, italic and/or
bold text attributes		Carlos Matos, Fusion Systems Japan12/15/1998
User Interface (Notes)Attach doclinks to all childrenAttach links to all "children docs" in parentdoc automaticallyMackie01/31/1999
User Interface (Notes)Progress Bar classClass file implementation of the code to control a Progress Bar.Ian Sherwood03/26/2001
User Interface (Notes)Progress barDisplays and controls the Notes progress bar from LotusScriptMark Dixon/Ives12/21/1998
User Interface (Notes)Percent complete in status barDisplays a percent complete progress indicator in the print area at the bottom of users screenJared Knapp02/13/1999
User Interface (Notes)Anonymous10/19/2004
User Interface (Notes),User Interface (Web),Workflow,(Misc)Non-Notes Doc Linksjawsct@home.com05/17/1999
User Interface (Notes),WorkflowLock a document that is being edited?How do you lock a document that is being edited? Eric Koeler has written a set of functions for doing this in Notes 4.x. You can grab the code and a code sample at his web site. The Lotuscript code works by adding a lock field to the document the user wishes to edit and then immediately saving the document; when other users try to open the document, they will see that there is a lock field so they cannot edit the document. This technique will only work if the database is on a single server (no replication). There is also a small chance for a race condition if two users manage to read a document simultaneously without the lock. Finally, if the user's system crashes while editing this locked document, the document will remain locked unless you implement some sort of emergency unlock mechanism.Rlatulippe@romac.com04/19/2000
User Interface (Web)Get paramter value from query stringNiels Ull Harremoes02/03/1999
User Interface (Web),Website ToolsImage dimensionsGets dimensions of a JPEG or GIF imageJohn Toton02/12/1999
Website Toolshit counterDomino servers die native Notes hit counterAnonymous09/08/2001
Website ToolsSuppress Domino agent HEAD tagsAllows your agents to insert your own HEAD element tags such as TITLE and
META.		Bruce Elgort (BruceElgort@PalmBuilder.com)12/03/1999
(Misc)Adding a Variable into String for LotusScript Search MethodAdding a Variable into String for LotusScript Search MethodRlatulippe@romac.com04/19/2000
(Misc)Set a dialog box to "always on-top"Editor's Note (11/30/95): This example uses 16 bit Windows API calls and will not work in the 32 bit. For the same functionality in the 32 bit version of Word Pro, change the Declare statements to the appropriate 32 bit Window API call. Place the following declarations in the Globals, and the Dialogevent code in your dialog box object, and the dialog box will be set to be always on top, even when you switch to another application. Note: this will probably not work with dialog bars, since they are child windows of Word Pro, not top level windows like normal dialogs. Note2: This will be slighly easier (and more robust) when the GetHwnd method is implemented for CustomDialog.Rlatulippe@romac.com04/19/2000
(Misc)Use FrontEnd Classes to pass Current Document to Backend classes!Rlatulippe@romac.com04/19/2000
(Misc)Factorial of n using recursionReturns the factorial of a number n using recursionRlatulippe@romac.com04/19/2000
(Misc)NotesDocumentCollection classThe example below uses GetFirstDocument and GetNextDocument to display the title of documents in the Intermediate view that contain the word "NotesDocumentCollection".Rlatulippe@romac.com04/19/2000
(Misc)Move Orphans to FolderFinds orphan documents and moves them to a folderRlatulippe@romac.com04/19/2000
(Misc)Subtracts one array from another!This script takes two arrays and subtracts the smaller array from the larger array.Rlatulippe@romac.com04/19/2000
(Misc)QueryDocumentDelete script to prevent deletion of a document marked as PermanentAfter I accidentally deleted an important document in one of our databases, I wrote this
little script to prevent it from happening again. This script will disable deletion of
any document (even by managers)marked as "Permanent" in a keyword, checkbox field on the
document form. This agent runs in the QueryDocummentDelete event of the database.		Rlatulippe@romac.com04/19/2000
(Misc)Check for down serversChecks for Down ServersRlatulippe@romac.com04/19/2000
(Misc)API Call to WIN32 to Utilize Windows Get File dialogbox. (Win95 Version)Brings up the Win95 get file dialog and allows you to select a file.Rlatulippe@romac.com04/19/2000
(Misc)Build a Table in Excel from Lotus Notes.Simple code that builds a pivot table in an existing Excel spreadsheetRlatulippe@romac.com04/19/2000
(Misc)Five Reusable LotusScript Functions for Working with Lists When working with lists, the same functions seem to come up time and time again. We thought that it would be useful to group some of these LotusScript functions together so that you could find them in a single resource. Here are the basics that are covered: 1. Remove from List
2. Add to List
3. Remove Item from List
4. Entry in List
5. Remove Range from List		Rlatulippe@romac.com04/19/2000
(Misc)Auto Refreshing a UI document from a back end document.The original goal was to open a UI doc, and keep it open while periodically refreshing the fields from the back end doc.Rlatulippe@romac.com04/19/2000
(Misc)PostOpen Code to check we have correct Parent documentChecks the selected document from which we are creating reponse to ensure we have the correct parent form. If not Display error message and close response document.Rlatulippe@romac.com04/19/2000
(Misc)Agent for Encrypting DocumentsAgent for Encrypting DocumentsRlatulippe@romac.com04/19/2000
(Misc)Sampling of SQL Statements that Can Be Used with NotesSQL commands that can be used with Notes?Rlatulippe@romac.com04/19/2000
(Misc)Code for calculating business days in LotusScript.Calculates the business daysRlatulippe@romac.com04/19/2000
(Misc)API Call to access the Clipboard in Notes?This function (thanks to Manfred_Doerwald@IDG.DE) calls Win32 functions to put a field in the clipboard:Rlatulippe@romac.com04/19/2000
(Misc)Mail a Lotus Notes document link through MS Outlook.Mails Link Through Outlook. This action button will create a link on the fly that will be saved to the users C:Drive as link.ndl then it will call the Subroutine AutomateOutlook. This routine will display the outlook mail modal with the link embedded in the body of the mail template. The user then fills in the To: field on the modal and sends the link. The Recipients of the mail must have Lotus Notes on their machine. When they click on the link in their Outlook mail. It will then launch Notes and the link.Rlatulippe@romac.com04/19/2000
(Misc)Creating a database from a templateCreating a database from a templateRlatulippe@romac.com04/19/2000
(Misc)Using the LotusScript Data Object (LS:DO) Error MethodsThe following information explains how to use the LotusScript Data Object (LS:DO) error
methods.		Rlatulippe@romac.com04/19/2000
(Misc)Conditional Branching: The ForAll StatementThe ForAll statement was made especially for arrays. It has the ability to operate on all the elements in an array without you knowing how many elements are in the array.Rlatulippe@romac.com04/19/2000
(Misc)How do you operate on the currently selected documents in LotusScript?The ... part in the code below marks where you can put code to access the active document.Rlatulippe@romac.com04/19/2000
(Misc)Accessing Notes Session PropertiesUsing the object.property syntax, you can access all the session properties. Let’s look at an example:Rlatulippe@romac.com04/19/2000
(Misc)Limit deletes in QueryDocumentDelete to response documents onlyChecks to ensure that only response documents are being deleted.Rlatulippe@romac.com04/19/2000
(Misc)Add together two one-dimensional arrays!Takes two arrays and builds them into one.Rlatulippe@romac.com04/19/2000
(Misc)Performing a SearchPerforming a SearchRlatulippe@romac.com04/19/2000
(Misc)Notes R4, you are attempting to add a user's name to an Access Control List (ACL) via LotusScript. When you add the user's hierarchical name to the ACL via the NotesACL New method, however, the user is still unable to access the database.Add names to the ACL via LotusScriptRlatulippe@romac.com04/19/2000
(Misc)NotesACL ClassThis example will ask you for the name of a role. Once the role name has been entered, all of the names in the role will be displayed.Rlatulippe@romac.com04/19/2000
(Misc)How to Display a Document, that Isn't the Current Document, w/ LotusScriptIllustrates one way to get a handle to a particular document (via a backend method) and then make the document the new UI document that displays on the screen. Specifically, the application performs the following actions:Rlatulippe@romac.com04/19/2000
(Misc)AlphaQuickSort function which sorts the elements in the array. This example asks the user for input of names and assigns each name to an element in the array. On NULL input it calls the AlphaQuickSort function which sorts the elements in the array.Rlatulippe@romac.com04/19/2000
(Misc)Open word and run one of the Macros.Opens Resume.doc on c:\ and runs a macro called macro1.Rlatulippe@romac.com04/19/2000
(Misc)Export a Lotus Notes document to excel (creating the excel spreadsheet) We use the following code to export a lotus notes document to excel
(creating the excel spreadsheet).		Rlatulippe@romac.com04/19/2000
(Misc)Directing New Users to a Special ViewIn R4.5 you can write a script that executes whenever a user opens the database. For example, you might want to direct new users to a special view, while letting old users proceed straight to the default view. To do this, write a script for the database object's Postopen event, as follows:Rlatulippe@romac.com04/19/2000
(Misc)How to Search for a Date Value When Using the GetDocumentByKey MethodUsing the Format function, you can store the date in a mm/dd/yy format, which zero-fills the date and allows for
proper searching.		Rlatulippe@romac.com04/19/2000
(Misc)Display Help Dialog BoxDisplays a Help Form, use with button and hotspotsRlatulippe@romac.com04/19/2000
(Misc)Determining the End of a File with LotusScriptRlatulippe@romac.com04/19/2000
(Misc)Update a field in all the response documents from a field that has changed in the parent document.The following LotusScript which will take a value in the parent document and push it
down into all the response documents. Place the script in the Querysave event of your parent form.		Rlatulippe@romac.com04/19/2000
(Misc)Creating a New and ModifiedCreating a New and ModifiedRlatulippe@romac.com04/19/2000
(Misc)Inport From ODBC (Tech Incident Database Example)Rlatulippe@romac.com04/19/2000
(Misc)Directing New Users to a Special ViewThis script executes whenever a user opens the database and directs new
users to a special view, while letting old users proceed straight to the default view.		Rlatulippe@romac.com04/19/2000
(Misc)Using LotusScript for Unattended File Import in a Notes ViewRlatulippe@romac.com04/19/2000
(Misc)This script imports information from documents in another database.This script imports information from documents in another database.Rlatulippe@romac.com04/19/2000
(Misc)MS Excel Import, using OLEHere's an excel import, using OLE, that can be fairly easily modified to import anything that has OLE classes registered (it can be easily adapted to read every MS Project file in a directory, and pull out each task separately as a Notes document).Rlatulippe@romac.com04/19/2000
(Misc)Quicksort one less recursive callDoes a quicksort on an array!Rlatulippe@romac.com04/19/2000
(Misc)How to Create a Document with "Store Form in Document" via LotusScript Back-End Rlatulippe@romac.com04/19/2000
(Misc)Generate Response Docs in LotusSciptThis view action will call a LotusScript agent to generate response documents on an entire database (all it's parent docs, that is). This formula can be found in the World Wide Country Database as a view action called "Add Fund To Countries". This view action first does a lookup on the Fund Library database. The user selects a new fund fromn this library and VIOLA! All the country documents will have a new fund doc (this is the response doc). This action calls the agent to do the actual creation of the response docs. The agent is hidden and is set to run on all docs in the view. The agent name is called Add Fund and it's event is set to INITIALIZE.Rlatulippe@romac.com04/19/2000
(Misc)Creating a Search Agent - Challenge*Creating a Search Agent - Challenge*Rlatulippe@romac.com04/19/2000
(Misc)API call to NNOTESWS.DLL to display Windows BrowserUses a call to a function in the notes DLL to display the windows browserRlatulippe@romac.com04/19/2000
(Misc)How to Compare Dates Using LotusScript It seems as though comparing dates would be a straight-forward task; however, it is actually rather complicated. A quick, easy approach is to use simple comparison operators, but via this approach - the question remains of how you get the
dates from Notes into the back-end and then manipulate it once it is in the script. The following instructions and sample code,
however, demonstrate how you can do this:		Rlatulippe@romac.com04/19/2000
(Misc)Update a field in response documents after it is changed in
the parent document?		How do you update a field in response documents after it is changed in
the parent document?		Rlatulippe@romac.com04/19/2000
(Misc)16 bit free resources and available memoryReturns Free Resources on 16 Bit SystemRlatulippe@romac.com04/19/2000
(Misc)API Calls to NNOTESWS.DLL to Display Progress Bar Along the bottom.Displays Notes Progress Bar.Rlatulippe@romac.com04/19/2000
(Misc)Low-level, self-contained, LotusScript
functions,		This file contains somewhat low-level, self-contained, LotusScript
functions, as well as some global constants used by these Functions. To use
these Functions, add the following line to the Declarations section of your
script module:		Rlatulippe@romac.com04/19/2000
(Misc)API calls and declarations to access the Win RegistryThis will return the path of the Notes Data directoryRlatulippe@romac.com04/19/2000
(Misc)GetTarget Function: Gets target db as current db.Given the current database and a new filename will return that filename as the new current database if it is on the same server and path.Rlatulippe@romac.com04/19/2000
(Misc)Equivalent Rightback and Leftback functions in LotusScriptEquivalent Rightback and Leftback functions in LotusScriptRlatulippe@romac.com04/19/2000
(Misc)How to Open a Navigator in Notes R4 via LotusScriptHow to Open a Navigator in Notes R4 via LotusScript
Product Release:		Rlatulippe@romac.com04/19/2000
(Misc)Inport from a Word Document!This script imports information from a Word document into a Notes document while standardizing the doc's formatting.Rlatulippe@romac.com04/19/2000
(Misc)FTSearchThis example will find any documents in the Beginning view that contain the string Method* using the view method FTSearch .Rlatulippe@romac.com04/19/2000
(Misc)Searching the WebSearching the WebRlatulippe@romac.com04/19/2000
(Misc)Exchanging items values between
documents.		EKIPUSH.LSS Function Library Notes R4 LotusScript functions for exchanging items values between
documents.		Rlatulippe@romac.com04/19/2000
(Misc)Open a Freelance Presentation via AutomationThis routine puts up a common dialog that prompts the user to select a Freelance presentation to open. If the user selects a file then it creates a Freelance automation session and opens the requested doc. It chops up the name returned from the dialog into file name and path parts for the open command. There may be a more standard way to do this but I couldn't find it.Rlatulippe@romac.com04/19/2000
(Misc)Pushing changes down the hierarchyThe following LotusScript which will take a value in the parent document and push it
down into all the response documents. Place the script in the Querysave event of your parent form.		Rlatulippe@romac.com04/19/2000
(Misc)Removing an Item from All Documents in the DatabaseRemoving an Item from All Documents in the DatabaseRlatulippe@romac.com04/19/2000
(Misc)Something to watch out for with Str$This is documented, but I totally missed it, and I figure others might as well. In Ami Pro, we didn't really have to worry about data types; it was all handled internally for us. But with LotusScript, we sometimes need to do some conversions. An example is changing a number over to it's string representation. For this, you usually use Str$. But watch out! Str$ returns a leading space. So, Str$(1) actually returns " 1". Usually this won't matter, but in some cases it can come back to bite you. Here's some example code where Str$ doesn't work as expected because of the leading space...Rlatulippe@romac.com04/19/2000
(Misc)Refresh Authors or Readers Fields Updated via LotusScript Back-endRlatulippe@romac.com04/19/2000
(Misc)Force form check on creation of response doc.This checks the current form you are on and ensures that it is viable for the response form to be createdRlatulippe@romac.com04/19/2000
(Misc)How do you remove an element from a Textlist field?How do you remove an element from a Textlist field?Rlatulippe@romac.com04/19/2000
(Misc)FTP MirrorCreated By: Teresa Deane on 02/07/96 at 03:59 PM
Category: Miscellaneous Minimum required Notes: Notes 4.0
Author: Teresa Deane
Company: Iris Associates
E-Mail Address: InterNotes@iris.com Description of the Agent: This agent refreshes pages with attachments. It should be run in the background preferably after the refresh agent has run.		Rlatulippe@romac.com04/19/2000
(Misc)Retrieving the Names of all the Columns in a View using NotesView property, ColumnsThe example below will retrieve each column in the Intermediate view. The column title will be displayed if it exists, otherwise the user will be notified on the lack of a column title.Rlatulippe@romac.com04/19/2000
(Misc)Building a Searchformula$ using several fields amd @IsMemberBuilds a search where Form = "ServerAdmin" and either of the DefaultClass field or OtherClassNames list field = the variable sClassRlatulippe@romac.com04/19/2000
(Misc)Lotus Notes OLE Automation with MS ExcelThis demo uses OLE automation to create Notes mail from within Microsoft Excel, sending cell values in the body of the mail message. This is a great and easy-to-write example of how to use the Notes client with MS Office products, using the best of both products. You can cut and paste this VBA code example into Excel.Rlatulippe@romac.com04/19/2000
(Misc)Create error handling classRlatulippe@romac.com04/19/2000
(Misc)NotesUIDocument method, SaveSave the on screen document that is set to a NotesUIDocument variable, use the NotesUIDocument method, Save .Rlatulippe@romac.com04/19/2000
(Misc)Determine the number of seconds, hours, minutes, days and weeks between now and a particular date?The following sample script determines and displays the numbers of seconds, minutes, hours, days and weeks between now and both the start of the next year and the start of the current year. You can modify the script to compute the difference between the current date and any user-defined date.Rlatulippe@romac.com04/19/2000
(Misc)API Call to User32 to get and Set Active Window TitleGets the Active Windows Title using WIN32 library calls.Rlatulippe@romac.com04/19/2000
(Misc)NotesDocument property .AuthorsRetrieves the authors of a given document in a Notes document by using the NotesDocument property . Authors .Rlatulippe@romac.com04/19/2000
(Misc)Factorial FunctionReceives nFact as the user input plus additional parameters for displaying each factorial between zero and nFact as well as the number of recursive calls. The function returns the factorial of nFact .Rlatulippe@romac.com04/19/2000
(Misc)Social Security FormatRlatulippe@romac.com04/19/2000
(Misc)How to Delete Profile Documentshe only way to delete a profile document we've been able to find is to use the remove method in the NotesDocument class.Rlatulippe@romac.com04/19/2000
(Misc)Creating a Domino agent to count the number of hits on a web pageCreating a Domino agent to count the number of hits on a web pageRlatulippe@romac.com04/19/2000
(Misc)Accessing Notes View PropertiesYou can access Notes view properties using the NotesView class properties.Rlatulippe@romac.com04/19/2000
(Misc)API Call to Retrive Local Time (Win95 & WinNT)Uses the function GetLocalTime in the Kernel32.DLL to retrive Time.Rlatulippe@romac.com04/19/2000
(Misc)Examples: EnableRole method for a single userThis script enables the Auditor role for Bill Ehrhardt, in the database DISCUSS.NSF.Rlatulippe@romac.com04/19/2000
(Misc)AlphaQuickSort FunctionSorts an array of alphanumeric elements. The function returns an array of the elements sorted alphanumerically.Rlatulippe@romac.com04/19/2000
(Misc)Date Routines in LotusScriptThis routine returns the first date a specificed weekday falls in the year when passed a year and weekday.Rlatulippe@romac.com04/19/2000
(Misc)API Calls in Script Library to write to and from Windows ClipboardScript to write to the windows clipboard.Rlatulippe@romac.com04/19/2000
(Misc)Update the parent document from response doc.It will check the document is being saved and if a field exist called $Ref (which is on reponse docs) it will look at the parent and change the "Status" field to "Updated"Rlatulippe@romac.com04/19/2000
(Misc)Agent to copy all documents from a Target Db to your DbCopies all documents from another database to the current databaseRlatulippe@romac.com04/19/2000
(Misc)How to use LotusScript to Mail a Memo with a Doclink to the Original Document.How to use LotusScript to Mail a Memo with a Doclink to the Original Document.Rlatulippe@romac.com04/19/2000
(Misc)Auto-launching attachments in Win32Launches an attachement.Rlatulippe@romac.com04/19/2000
(Misc)LotusScript Notes AppendRTItem Method - Copy RichtextItem Font InformationLotusScript Notes AppendRTItem Method - Copy RichtextItem Font InformationRlatulippe@romac.com04/19/2000
(Misc)Documentation and implementation notes.Documentation and implementation notes.Rlatulippe@romac.com04/19/2000
(Misc)Flat file importThe routine demonstrates flat file importing with LotusScript. It shows how to read a comma
separated file. To make it more interesting it then merges the results into existing records in the database. These records
are keyed on a unique id. You should be able to easily modify this routine to create instead of merge or perhaps do both depending
on if the record already exists or not.		Rlatulippe@romac.com04/19/2000
(Misc)Determine the Number of Rows in a LS:DO Result Set in Notes R4Fetch all the rows using the LastRow method and then use the NumRows property to return the
number of rows in the result set.		Rlatulippe@romac.com04/19/2000
(Misc)How to View on the Screen a Rich Text Item Added via LotusScriptHow to View on the Screen a Rich Text Item Added via LotusScriptRlatulippe@romac.com04/19/2000
(Misc)Updating the backend NotesDocument in the QueryOpen Event.When the QueryOpen event is triggered, the Notes document is already loaded into the memory but nothing is displayed on the screen yet. You can take this chance to change the values of some of the fields. For example, you can count how many times a document has been opened (or who opened it) without having to put the document into edit mode.Rlatulippe@romac.com04/19/2000
(Misc)How to Use LotusScript to Prevent a User from Opening a ViewHow to Use LotusScript to Prevent a User from Opening a ViewRlatulippe@romac.com04/19/2000
(Misc)Simple Test for Reading from an ODBC Data Source Using LotusScriptThe following test script will evaluate whether you can read from an ODBC source using
LotusScript		Rlatulippe@romac.com04/19/2000
(Misc)API Call, How to Make Windows API Calls, Taking the Windows Version into AccountWindows API calls usually differ, depending upon the Windows version that is in use when the call is made. The following example illustrates how to call the Windows API GetPrivateProfileString function while taking into account the Windows version in use:Rlatulippe@romac.com04/19/2000
(Misc)Conditional Branching: The Select Case StatementThe Select Case statement allows a program to conditionally execute statements based on any number of conditions.Rlatulippe@romac.com04/19/2000
(Misc)Automated Outlook Mail agent!This agent takes the e-mail field from selected documents and displays the MS Outlook mail template with the To: Field populated with those addresses.Rlatulippe@romac.com04/19/2000
(Misc)Move Orphan documents to Orphans FolderMoves all Orphan Documents to a folder called OrphansRlatulippe@romac.com04/19/2000
(Misc)How do you do a data import/merge using Lotuscript?How do you do a data import/merge using Lotuscript? This function can be placed in an action button in a database:Rlatulippe@romac.com04/19/2000
(Misc)Script Libraries - ExamplesScript Libraries - ExamplesRlatulippe@romac.com04/19/2000
(Misc)Using LotusScript to Write to a Non-Notes DatabaseUsing LotusScript to Write to a Non-Notes DatabaseRlatulippe@romac.com04/19/2000
(Misc)Check to see if this is an existing ID to allowing user to continueCheck ID field to ensure that the ID being eneterd does not already exist.Rlatulippe@romac.com04/19/2000
(Misc)Delete all orphaned response documentsDeletes all Orphaned response documentsRlatulippe@romac.com04/19/2000
(Misc)What are Properties in LotusScript?Properties in LotusScript? How are they used?Rlatulippe@romac.com04/19/2000
(Misc)Import information from a Word document into a Notes documentThis script imports information from a Word document into a Notes document while standardizing the doc's formatting.Rlatulippe@romac.com04/19/2000
(Misc)Importing text file into notes using Lotus ScriptCreate a price list in notes from a comma separated file. Each line was one document.Rlatulippe@romac.com04/19/2000
(Misc)Function GetParentDocument( doc As NotesDocument )This is a recursive function. It returns the main document at the top of a thread. An example of a thread is a main topic with multiple response documents. Passing the NotesDocument object reference variable to this function would return the main topic at the top of the thread. Call this function using GetParentDocument(doc).Rlatulippe@romac.com04/19/2000
(Misc)Hierarchical ReaderNames Lookup Implementing control of hierarchical ReaderName relationships in Notes R3/4Hierarchical ReaderNames Lookup Implementing control of hierarchical ReaderName
relationships in Notes R3/4		Rlatulippe@romac.com04/19/2000
(Misc)Moving file attachments added via the web to a RT field using $$QuerySaveAgentMoving file attachments added via the web to a RT field using $$QuerySaveAgentRlatulippe@romac.com04/19/2000
(Misc)Fibonacci Sequence of n using recursionReturns F ibonacci Sequence of n using recursionRlatulippe@romac.com04/19/2000
(Misc)Refresh a View from within a Document Using Script in Notes R4To refresh a view from within a document, you must perform both the backend NotesView Refresh and the frontend NotesUIDocument ViewRefresh methods (before exiting out to the view)Rlatulippe@romac.com04/19/2000
(Misc)Creating a Search Agent to Search the InternetCreating a Search Agent to Search the InternetRlatulippe@romac.com04/19/2000
(Misc)Working with the Windows APIIn developing advanced applications, it's often important to access functions of the operating system. This is an example of calls to the registry.Rlatulippe@romac.com04/19/2000
(Misc)Retrive one level of Child Documents from Parent Documenst using GetChild.The example below will demonstrate how to retrieve information from a parent document, along with any child (response) documents associated with the parent document.Rlatulippe@romac.com04/19/2000
(Misc)Select Case with Enum valuesYou can get this to work by treating the Enums as strings. In particular, see the modified script below.Rlatulippe@romac.com04/19/2000
(Misc)Update Oracle records via LotusScript agentThis database keys on a record in Oracle and then updates the record from the notes Document.Rlatulippe@romac.com04/19/2000
(Misc)Displaying Domino hit Counter Values in Profile DocumentsAuthorThe profile documents are a new feature requiring Notes 4.5 to use, set, display, etc. There is no way I know of to select profile documents for use in a view. However, it was fairly simple to write an agent that displays all the counter fields in a profile doc ument. The agent can also be used from the web. Here is the sample agent I have been using (long lines wrapped and you must "unwrap" them to try the agent:Rlatulippe@romac.com04/19/2000
(Misc)EKDOCLOC.LSS - Function LibraryEKDOCLOC.LSS - Function LibraryRlatulippe@romac.com04/19/2000
(Misc)Pulling a Value From Current Table Cell With LotusScriptThe following script retrieves the contents of the currently selected cell, rounds it to two decimals,
and then writes is back to same cell. This assumes that the data in the cell is numeric.		Rlatulippe@romac.com04/19/2000
(Misc)Can you start a program in Notes and wait for it to finish?Starts a program in Lotos NotesRlatulippe@romac.com04/19/2000
(Misc)QueryDocumentDelete Event. When a document is selected for deletion delete all response and response to response documents as well.If a document selected for deletion has response it warns the user that those will also be deleted. It then pushes all response documents and response to response into a delete folder.Rlatulippe@romac.com04/19/2000
(Misc)How to Change the Caption on a Multi-line LotusLabel in LotusScriptThe following sample script places the caption "This is a test. This is only a test." on two lines.Rlatulippe@romac.com04/19/2000
(Misc)Conditional Branching: The WHILE StatementWhile loops execute code conditionally.Rlatulippe@romac.com04/19/2000
(Misc)How to Check via LotusScript Whether a Document is Open in Preview PaneHow to Check via LotusScript Whether a Document is Open in Preview PaneRlatulippe@romac.com04/19/2000
(Misc)Share scripts among elements in a database
Share scripts among elements in a databaseRlatulippe@romac.com04/19/2000
(Misc)Selection Formula for document collection used in db.searchThis formula will be used by db.search method to select documents by form and by fields that are equal to some variable sPrimary.Rlatulippe@romac.com04/19/2000
(Misc)Reference other databasesRlatulippe@romac.com04/19/2000
(Misc)Error 4000Notes Error.No mail sent.Anonymous03/12/2002
(Misc)Validate Social SecurityTry the following code to validate your social security number.Rlatulippe@romac.com04/19/2000
(Misc)Retriving Parent and Child Documenst from a ViewThis example demonstrates how to retreive a parent document from a view, and then proceed to retreive information from all of the Parent's child documents.Rlatulippe@romac.com04/19/2000
(Misc)NotesDBDirectory classThe example below retrieves all databases included in the data directory and any directories below the data directory, and displays their titles.Rlatulippe@romac.com04/19/2000
(Misc)NotesUIDocument property, EditModeForces the on screen document into edit mode, using the NotesUIDocument property, EditMode .Rlatulippe@romac.com04/19/2000
(Misc)Determine if a document is a profile documentWith the advent of profile documents in Notes 4.5, it will become neccessary to determine if a document is a profile document or not. A new NotesDocument property, IsProfile, will return True if a document is a profile document, and False if it is not. To use IsProfile, set the document in question to a NotesDocument object, and retrieve the value in the property. Syntax variablename = notesdocument.IsProfile The example below will determine if this document is a profile document or not, and display a message with the result.Rlatulippe@romac.com04/19/2000
(Misc)Agent to set Readers field security using IsReaders property.This agent is used to reset a readers field once it has been changed to a type text.Rlatulippe@romac.com04/19/2000
(Misc)Retriving Parent Documents with Child and Grandchild DocumentsThis example demonstrates how to retrieve information from a parent document in a view, and all of the Parent's child and grandchild documents.Rlatulippe@romac.com04/19/2000
(Misc)Delete a default zero after a form is opened when the field is being calculated in another fieldThis code is used to to delete a default zero after a form is opened when the field is being calculated in another field. This code should go in the Postopen mode of the form.Rlatulippe@romac.com04/19/2000
(Misc)Creating a Search AgentCreating a Search AgentRlatulippe@romac.com04/19/2000
(Misc)Credit Card Verification FormulaA Luhn formula (Mod10) for credit card number verification, The main purpose of this algorithm is to avoid data entry errors, but it can also be used as a security tool. But BEWARE, it's a very weak security tool, that anybody can crack !Rlatulippe@romac.com04/19/2000
(Misc)How do you do a data import/merge using Lotuscript?How do you do a data import/merge using Lotuscript? This function can be placed in an action button in a database:Rlatulippe@romac.com04/19/2000
(Misc)Creating NewslettersCreating NewslettersRlatulippe@romac.com04/19/2000
(Misc)Creating a databaseCreates a databaseRlatulippe@romac.com04/19/2000
(Misc)Arrays and RedimArrays, like variables, hold values of a single data type. Unlike variables, however, arrays can hold multiple elements of the same data type.Rlatulippe@romac.com04/19/2000
(Misc)How to make the "loser" of a replication/save conflict be the "winner"?When you select the "loser" document and run this agent, it will be promoted to be a replication "winner". You can then delete the original "winner" document. Put this code into an agent that runs on selected documents:Rlatulippe@romac.com04/19/2000
(Misc)What are the Unix syntaxes for calling DLLs from LotusScript?Rlatulippe@romac.com04/19/2000
(Misc)If you use the LotusScript Evaluate statement with certain @functions, the result is not what you expected.The Evaluate statement is designed to work with non-UI @functions only. The following @functions cannot be used with the Evaluate statement:Rlatulippe@romac.com04/19/2000
(Misc)API Call to NNOTESWS.DLL to get and Set Active Window TitleThis example demonstrates the declaration of the NEMSetWindowText function located in NNOTESWS.DLL file:Rlatulippe@romac.com04/19/2000
(Misc)Adding an Item to All Documents Using AppendItemValue of NotesDocumentAdding an Item to All Documents Using AppendItemValue of NotesDocumentRlatulippe@romac.com04/19/2000
(Misc)16 bit GetPrivateProfileString function call to get ScreenSaver and WallPaper in Windows.Returns Screen Saver and Wallpaper settings on Windows system.Rlatulippe@romac.com04/19/2000
(Misc)Implode FunctionThis function takes in a Notes Item in the signature line and returns the item as a string value the values are separated by a comma but that can be changed to any delimiter the user wishes to use. Additional checks for author and such may also be incorporated if the developer so feels.Rlatulippe@romac.com04/19/2000
(Misc)Phone # LookupUsers are prompted for a first and/or last name to lookup. The script searches local and public address books and returns each name found in it's own window displaying the full name, department, and office phone number.Rlatulippe@romac.com04/19/2000
(Misc)Mail notification that a new document was created from a web client.Web mail notification that a new document was created from the web.Rlatulippe@romac.com04/19/2000
(Misc)Purge AgentCreated By: Teresa Deane on 02/07/96 at 03:58 PM
Category: System Minimum required Notes: Notes 4.0
Author: Teresa Deane
Company: Iris Associates
E-Mail Address: InterNotes@iris.com Description of the Agent: This agent manages the database size based on selections in the administration note. It is set to run at 1:00AM nightly. It is a system agent which ships with the Web
Navigator template. Please refer to the Web Navigator Administration Guide for more information. Agent Script:		Rlatulippe@romac.com04/19/2000
(Misc)Compute With FormThis agent runs on a selected document. When run it "recomputes" the form. I use this a lot when I need to change something like a reader field that is computed when composed. Instead of adding an additional readers field to a form and then modifying each form this will allow you to recompute the values of such fields after you have changed the field formula. This is handy especially if you forget to give yourself access to certain fields (in which case you have to run this at the server) but it can save a lot of time and heartache.Rlatulippe@romac.com04/19/2000
(Misc)What's the date of the Last Thursday in November?In the following function getdateByWeekDayFromBack(1998,11,1,5) returns the last Thursday of Nov.Rlatulippe@romac.com04/19/2000
(Misc)Windows directoryReturns the Windows directoryRlatulippe@romac.com04/19/2000
(Misc)Sort - QuickSort, IBMsThe following is an example of how to use LotusScript code within NotesViP
to sort an array.		Rlatulippe@romac.com04/19/2000
(Misc)Add Rich Text thru the UIRlatulippe@romac.com04/19/2000
(Misc)How to Append One RTItem to Another via LotusScript Without a Save PromptHow to Append One RTItem to Another via LotusScript Without a Save PromptRlatulippe@romac.com04/19/2000
(Misc)Prevent deletion of document if response existChecks document to be deleted and prevents the deletion if a response existRlatulippe@romac.com04/19/2000
(Misc)Conditional Branching: The FOR StatementThe For statement gives you the ability to execute a block of code a certain number of times.Rlatulippe@romac.com04/19/2000
(Misc)Equivalent LotusScript Explode functionHere is an example I use for explode: Lineinput is the string to be parsed out. Sep is the separator (unfortunately this version only supports one character separators) Linearray is the array which is where you want your values.Rlatulippe@romac.com04/19/2000
(Misc)ODBC using LS:DO to push to an Oracle database.Pushes LotusNotes data to an Oracle database!Rlatulippe@romac.com04/19/2000
(Misc)Sort - Quicksort Algorithm recursiveSorts an array of data using the recursive Quicksort AlgorithmRlatulippe@romac.com04/19/2000
(Misc)Updating Oracle database from Lotus NotesYou can use the ODBC (Open Database Connectivity) Version 2.0 standard to access data in non-Notes databases. Using formulas or scripts embedded in Notes objects, you can integrate the data from many external databases into Notes applications. For example, a customer call-tracking application in Notes can access customer financial data from an ODBC-compliant relational database management system.Rlatulippe@romac.com04/19/2000
(Misc)Create and send mailIn LotusScript, to send a message in Notes requires the following type of code: Sub Click (source as Button)' a button to send info with...Rlatulippe@romac.com04/19/2000
(Misc)In one form, the user can select as many as three subforms from the list of all available subforms.Where do we get a list of subforms when we don't know from one minute to the next how many there are or what they are called? Simple, we use this LotusScript routineRlatulippe@romac.com04/19/2000
(Misc)How to Determine if Optional Arguments Have Been Provided for a Method. Product Release: LSX Toolkit 2.0How to Determine if Optional Arguments Have Been Provided for a Method.Rlatulippe@romac.com04/19/2000
(Misc)Doing a DBLookup using LotusScript Notes support services has one....it uses a dummy form that has a field
for each of the parameters in a @dblookup...the dblookup field is a computed
field, and you should do the following:		Rlatulippe@romac.com04/19/2000
(Misc)API Call to Add Shortcuts to the Win95 DesktopThis script sample will add Shortcuts to the Win95 Desktop.Rlatulippe@romac.com04/19/2000
(Misc)Fibonacci Sequence of n using iterationReturns Fibonacci Sequence of n using iterationRlatulippe@romac.com04/19/2000
(Misc)Update IsReader or IsAuthor agent when the field has been changed to a text field.Rlatulippe@romac.com04/19/2000
(Misc)API call to NNOTESWS.DLL to display Progress Barmakes API calls to display progress barRlatulippe@romac.com04/19/2000
(Misc)Copy one Richtext field to anotherCopies richtext field from docA and writes it to docBRlatulippe@romac.com04/19/2000
(Misc)Using UnprocessedDocuments on all newly created and modified documents, to modify the Status item of each document it processes.This agent script runs on all newly created and modified documents, and its purpose is to modify the Status item of each document it processes.Rlatulippe@romac.com04/19/2000
(Misc)Sending an e-mail message to the author of the current documentSends and E-mail to author of current document!Rlatulippe@romac.com04/19/2000
(Misc)Check and set a File's AttributesYou can check a file's attributes and then set an attribute using LotusScript. For example, the following code checks whether a file is Hidden, and if it is, sets its Hidden attributeRlatulippe@romac.com04/19/2000
(Misc)Agent that prints mail as soon as it arrives Agent that prints mail as soon as it arrivesRlatulippe@romac.com04/19/2000
(Misc)Setting values in several documents without opening them depending on a change in a different documentchecks docs created with a second form and does a collection depending on a field value then sets the status field of teh collected docs to closed.Rlatulippe@romac.com04/19/2000
(Misc)Determine whether a particular field in a form contains an object?HasItemObject checks whether the field that is passed to this function contains an Object and then returns either True (hasObject) or False. A sample script is provided below.Rlatulippe@romac.com04/19/2000
(Misc)Finding the Amount of Free Space on a Drive Using LotusScriptListed below is a LotusScript that makes the necessary API call.Rlatulippe@romac.com04/19/2000
(Misc)Check specified server until is respondsChecks for server responseRlatulippe@romac.com04/19/2000
(Misc)Using LotusScript to Read from Non-Notes DatabasesUsing LotusScript to Read from Non-Notes DatabasesRlatulippe@romac.com04/19/2000
(Misc)Using UnprocessedDocuments on all unread documents, to put unread documents into a folder. This agent script runs on all unread documents, and its purpose is to put unread documents into a folder.Rlatulippe@romac.com04/19/2000
(Misc)What is the Difference Between Type and Class in LotusScript?A detailed description of both Types and Classes is below.Rlatulippe@romac.com04/19/2000
(Misc)Converting C Strings To Lotusscript StringsWhen calling Windows API functions, you usually have to pass in a fixed length buffer in which the API call returns a null-terminated (C style) string. To convert this string back to a normal LotusScript string, use the Instr function to search for Chr$(0).Rlatulippe@romac.com04/19/2000
(Misc)Updating a UIdoc in Read Mode with a DialogBoxFor a variety of reasons, such as formatting, you want to keep a document in read mode, but you need to collect input from a user and update the document they are currently reading. In this example, we want to keep the user in read mode but update the documentRlatulippe@romac.com04/19/2000
(Misc)Creating Newsletters - Challenge*Creating Newsletters - Challenge*Rlatulippe@romac.com04/19/2000
(Misc)Sleep or Wait code'Puts the app to sleep for the given number of millisecondsRlatulippe@romac.com04/19/2000
(Misc)How do you find out what Roles a user has in the current database?This function will give you a list of all roles a user is in, even if the user is in nested groups which are listed in the ACL.Rlatulippe@romac.com04/19/2000
(Misc)API Call to NNOTES.DLL to get User NameMakes an API call to retrive the Current User NameRlatulippe@romac.com04/19/2000
(Misc)ODBC Connection With Message Box to ask for ODBC DATA Source.During ODBC Connection gets Data Source from User.Rlatulippe@romac.com04/19/2000
(Misc)Working with Embedded Objects and Environment VariablesWorking with Embedded Objects and Environment VariablesRlatulippe@romac.com04/19/2000
(Misc)How do you change the new mail tune under NT?How do you change the new mail tune under NT?Rlatulippe@romac.com04/19/2000
(Misc)OLE from Notes to Excel via LotusScriptCopies data from Notes to Excel using OLE automationRlatulippe@romac.com04/19/2000
(Misc)Using UnprocessedDocuments to iterate through a view and , if the Approver item contains the current user's name, it sets the Approved item to "Yes."This view action script allows a user to approve multiple requisitions at once by processing the currently selected documents in the Requisitions view. UnprocessedDocuments returns the documents currently selected in the view. The script iterates over each document and, if the Approver item contains the current user's name, it sets the Approved item to "Yes."Rlatulippe@romac.com04/19/2000
(Misc)EKDOCLOC.LSS - Documentation and Sample UsageEKDOCLOC.LSS - Documentation and Sample UsageRlatulippe@romac.com04/19/2000
(Misc)Creating a New and Modified - Challenge*Creating a New and Modified - Challenge*Rlatulippe@romac.com04/19/2000
(Misc)How to update a field on parent when a reponse doc has been deletedIt will check the documents that are being deleted and if a field exist called $Ref (which is on reponse docs) it will look at the parent and change the pro field to ""Rlatulippe@romac.com04/19/2000
(Misc)When Looping Through a ResultSet, While.NextRow Is Not RecommendedInstead of While.NextRow, use Do at the beginning of the loop and the condition at the end, with a statement
such as "Loop Until res.IsEndOfData."		Rlatulippe@romac.com04/19/2000
(Misc)Refresh AgentThis agent refreshes non-private http pages nightly at 3:00 AM provided that they have not been brought in already that day. This is a system agent which ships with the Web Navigator template. Please refer to the Web Navigator Administration Guide for more information.Rlatulippe@romac.com04/19/2000
(Misc)Scheduled agent that attaches file to documents.Rlatulippe@romac.com04/19/2000
(Misc)How to Add Carriage Returns to a Text Field via LotusScript in Notes R4.5xHow to Add Carriage Returns to a Text Field via LotusScript in Notes R4.5xRlatulippe@romac.com04/19/2000
(Misc)One time push of Notes Documents to Oracle DatabaseThis agents write notes document into an Oracle database using ODBCRlatulippe@romac.com04/19/2000
(Misc)NotesUI classesYou can use the NotesUI classes to create a document on the fly .Rlatulippe@romac.com04/19/2000
(Misc)Examples: EnableRole method for multiple users.This sub enables one role for multiple people in an ACL. Its parameters are a NotesACL object, the name of the role to enable, and an array of strings that represent user names.Rlatulippe@romac.com04/19/2000
(Misc)Factorial of n using iterationReturns the factorial of a number n using iterationRlatulippe@romac.com04/19/2000
(Misc)Manipulating Rich TextManipulating Rich TextRlatulippe@romac.com04/19/2000
(Misc)Using LotusScript to Read from Non-Notes Databases - Challenge*Using LotusScript to Read from Non-Notes Databases - Challenge*Rlatulippe@romac.com04/19/2000
(Misc)Queydocumentdelete eventWill warn user of deletion of seleted documentsRlatulippe@romac.com04/19/2000
(Misc)Add Rich Text thru the UI no views used in code!Refresh the current UI doc when an attachment is added.Rlatulippe@romac.com04/19/2000
(Misc)Creating a Rich Text FieldCreating a Rich Text FieldRlatulippe@romac.com04/19/2000
(Misc)Agent used to create User Profile Documents From Office Profile DocumentsBuild a set of documents from information gathered from a different set of documents.Rlatulippe@romac.com04/19/2000
(Misc)Button adds attachments RTFRlatulippe@romac.com04/19/2000
(Misc)Use LotusScript to handle ordinary text filesThe following example script opens the lotus.ini file and prints out its contents to screen:Rlatulippe@romac.com04/19/2000
(Misc)Using a dialog box allow a manager to assign roles to a readers field on the fly to various documentsThis code allows a db Manager to assign various roles on the fly to a readers field on the document. The roles are called from a (GetRoles) form that is used as a dialog box to allow th euser to select various roles in the ACL.Rlatulippe@romac.com04/19/2000
(Misc)Average the elements in a one-dimensional array of integersThis Subroutine will take and array of integers and give you the average, sum and difference from average of the integers.Rlatulippe@romac.com04/19/2000
(Misc)Sort - Bubble Sort for a Document CollectionSorts a Document CollectionRlatulippe@romac.com04/19/2000
(Misc)Filling Items with Dialog Box on Open of Document!Filling Items with Dialog Box on Open of Document!Rlatulippe@romac.com04/19/2000
(Misc)Find the Parent Document to a Child DocumentIn the script below, the child document is found using GetFirstDocument and GetNextDocument . You might ask yourself `Why not use GetNthDocument instead?'. The reason is GetNthDocument only works in documents in a collection, and we are working in a view!Rlatulippe@romac.com04/19/2000
(Misc)Using Lists in LotusScriptLists are very powerful in LotusScript. You can use a list to get a multi-value field from a document and add the values to a list (thus ensuring uniqueness). You can then process many documents against the same list and when you are done, you will have a list of all of the values which appeared at least once in the set of documents you processed.Rlatulippe@romac.com04/19/2000
(Misc)Error handling with OpenError handling with OpenRlatulippe@romac.com04/19/2000
(Misc)LotusScript Agent to Recalculate Documents on a ScheduleLotusScript Agent to Recalculate Documents on a ScheduleRlatulippe@romac.com04/19/2000
(Misc)Creating a document with Authors field using LotusScriptHere's some sample code showing how to set the appropriate properties on the field. This code is run from an agent in the initialize event.Rlatulippe@romac.com04/19/2000
(Misc)How to use @Formula in LotusScript.How to use @Commands in LotusScript.Rlatulippe@romac.com04/19/2000
(Misc)32 bit free disk space funtion call In Windows to check Freespace on Disk.Returns Freespace on C: DriveRlatulippe@romac.com04/19/2000
(Misc)Via LotusScript, Insert a Computed Subform Based on Preview Pane Status?It is not possible to accomplish this completely in LotusScript, since LotusScript does not manipulate subforms. You must use of a formula in a computed subfield in addition to a LotusScript in the QueryOpen event of the form.Rlatulippe@romac.com04/19/2000
(Misc)Use the backend class to manipulate the data exchange between a dialog box and the underlying document.When NotesUIWorkspaceDialogBox brings up a dialog box, the backend class is always there whether or not the underlying document is saved to the disk or not. When you click OK on the dialog box, the Querysave event will not be called, but the Queryclose event is called. For example, you want to do some calculations based on user's input and passed the result to the underlying document or determine which field not to pass. You can use [ noNewFields ] , [ noFieldUpdate ] to accomplish this to a certain degree, but here a way to mix saved and unsaved items. This function performs SomeComplicatedCalculation( ) on the item "Year" and then removes it so it is not passed back to the document. In this example, year is set as a default value on the underlying document and may be changed in the dialog box; however, when the dialog box is saved the original default shouldn't be modified.Rlatulippe@romac.com04/19/2000
(Misc)This button script displays the sum of all OrderTotal fields in a database for one day.Each record in the database has OrderNumber, Date, and OrderTotal fields. The script finds all the documents in the database, then uses a loop and a comparison of dates to limit processing to today's documents. For each document, the script adds the OrderTotal to a dailyTotal variable.Rlatulippe@romac.com04/19/2000
(Misc)Handling a specific errorHandling a specific errorRlatulippe@romac.com04/19/2000
(Misc)DeflateArray Function will remove all duplicate elements in an alphanumeric array (@Unique)This example will take an array of elements containing duplicate names. The function DeflateArray will remove all duplicate elements and pass back the array as a variant. The array will then be formated into a string variable for display in messagebox.Rlatulippe@romac.com04/19/2000
(Misc)How to Use the LotusScript NotesItem CopyItem MethodHow to Use the LotusScript NotesItem CopyItem MethodRlatulippe@romac.com04/19/2000
(Misc)NotesACL and NotesACLEntry classesThe NotesACL class is used to give you access to a database's access control list (ACL). Once the ACL is accessible, NotesACLEntry can be used to retrieve all of the individual entries in the ACL using it's methods GetFirstEntry and GetNextEntry .Rlatulippe@romac.com04/19/2000
(Misc)How to Get Data from an OLE Object via Notes LotusScript Front-End MethodsHow to Get Data from an OLE Object via Notes LotusScript Front-End MethodsRlatulippe@romac.com04/19/2000
(Misc)Dialogbox calls a Form!This script displays a document in a dialog box using the policy form whenever a user clicks the action button. The first layout region on the policy form is sized to fit in the dialog box.Rlatulippe@romac.com04/19/2000
(Misc)Compact all local databases < 90% utilizedChecks all databases Locally and Compacts those that are less than 90% utilized.Rlatulippe@romac.com04/19/2000
(Misc)LotusScript substitute for @DBLookupEver wanted to do a simple @DBLookup in LotusScript? Here's the code to do itRlatulippe@romac.com04/19/2000
(Misc)How can you tell if a view is Private?There is no property in the view thtat lets you do this, but you can look at the design note for the view via this function:Rlatulippe@romac.com04/19/2000
(Misc)QueryDocumentDelete Event to prevent deletion of any document that contains response documents.Disallows deletion of any documents that contains a response document.Rlatulippe@romac.com04/19/2000
(Misc)Preventing Orphan ResponsesWhen you delete a main document, its response documents are not automatically deleted They become "orphan response" documents. To prevent users from creating orphan responses, have the database object's Querydocumentdelete event trigger the following script:Rlatulippe@romac.com04/19/2000
(Misc)Add Roles To ACLThis formula uses LotusScript to add roles to the ACL of a database. Event = "Initialize". No other subroutines are used.Rlatulippe@romac.com04/19/2000
(Misc)Determining if a Notes View is a View or a Folder using the NotesView property, IsFolder.Determine if the object you are dealing with is an actual view, or a folder. To do this, use the NotesView property, IsFolder . IsFolder returns a value of 1, (True) if the object represents a folder, or 0, (False) if the object represents an actual view.Rlatulippe@romac.com04/19/2000
(Misc)Doclinking Parent to Child A Notes formula for doc-linking a parent to a child in Notes R3/4Doclinking Parent to Child A Notes formula for doc-linking a parent to a child in Notes R3/4Rlatulippe@romac.com04/19/2000
(Misc)Conditional Branching: The IF StatementThe IF statement is used to execute other statements based on one or more conditions. Some of the logic used for an IF statement is demonstrated in the following pseudo-code examples:Rlatulippe@romac.com04/19/2000
(Misc)A WAIT FUNCTION???Yes, you'll need to use script and set up a NotesTimer in the form initialize event, when the timer expires it can check the field in the UIDoc and close the whole lot down if there is nothing there....Rlatulippe@romac.com04/19/2000
(Misc)32 bit GetPrivateProfileString funtion call to get Screen Saver and WallpaperReturns Screen Saver and Wallpaper used on Windows system.Rlatulippe@romac.com04/19/2000
(Misc)GetAllviews Sub RoutineWhen called GetAllviews will list all the views and folders in the current database, using the Views method of NotesDatabase Class.Rlatulippe@romac.com04/19/2000
(Misc)Daily Dilbert AgentThis agent is hardcoded to the specific URL to retrieve the daily dilbert page that is available and send it to a user. It should be run in the background on the server.Rlatulippe@romac.com04/19/2000
(Misc)NotesView method FTSearchUsing the NotesView method FTSearch , documents can be located and added to a document collection.Rlatulippe@romac.com04/19/2000
(Misc)Simple Test for Writing to an ODBC Data Source Using LotusScriptThe following test script will evaluate whether you can write to an ODBC source using
LotusScript.		Rlatulippe@romac.com04/19/2000
(Misc)Reloading Rich TextA common problem encountered by Notes developers is the limitation of the NotesUIDocument Reload() method. When you open a document and make changes to its back-end version, you can call the Reload method to display the updates in the front-end version. Changes to rich text fields, however, won't show up. As a workaround, you can close and reopen the current document automatically. For example, the following form action button script takes the current document, appends text to its Body field, closes it, then reopens it. This example assumes there is a view named "AllByUNID" which contains all the documents in the database sorted by UNID.Rlatulippe@romac.com04/19/2000
(Misc)Searching Notes DatabasesSearching Notes DatabasesRlatulippe@romac.com04/19/2000
(Misc)NotesUIDocument method, DocumentRetrieves item values through the `back-end' document that corresponds to the currently open uidocument using the NotesUIDocument method, Document .Rlatulippe@romac.com04/19/2000
(Misc)How to Create a New Database and Replicate it via LotusScriptUsing LotusScript, you can create either a local replica of a server-based database or a server replica of a local database.Rlatulippe@romac.com04/19/2000
(Misc)Agent to Lookup and update another databaseWith a scheduled agent, go through database A and match a field on a document with a field from another document in a different database B. If there is a match, update a couple of fields in database B from information on the document from database A.Rlatulippe@romac.com04/19/2000
(Misc)Removing a View from a Database using the NotesView method, Remove.It is possible to remove a view entirely from a database. To accomplish this, use the NotesView method, Remove .Rlatulippe@romac.com04/19/2000
(Misc)API Call to Get a filename from the user in Lotuscript?This example illustrates how Lotuscript can be used to call a Win32 API Common File Dialog to get a file. Similiar techniques can be used on other operating systems:Rlatulippe@romac.com04/19/2000
(Misc)API to load Windows browserUses a call to a function in the NNOTESWS.DLLRlatulippe@romac.com04/19/2000
(Misc)Update the full text index of the current database.This script updates the full text index of the current database if the database has been modified since the time the index was updated.Rlatulippe@romac.com04/19/2000
(Misc)Access Win32 registry keys in LotusScript?Access Win32 registry keys in LotusScript?Rlatulippe@romac.com04/19/2000
(Misc)Percent Complete in scriptRlatulippe@romac.com04/19/2000
(Misc)How can you display the text of individual table cells using LotusScript in Notes R4?How can you display the text of individual table cells using LotusScript in Notes R4?Rlatulippe@romac.com04/19/2000
(Misc)mci Libdetlef.janssen-seegert@europe.eds.com10/25/1999
(Misc)How do you do @Explode in LotusScript?Breaks a delimited string into its component elements and returns the elements in a string arrayRlatulippe@romac.com04/19/2000
(Misc)Retrieve the Names of all the Views in a Database using the NotesView property, NameRetrieves the names of all the views in a database, use the NotesView property, Name in conjunction with the NotesDatabase View property and the ForAll statement.Rlatulippe@romac.com04/19/2000
(Misc)This button script is useful in a mail message to a group of persons.1. When the recipient clicks the button, the script sends a mail message
indicating "Yes" or "No" for the "RSVP." For testing, the name of the current user is used--in practice, you would use your name.		Rlatulippe@romac.com04/19/2000
(Misc)Quoted ReplyRlatulippe@romac.com04/19/2000
(Misc)IsPrime FunctionGiven a positive integer, determines if that integer is a prime number (A number is considered to be prime if it has no factors other than plus or minus itself and plus or minus one). Returns a Boolean value of True or False.Rlatulippe@romac.com04/19/2000
(Misc)API Call to Retrive Windows System Directory!Uses the function GeSystemDirectoryA in the Kernel32.DLL to retrive the Windows System directory.Rlatulippe@romac.com04/19/2000
(Misc)Agent to change $Ref to new parent documentTakes a given document ID and makes all selected documents responses to that document.Rlatulippe@romac.com04/19/2000
(Misc)Calling Windows Registery APIs to locates Notes executable pathCalling Windows Registery APIs to retrieve registery values from Lotus ScripRlatulippe@romac.com04/19/2000
(Misc)Check RichText Field for NULLWhen in Edit mode checks RichText Field for NULL.Rlatulippe@romac.com04/19/2000
(Misc)How to Fill a Reader Field with Multiple Names via LotusScriptUse the AppendToTextList method of the NotesItem field to Fill a Reader Field with Multiple Names via LotusScriptRlatulippe@romac.com04/19/2000
(Misc)Function to remove excess spaces from a stringRemove all excess spaces from the string sRlatulippe@romac.com04/19/2000
(Misc)Retrieve the name of the Default View in a Database using the NotesView property, IsDefaultView. It is possible to retrieve the name of the default view in a database using the NotesView property, IsDefaultView . Since IsDefaultView is a property of each individual view in the database, it is necessary to test each view in a database until the default view is found.Rlatulippe@romac.com04/19/2000
(Misc)Rules for Creating LotusScript Agents that Execute from a Web BrowserBelow are a list of items to keep in mind while creating LotusScript agents that will be executed from a web browser.Rlatulippe@romac.com04/19/2000
(Misc)Interdatabase Access (LotusScript)Sets up connectivity amoung an application suite set in same path.Rlatulippe@romac.com04/19/2000
(Misc)Checking Validity of Pasted DocumentsThe following script checks to make sure the pasted document uses the correct form and passes all the form's validation formulas. If not, the document is deleted. Use this script with a view's Postpaste event.Rlatulippe@romac.com04/19/2000
(Misc)How to Have a Script in Notes R4 Pause for Some Time and then ContinueBelow are two examples illustrating how to have a script pause for a specified amount of time and
then continue.		Rlatulippe@romac.com04/19/2000
(Misc)Perform a full text search on the current database. It sends the user a newsletter with linksThis action script allows the user to perform a full text search on the current database. It sends the user a newsletter with links to the top ten documents found in the search.Rlatulippe@romac.com04/19/2000
(Misc)Function String ExplodeThis function takes a string and converts it to an array, based on a delimiterRlatulippe@romac.com04/19/2000
(Misc)LotusScript Classes - ExamplesDemonstrates how to create and use a class called DisplayMsgRlatulippe@romac.com04/19/2000
(Misc)Sort - Bubble Sort AlgorithmSorts an array of data using the Bubble Sort AlgorithmRlatulippe@romac.com04/19/2000
(Misc)Script changes the an item on each document selected in a viewThis view action script changes the Status item on each document selected in a view. If someone else edits one of the documents at the same time, the document is not saved. Instead, a response document that contains the change to the Status item is created and saved.Rlatulippe@romac.com04/19/2000
(Misc)Who can edit a field is determined by reading a group of users from view and comparing them to the current userUpon entering a field, a view is read to determine if the person can edit that field. The view that is read is created from a form that has the key eEngine value and the persons in the aTest_Eng (test engineers) field.Rlatulippe@romac.com04/19/2000
(Misc)Evaluate to determine a users role.Use evaluate to determine users role and only then execute block of code.Rlatulippe@romac.com04/19/2000
(Misc)API Call to reference functions in Dynamic Link Libraries ?Calls a C function exported from Windows DLL to get WinDirRlatulippe@romac.com04/19/2000
(Misc)Create a new class to display objectsA very simple example might be to create a class to display a message. We’ll do this in LotusScript by creating a class called DisplayMsg. In the following listing, the DisplayMsg class is shown, where you will see a property called Text and a method called Display.Rlatulippe@romac.com04/19/2000
(Misc)Error handling using IsOpenError handling using IsOpenRlatulippe@romac.com04/19/2000
(Misc)Import a Text File into a Rich Text Item via LotusScriptImports a text file (c:\temp\sample.txt) into a rich text Item named
"Body".		Rlatulippe@romac.com04/19/2000
(Misc)Showing different Subforms on the WebSometimes a document might be to big or to confusing to fill out as one document on the web. One way to break up this document is to create multiple subforms, and on the submit of the form change the subform and reload the page. This method will involve a computed subform, the webquerysave or $$ querysaveagent event, and a field called ChangeSubForm. The Agent will assume that is the ChangeSubForm field equals SubForm2 then the document is finished and it should be submitted.Rlatulippe@romac.com04/19/2000
(Misc)Open a document in edit mode if it exists.Open a document in edit mode if it exists.Rlatulippe@romac.com04/19/2000
(Misc)Count the number of documents in a viewCounts documents in the view "By Author" in the learning.nsf database.Rlatulippe@romac.com04/19/2000
(Misc)Error handling with On ErrorError handling with On ErrorRlatulippe@romac.com04/19/2000
GetHTMLFromRTFGets an HTML string from a RTF field using undocumented methods in Lotus notes for version 5.02 onwards.Shane Hollis11/30/2000
Anonymous09/04/2007
MailStuff LibraryDon Bechtold (beck@eki-consulting.com)06/30/1999
Anonymous02/03/2004
Mail by WEB Agent - From FieldSolution to the "From" Field problem in Web Agentflashlr@hotmail.com06/22/2000
APIAnonymous07/19/2019
APIAPI Anonymous07/19/2019
3
Show details for SQLSQL
2
Show details for Text/KeywordsText/Keywords
2
Show details for Text/Keywords</select></font></td><td+widthText/Keywords</select></font></td><td+width
41
Show details for (Not Categorized)(Not Categorized)
869