Home > Top 10 LotusScript tips
10 Tips in 10 Minutes:
EMAIL THIS LICENSING & REPRINTS

Top 10 LotusScript tips

27 May 2008 | SearchDomino.com

Lotus Notes, Domino, Workplace and WebSphere tips and advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

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.
Related Resources from SearchDomino.com:
Tutorial: 30 LotusScript tips

LotusScript Learning Guide

LotusScript Reference Center

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.



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
LotusScript
Extracting attachments from a Lotus Notes rich-text field
Programmatically replace the design of Lotus Notes databases
Reading a binary field in an Oracle database with LotusScript
LotusScript equivalent of @Picklist for Lotus Notes
Launch large attachments within an email from a Notes database
How to find files on a hard drive or mapped network with LotusScript
Update the ACL from the Roles view with LotusScript
LotusScript agent moves tagged spam email to junk mail folder
Set a value in a field existing in another Lotus Notes database
Create an automatic scheduled view export in Excel

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 1999 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts