Manage Learn to apply best practices and optimize your operations.

Top 10 LotusScript tips

Get our top ten LotusScript tips for Domino developers to update rich-text fields, import data from Excel, view and edit Lotus Notes documents and more.

Our readers value our LotusScript content, and more importantly, our LotusScript tips. We've compiled our most popular LotusScript tips -- giving you a one-stop guide to shortcuts, workarounds and tricks for those burning Lotus Notes Domino development issues.

This collection of LotusScript tips will help with your everyday development needs -- from importing and exporting data to and from Excel spreadsheets, to updating Lotus Notes rich-text fields, to creating tabular reports and more.


#1. A flexible data export agent for Notes
Get a LotusScript data export agent that allows Lotus Notes users to define any number of their own export configurations (field lists and output files) -- without programming.

#2. A single form to view and edit any Lotus Notes document 
Discover how you can build a dynamic HTML form to view and edit Lotus Notes documents using a Web browser.

#3. Creating and adding to multi-value fields within LotusScript
It's a little bit tricky to create multi-value fields in LotusScript, particularly for a time-date or number field, but it can be done. contributor Chuck Connell explains how.

#4. Export Notes data to Microsoft Excel using the ADODB.Recordset object
Learn how to export a large amount of Lotus Notes data to a Microsoft Excel spreadsheet using LotusScript, the ADODB.Recordset object and SQL.

#5. Update Lotus Notes documents after an employee last-name change
After a last-name change, a Lotus Notes user may no longer have proper access to Lotus Notes documents, because they still contain her old last name. This LotusScript utility from member Scott Huyser solves that problem. It updates all documents in the Lotus Notes database with the employee's new last name.

#6. How to import data from Excel to a Lotus Notes form with LotusScript member Nithya K. explains how to quickly and easily import data from a Microsoft Excel spreadsheet to a Lotus Notes form using LotusScript.

#7. LotusScript equivalent of @DBLookup and @DBColumn
Discover a LotusScript code equivalent of @DBLookup and @DBColumn for Lotus Notes that doesn't decrease Domino server performance.

#8. Dynamically update Lotus Notes rich-text fields using LotusScript 
Learn how you can dynamically update Lotus Notes rich-text fields using LotusScript code -- without having to fire all associated form events in the process.

#9. Programmatically create a shortcut for Lotus Notes 
When used in a form action, this code from member Jon Urwin will invite users to click a button, browse for a file, and then insert a shortcut to that file in a rich-text field. This is ideal for items like a Lotus Notes discussion database, because it provides an easy way for users to create a pointer to a shared file.

#10. LotusScript to create a dynamic tabular report 
A Lotus Notes tabular report is similar to copying a table from a view. Use this LotusScript from Hall of Famer Blessan Philip to create a tabular report dynamically from a Lotus Notes document collection.

Dig Deeper on LotusScript

  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...