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.

TOP 10 LOTUSSCRIPT TIPS

#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. SearchDomino.com 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 SearchDomino.com 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 
SearchDomino.com 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 SearchDomino.com 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 SearchDomino.com Hall of Famer Blessan Philip to create a tabular report dynamically from a Lotus Notes document collection.

This was first published in May 2008

Dig deeper on LotusScript

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close