Manage LotusScript Technology - Page 2

Generating unique numbers in Domino using LotusScript

This IBM LotusScript tip illustrates the use of Profile Document to generate unique numbers. Continue Reading

Sequential numbers using LotusScript

This script is used for generating sequential numbering of fields in the document. Continue Reading

Creating thumbnail images using LS2J in LotusScript

Learn how to create thumbnail images in Lotus Domino using LS2J in LotusScript. Continue Reading

Putting an end to the frustration of mail merge

This tip provides an answer for anyone who has ever struggled with a Lotus Notes to Microsoft Word mail merge. Continue Reading

Structured error handling in LotusScript

This tip shows you how to do a fair simulation of "Structured Error Handling" in LotusScript. Continue Reading

Switch to user ID, change ID password in LotusScript

I use this code in LS to collect user IDs from a share on a server and gather information about them. I also used the code in a Domain merge to run a list IDs against a server.Continue Reading

Get all members of Domino Directory Group

This code generates a list of users from a group name from the NAB, determines whether the name corresponds to a person or group and breaks each group down into its person members.Continue Reading

Select date range for view

On a view that asks for a "from" date and a "to" date, this button rebuilds the view in front of your eyes to reflect your date changes.Continue Reading

ODBC connection to SQL server using LotusScript

This tip shows you how to create an ODBC connection to a SQL server using LotusScript with the click of a button.Continue Reading

Table in a rich text field

This code is designed to create a non-tabbed table of two rows and five columns in a rich text field to display information.Continue Reading

Permanent NotesLog and Java log come in handy

A particularly useful feature of LS error handling is the NotesLog class. The NotesLog object allows you to create robust permanent error logs from LS programs.Continue Reading

Set date without time via LotusScript

This tip shows you how to set the date without the time section via LotusScript.Continue Reading

AddParameter to a NotesXSLTransFormer

While transforming Notes documents using DXL I needed to add a parameter to the Stylesheet and AddParameter documentation in R6 was non-existent. Here's how it works...Continue Reading

XML encoding a string

The tip contains code that is a LotusScript version of the @URLEncode function.Continue Reading

Copy from one rich text to another

This tip shows you how to copy from one rich text to another.Continue Reading

@Unique and @Elements for LotusScript

The @Unique function in formula is a handy way of removing duplicates. This LotusScript function allows you perform the same function in LotusScript.Continue Reading

Copy attachments in LotusScript without detaching

This procedure copies file attachments from the current Web document to an existing document.Continue Reading

Upload images into selected documents

This tip shows you how to import multiple images into a set of selected documents from a folder.Continue Reading

Remove unnecessary bookmark icons

This shows you how to remove unnecessary bookmark icons.Continue Reading

Get all email headers using LotusScript

To prevent repeat spam, the service provider likes us to send the complete headers of the original email so they can analyze it and deal with it -- impossible in Lotus Notes R5.Continue Reading

Return ASCII character

This simple agent allows the user to enter that character, either by copy/paste or by typing, and then returns that ASCII value.Continue Reading

Good mail forwarding agent

This agent copies a new e-mail, strips the CC and BCC fields), inserts the original "Send to" field and then sends the e-mail to any e-mail address specified.Continue Reading

Load delimited text file

This script agent can be used as an alternative to COL files to parse and build Notes documents.Continue Reading

Fix client mail rules

In forums discussing mail rules, a hot topic seems to be, "they just stopped working." This tips discusses how to fix this.Continue Reading

Compare field values

You can use this class to compare field values between two documents.Continue Reading

LotusScript Floor and Ceiling function

Since LotusScript does not contain a Floor and Ceiling function, as most languages do, we had to come up with our own.Continue Reading

Calculate business days between two dates using Domino directory

This tip primarily uses LotusScript to calculate business days between two dates using your Domino directory.Continue Reading

Get all group member names

This undocumented feature will get all of the names of group members.Continue Reading

Check if user is part of a specific group

Often it is useful to check if the current user is a member of a specific group. The following subroutine allows you to do this.Continue Reading

Hide parts of forms based on group membership

Are you tired of writing complicated Hide/When formulas? Try this instead.Continue Reading

Retrieve selected documents

This piece of code helps in retrieving selected documents on the view or the currently opened document.Continue Reading

Optimize Notes startup for different screen resolutions

I created a new corporate homepage and found it difficult to optimize it for all screen resolutions.Continue Reading

Solving the decimal separator problem

Reading a decimal number from a string can bring you a lot of trouble if you support clients with different decimal separators. Here is a simple code to avoid this problem.Continue Reading

Creating a Notes form dynamically

How to create a Notes form dynamically -- create a form with labels and fields, using LotusScript.Continue Reading

Zip from LotusScript in Notes/Domino 6

LotusScript does not have a native class for compressing files to .zip format -- in this tip, I'll show you how to change that.Continue Reading

Create hotspot buttons on the fly using DXL

Using DXL, learn how to create a hotspot button dynamically and add it to a rich text field on the fly.Continue Reading

LotusScript error handling

This tip provides some details about how to write proper error handling routines. It starts with an overview of theory and then presents an example that puts theory into practice.Continue Reading

Validating a Notes formula from LotusScript

This code can be used to validate a Notes formula before using it in an Evaluate() statement or in a call to db.Search(). It will also tell you the offset of any error.Continue Reading

Get database by title

Get a handle to any database anywhere in your Notes environment. This code works by getting the database details from the Catalog, which should be the root and will not move.Continue Reading

Check those LotusScript errors!

A lesson in proper LotusScript coding.Continue Reading

Optimize performance of your LotusScript code

Ever wondered where the bottleneck is that makes you code so darn slow? With the lsTimer class below, you can easily pinpoint any time-consuming method piece of Lotus script code.Continue Reading

Change view design or scheduled agent runtimes

This LSX lets you use LotusScript to set a parameter doc (NotesDocument) with view criteria (formulas, settings, columns, etc) and then build it.Continue Reading

Quickly parse URL parameters

Tired of cutting out ParentUNID and Count Start when submitting a page from browsers? This function makes a list of parameters and their corresponding values, if any.Continue Reading

A better way to track field changes

If you really to ensure fields have changed, and in an easy way, don't use computed fields to display -- just use LotusScript.Continue Reading

Calculate U.S. holidays for any given year

Add U.S. holidays to your server's holiday list with this code.Continue Reading

@Word in LotusScript

This function in LotusScript is equivalent to @Word function.Continue Reading

Import from Excel

This code allows you to import data from an Excel sheet directly (without saving it first as a Lotus 1-2-3 file).Continue Reading

Andre Guirard on Java vs. LotusScript

We asked SearchDomino.com expert and IBM Lotus developer Andre Guirard which was better -- LotusScript or Java. His response -- "They're each better than the other one."Continue Reading

Build list of views, and open selected view via LotusScript

How to build a list of all views in the current DB and then open the selected view in the specified frame within a frameset.Continue Reading

Sort collection like a view

How to sort a collection the same way a view is sorted.Continue Reading

Deleting 'Private on first use' views/folders

This tip describes how to get around the GetView/NotesDB class/POFU view bug in ND6.Continue Reading

Warning on trimming strings with @Trim and Trim

A warning about trimming functions in LotusScript and Formula.Continue Reading

Trim returns and line feeds

This tip is a LotusScript function that trims the returns and line feeds from a string.Continue Reading

Refresh computed subform

How to calculate for a computed subform after the form is open.Continue Reading

Look for a value in a multi-valued text field

Ever wanted to know if a value is in a list of values using LotusScript? This tip explains how to find out.Continue Reading

Update ACL of selected databases

This code allows you to easily update the ACL (access control list) so that the administration server is changed from the old server to the new server in a migration.Continue Reading

Simple method to select all/deselect all from LotusScript

This code snippet demonstrates using the Windows API to perform Edit -> Select All and Edit -> Deselect All actions from the Notes edit menu.Continue Reading

Retrieving all by role name

How to retrieve all users by their role names.Continue Reading

Debugging QuerySave and QueryClose form events

How to avoid skipping over the default LS debugger when debugging the LotusScript QuerySave and LotusScript QueryClose events.Continue Reading

Prevent users from editing through the UI

How to allow a user to modify a document without having them change it by putting it in Edit mode.Continue Reading

Printing the current document with another form from LotusScript

This tip describes how to print the current document with another form from LotusScript.Continue Reading

Accurate LotusScript timing technique

This tip describes and accurate method for timing LotusScript actions.Continue Reading

Appending items to a text field

This tip describes how to append items to a text field with LotusScript.Continue Reading

Overcome unsorted document collections using Picklist and a categorized view

This tip describes how to overcome unsorted document collections using Picklist and a categorized view.Continue Reading

Using @PickList with LotusScript agents

This tip describes using @PickList with LotusScript agents.Continue Reading

Check attachment size before doc is saved

This tip describes how to check attachment sized before doc is saved.Continue Reading

Find number of working days

This tip describes how to calcualte the number of working days.Continue Reading

How to remove "Enforce uniform/consistent access" flag even without access to the database!

This tip describes how to remove the remove "Enforce uniform/consistent access" flag without access to the database.Continue Reading

Updating Response documents when parent data changes

This tip describes updating Response documents when parent data changes.Continue Reading

Notes Item/Field size limitation

Dynamically write to multiple fieldsContinue Reading

Detach all attached files in selected documents

Detach all attached files in selected documentsContinue Reading

Exporting and importing to and from Excel

An example of a script to import an XLS file into Notes from a view.Continue Reading

Export any view to Excel

Exports all records of any view to Excel.Continue Reading

Using a bubble sort algorithm

Step-by-step instructions for using a bubble sort algorithm.Continue Reading

Collect data with LotusScript and output to Excel

Use LotusScript to collect data from a view or from a database and output it to MS Excel.Continue Reading

Validating Entry Of A Rich Text Field

This function can be used to validate that the user has put something in a Rich Text Field. This is very useful on a form that has RTF that are required entry fields. Call this function from your validation routine to determine if your RTF is empty.Continue Reading