Manage

LotusScript

• LotusScript creates drag and drop interface in Lotus Notes client

  Using this LotusScript, you can create a drag and drop interface that you can implement in your users' Lotus Notes clients, allowing them to move documents from one view to another. Continue Reading

• LotusScript agent moves new mail to folder

  Use this LotusScript agent in a Lotus Notes mail-in database to move new mail to a specified folder. Continue Reading

• Eight easy steps to open and view Flash files in Lotus Notes

  Use these 8 steps and some LotusScript to open and use Macromedia Flash files in a Lotus Notes client. Continue Reading

• LotusScript agent parses ACL to Microsoft Notepad

  After modifying a database, emailing large groups of users about the update can be a nuisance. This LotusScript agent will help you efficiently keep users abreast of database changes. Continue Reading

• LotusScript finds the first occurrence of a string from the right

  Using the Instr function can help to find the first occurrence of a string from the left. However, if you want to find the first occurrence from the right, you can use this LotusScript code. Continue Reading

• Clear Recent Contacts view and prevent repopulation in Lotus Notes 8.x

  A new feature in Lotus Notes 8 is the inclusion of a Recent Contacts view. If you're not a fan of the feature, insert this LotusScript code in a button and email it to your users. Clicking the button will clear the view and prevent repopulation.Continue Reading

• Search Microsoft Active Directory with LotusScript

  Since many companies use both Lotus Notes and Microsoft, having the ability to search Active Directory from a Lotus Notes view can be helpful. This LotusScript searches AD without having to rely on a third-party driver.Continue Reading

• Three steps to trap and handle save conflicts with LotusScript

  Save conflicts can cause problems in Notes/Domino databases when one or more users open a document with a link. That document then opens several times in the Notes client. Use this LotusScript code to trap and handle save-conflict issues before they...Continue Reading

• LotusScript sorts lists alphabetically

  There are a lot of things you can accomplish using the List data type in Lotus Notes. But it doesn't allow you to sort objects alphabetically. This LotusScript code will do the trick.Continue Reading

• LotusScript code rebuilds corrupted busytime.nsf file

  The Notes/Domino busytime.nsf file can become become corrupted, causing problems with the Resource Reservations database. Use this LotuScript code to rebuild busytime.nsf files nightly -– without deleting busytime.nsf.Continue Reading

• LotusScript agent automates selective mail file replication

  You can use selective replication to replicate sets of documents in a Notes/Domino database. But what if you need to replicate several Notes/Domino databases? Get the steps and LotusScript agent to set a replication formula for multiple mail files.Continue Reading

• LotusScript filters and attaches files to a Notes form

  Using the workspace.OpenFileDialog method lets you filter file types before attaching them to a Notes field form. You can modify this method further by limiting the size of attachments. Get the steps and LotusScript you need here.Continue Reading

• How to create mail files using a LotusScript agent

  This LotusScript agent duplicates the AdminP email file creation process by pulling information from a Domino Directory in Lotus Notes/Domino 6.x and higher.Continue Reading

• Extract value pairs from text arrays with LotusScript

  Use this LotusScript code to extract value pairs from a text array. In this example, see how various Work Flow status stages were extracted and summarized, allowing the results to be more easily analyzed.Continue Reading

• LotusScript button updates email addresses in Lotus Notes PAB

  Send Lotus Notes users an email message that contains this LotusScript-coded button. This button will allow them to easily update an email in the location document of their Personal Address Books (PABs). The button automatically notifies the ...Continue Reading

• Code exports Lotus Notes data to an OpenOffice Calc spreadsheet

  The ability to transfer Lotus Notes data from a database to an Excel spreadsheet has been available for some time. If you're using OpenOffice.org Calc spreadsheets, however, you'll need to use this LotusScript code instead.Continue Reading

• Coding a stack trace into LotusScript libraries eases error handling

  You may be familiar with Java's stack trace information. Did you know you can also code a stack trace into your LotusScript libraries and agents? Use this quick code in your Lotus Notes environment.Continue Reading

• LotusScript agent indexes Lotus Notes/Domino databases

  Are you looking for a simpler way to search for information in your Lotus Notes/Domino databases? Use this LotusScript agent to automatically index databases according to specified keywords.Continue Reading

• LotusScript button saves time searching large Lotus Notes databases

  Searching large Lotus Notes databases is time consuming. This LotusScript code can be placed in a button to quickly perform a search of your Lotus Notes database by replacing the view selection criteria per the search query. Use this method to ...Continue Reading

• How to clear a Lotus Notes local cache with LotusScript

  If you tend to update the design of your Lotus Notes database frequently, embed this LotusScript code in a button, which lets users clean their local caches without deleting the cache.ndk file. This tip works with Lotus Notes versions 6.x, 7.x and 8...Continue Reading

• Create a non-specified date picker with LotusScript code

  Have you been searching for a way in your Domino environment to use an embedded datepicker in a dialog box that isn't associated with a specific field? Here's a solution that uses Domino's current datepicker and dialog box, some LotusScript code and...Continue Reading

• LotusScript accesses clipboard to view copied Notes documents

  Find out how to access copied Lotus Notes documents on your clipboard with this downloadable LotusScript code. This tip is helpful when using queryPaste events to determine what content is being pasted into a Lotus Notes database.Continue Reading

• LotusScript action button manages Lotus Notes mail files

  This LotusScript code creates an action button that, when applied to any view or folder in Lotus Notes mail files, makes mail file management easy. Using a single action button, Lotus Notes Domino users can easily manage their mail files, ...Continue Reading

• LotusScript sorts a Lotus Notes document collection

  This LotusScript code shows how to sort a Lotus Notes document collection in ascending order using a specified field (text/date/number) as the key. The code is customizable, so you can easily change it to meet your needs.Continue Reading

• Display Lotus Notes user group membership details in a tree view

  Determining which groups a Lotus Notes user belongs to is important, but difficult if you don't have access to the proper databases. This tip explains how to display a tree view of the groups and nested groups to which a user belongs with just the ...Continue Reading

• Alternate version of @Command forwards subform via LotusScript

  The @Command([MailForward]) function lets you place an UI document's contents into a mail memo and forward it. If you only want to forward a portion or subform of the UI document, this tip can show you how, using a LotusScript alternative.Continue Reading

• How to use LotusScript to modify a Lotus Notes view selection

  If you've been looking for a way to use parameters to limit a Lotus Notes view selection, you're in luck. This tip gives the LotusScript and a few examples to help you.Continue Reading

• Display a custom message box using a LotusScript-generated button

  Use this LotusScript code to create a button featuring a customized message box that appears automatically after running a Lotus Notes application.Continue Reading

• Extracting attachments from a Lotus Notes rich-text field

  Learn how to extract attachments from a Lotus Notes rich-text field by inserting this LotusScript code into an agent and running it from the Actions menu.Continue Reading

• Programmatically replace the design of Lotus Notes databases

  Trying to programmatically replace the design of several Lotus Notes databases, but can't find an out-of-the box solution? This LotusScript code can help.Continue Reading

• Reading a binary field in an Oracle database with LotusScript

  Use this LotusScript code to read a binary field in an Oracle database, allowing you to find Microsoft Word documents, spreadsheets, PDFs and JPEG files.Continue Reading

• LotusScript equivalent of @Picklist for Lotus Notes

  Get the LotusScript code alternative to @Picklist([Folder]), to select folders in a Lotus Notes database.Continue Reading

• How to find files on a hard drive or mapped network with LotusScript

  Place this abridged LotusScript code into a button to quickly drill down and locate Lotus Notes files on either a hard drive or a mapped local drive.Continue Reading

• Update the ACL from the Roles view with LotusScript

  Discover the LotusScript code used to create a button that lets you update access control lists (ACL) from the Roles view in Lotus Notes Domino databases.Continue Reading

• LotusScript agent moves tagged spam email to junk mail folder

  Apply this LotusScript agent to the Mail File to detect incoming email messages tagged as 'spam:' in Lotus Notes, and move them to the junk mail folder.Continue Reading

• 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.Continue Reading

• Create a personalized greeting for Lotus Notes database users

  Create a personalized note using LotusScript code and a PostOpen event to greet Lotus Notes database users by first name and time of day upon logging on.Continue Reading

• How to export Lotus Notes views to a Microsoft Excel database

  Exporting data from Lotus Notes views into Microsoft Excel can be simple. Learn how by using a LotusScript agent, a shared action and HTML table formatting.Continue Reading

• Create file system labels for Microsoft Excel and Word mail merges

  Use LotusScript code to automatically create file system labels in a Microsoft Excel file and a Microsoft Word mail merge template that uses Avery labels.Continue Reading

• Capture rich-text comments in Lotus Notes fields using LotusScript

  Use the NotesRichTextStyle class in LotusScript to capture rich-text comments, such as colors and various font sizes in Lotus Notes fields.Continue Reading

• Retrieve cell values from tables in a Lotus Notes rich-text field

  Get LotusScript code to retrieve and display values from cells within a table in a Lotus Notes rich-text field (RTF).Continue Reading

• Adding new variable-sized, multi-value fields to Lotus Notes documents

  Learn how to add new variable-sized, multi-value fields to Lotus Notes documents using this LotusScript code.Continue Reading

• Keep the original Universal ID when copying a Lotus Notes document

  Use this LotusScript code to keep the original Universal ID when copying a Lotus Notes document with the NotesDocument class.Continue Reading

• Append Lotus Notes text in Microsoft Notepad to avoid text size limits

  Find out how you can use LotusScript to open, copy and append Lotus Notes text in Microsoft Notepad to avoid the Lotus Notes text size limitation.Continue Reading

• Setting up return receipts for LotusScript-generated Lotus Notes email

  Discover how to implement the Lotus Notes return receipt feature for LotusScript-generated email messages.Continue Reading

• Show unread marked Lotus Notes email messages using LotusScript

  Use this LotusScript and Formula language code to determine the read status of another user's Lotus Notes email messages.Continue Reading

• How to correctly use the GetDocumentByUnid method in LotusScript

  Developers often use the LotusScript GetDocumentByUnid method incorrectly and get ghost Lotus Notes documents or errors. Learn the right way to use it.Continue Reading

• Using Lotus Connectors and ODBC to update Lotus Notes records

  Discover LotusScript code that uses Lotus Connectors and ODBC to update Lotus Notes records.Continue Reading

• Play a sound from the Lotus Notes client using LotusScript and OLE

  Learn an alternative method to using the NotesUIWorkspace PlayTune to play sounds from a Lotus Notes client that uses Object Linking and Embedding (OLE) and LotusScript and doesn't require the sound file to be stored locally.Continue Reading

• 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.Continue Reading

• Send Lotus Notes email messages using LotusScript

  Want to send a Lotus Notes email message by using LotusScript? You don't have to hardcode the attributes. This code will do it for you.Continue Reading

• Auto-generate LotusScript setter and getter properties for class variables

  Learn LotusScript "cheat" code that will automatically generate setter and getter properties for your class variables.Continue Reading

• Remove orphaned Lotus Notes documents on Domino databases with a 'virtual delete'

  Learn about a 'virtual delete' LotusScript solution that will remove orphaned and extraneous Lotus Notes documents on your Domino databases.Continue Reading

• Enable or disable scheduled agents without opening the Lotus Notes database design

  Get instructions and LotusScript code that will enable or disable scheduled agents from the Lotus Notes UI without having to open the database design.Continue Reading

• Access Lotus Notes shared resources with a dynamic Domino URL command

  Learn how you can use the dynamic Domino R6 URL command "?OpenFileResource" to access shared resources in a Lotus Notes database.Continue Reading

• LotusScript to search Lotus Notes documents created in a specific time zone

  SearchDomino.com member Gunasekaran Subramainian explains how to create a button using LotusScript that will search for Lotus Notes documents created in a specific time zone and within a specified date and time range.Continue Reading

• LotusScript to create a dynamic tabular report from a Lotus Notes document collection

  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.Continue Reading

• LotusScript code to update and save Lotus Notes profile documents

  Learn how to use LotusScript code to create an action button that will save and update profile documents in Lotus Notes applications, courtesy of SearchDomino.com member Vinay Sharma.Continue Reading

• LotusScript equivalent of @DBLookup and @DBColumn for Lotus Notes and Domino Server

  SearchDomino.com member Nithya K. shares a LotusScript code equivalent of @DBLookup and @DBColumn for Lotus Notes that doesn't decrease Domino Server performance.Continue Reading

• How to fix the size limitation on Lotus Notes summary text fields

  There is a size limitation in summary text fields for all versions of Lotus Notes. This causes problems when users try to display, edit or save the document. SearchDomino.com member Brent Quick outlines the details of this issue and provides a ...Continue Reading

• How to import data from Microsoft 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.Continue Reading

• Copy email and attachments to a Lotus Notes database using LotusScript

  Learn how to add a LotusScript-generated button to users' email that will copy an entire email, including attachments, to a Lotus Notes database with a single click.Continue Reading

• Export Lotus 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.Continue Reading

• 10 everyday LotusScript tips

  Here are some LotusScript best practices you should employ as part of your everyday coding. These intermediate-level tips will help you polish your routine coding methods and secure your LotusScript code.Continue Reading

• 10 fundamental LotusScript tips

  Here are 10 basic LotusScript techniques that you should already be using if you've had any previous exposure to LotusScript. These beginner-level tips are also perfect for a Notes/Domino developer just getting started with LotusScript.Continue Reading

• 10 advanced LotusScript tips

  Here is some advice to experienced developers who want to take their LotusScript skills to the next level. These advanced-level tips will challenge you to use more complex LotusScript commands to improve the functionality, performance and clarity of...Continue Reading

• Easily show and hide layers in a Lotus Notes database

  SearchDomino.com member Jane Griscti provides simple instructions and LotusScript code that will easily allow you to show or hide layers in a Lotus Notes database.Continue Reading

• A flexible data export agent for Lotus Notes

  SearchDomino.com contributor Chuck Connell provides 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.Continue Reading

• How to 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 ...Continue Reading

• Secure Microsoft Excel spreadsheets with LotusScript

  Want to protect your Microsoft Excel spreadsheets from tampering? This LotusScript code from SearchDomino.com member Prasad Knair programmatically lets you secure a Microsoft Excel file with a password and prohibit what columns can be edited.Continue Reading

• Managing Lotus Notes doclinks with LotusScript

  When working with numerous doclinks in a Notes/Domino application, it's easy to lose track of them. This LotusScript code from SearchDomino.com member Benoit Dubuc finds and validates all doclinks in a Lotus Notes database.Continue Reading

• 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 ...Continue Reading

• A single form to view and edit any Lotus Notes document

  SearchDomino.com member Leonard Volovets explains how you can build a dynamic HTML form to view and edit Lotus Notes documents using a Web browser.Continue Reading

• 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.Continue Reading

• How to create a comments field for Lotus Notes documents

  SearchDomino.com member Ray Green explains how to create a comments field for Lotus Notes documents by setting up two simple fields and adding some LotusScript code.Continue Reading

• Workaround for @DBLookup error: 'The specified database lookup generated more than 65,000 bytes of r

  It's common to receive this error message when performing an @DBLookup: "The specified database look-up generated more than 65,000 bytes of results, which is too large for Lotus Notes to handle in this context." SearchDomino.com member Vinay Betala ...Continue Reading

• Create a Lotus Notes ACL analyzer using LotusScript

  When looking at an access control list (ACL) in a Lotus Notes database, you can only view information for one ACL entry at a time. For easier analysis, this LotusScript code from SearchDomino.com member Joe Steblay compiles all ACL information for a...Continue Reading

• Setting row colors by category in a Lotus Notes view

  Discover how you can set row colors to different categories in a Lotus Notes view, even when the categories are unknown or dynamic, using Formula and LotusScript.Continue Reading

• Using the GetAllDescendants Sub in LotusScript

  When passing values to all descendants in LotusScript, the Responses property only gives you immediate responses. But if you want to get all descendants and then "stamp all" the values you want, you can't. That's where this LotusScript code from ...Continue Reading

• Changing a Lotus Notes database mail file from 'archive' to 'mail'

  If a Lotus Notes database mail file spuriously shows "Archive" instead of "Mail," this LotusScript code will remedy the problem.Continue Reading

• LotusScript to create repeating reminders in a Lotus Notes calendar

  When triggered from within a mail file in Lotus Domino R6, this LotusScript code from SearchDomino.com Hall of Famer Blessan Philip will set a repeating reminder in a user's Lotus Notes calendar.Continue Reading

• How to retrieve the template name for a Lotus Notes database

  The Lotus Notes NotesDatabase class provides a method to determine a template name, but it only works for the template file itself -- template.ntf. While there's no prescribed method to grab the true template name for a Lotus Notes database, ...Continue Reading

• Creating a column color chart on a Web page using LotusScript

  Adding this LotusScript code to an agent will create a simple column chart on a Web page using divs. The script generates random colors and values, so you may need to provide your own values if you want further customization.Continue Reading

• Populating a number field using LotusScript

  SearchDomino.com member Jerry Fogle offers a quick LotusScript technique that will populate a number field on a Lotus Notes UI document with a processed list. All you have to do is create a number field with "allow multiple values" and "computed ...Continue Reading

• Finding files and directories with LotusScript

  LotusScript provides a simple Dir$ command to check for the existence of a file or directory, but there are a few wrinkles you need to know about in order to use it correctly.Continue Reading

• How to insert RichText into RichText using LotusScript

  You can append Richtext to another RichtextItem using LotusScript, but there's no function that allows you to insert Richtext. But, after some trial and error, SearchDomino.com member Ulrich Krause has figured out a way it can be done ...Continue Reading

• Exporting email from Lotus Notes to .EML messages

  Have you ever wanted to store your Lotus Notes email in a file system, but still be able to keep the whole context of the email together? SearchDomino.com member Arthur Turner explains how to extract individual email items and store them in a file ...Continue Reading

• Converting XML files into Lotus Notes documents

  This LotusScript agent from SearchDomino.com member Genesio Zomparelli parses XML into a standard DOM (Document Object Model) tree using the NotesDOMParser class.Continue Reading

• Invoking Web services via LotusScript

  If you don't want to use the IBM SOAP Connect examples, SearchDomino.com Giles Hinton provides an alternative class in LotusScript code that uses the Microsoft XMLHTTP parser to invoke and return values from a Web service.Continue Reading

• Prompting a Lotus Notes user for input using LotusScript

  In increasing order of complexity and usefulness, SearchDomino.com contributor Cregg Hardwick explains four ways you can prompt a Lotus Notes user for input using LotusScript: InputBox, MessageBox, NotesUiWorkspace, and the DialogBox method.Continue Reading

• Move folders from one Notes database to another using a LotusScript agent

  SearchDomino.com member Marko Bonaci provides a LotusScript agent that will move folders from your current Notes/Domino database to another that you specify.Continue Reading

• Sign a Notes/Domino database with three lines of LotusScript

  SearchDomino.com member Hemang Kapadia offers this simple LotusScript code snippet that will let you sign a Notes/Domino database without haveing to go through Lotus Notes Administrator.Continue Reading

• How to transfer values between Lotus Notes and Internet Explorer

  In this tip, SearchDomino.com member Janardan Pagadala explains step-by-step how to use LotusScript to open an Internet Explorer browser as dialog box to transfer values between a Lotus Notes client and a Web-based application.Continue Reading

• LotusScript version of @DbColumn

  SearchDomino.com member Marko Bonaci offers this LotusScript code that performs the same function as the @DbColumn formula.Continue Reading

• Appending two NotesDocumentCollections

  In this tip, SearchDomino.com member Michael Adams shows you some simple LotusScript that will append two NotesDocumentCollections together.Continue Reading

• Manipulating the header and footer of Microsoft Word using LotusScript

  Our LotusScript expert Cregg Hardwick explains how to manipulate the header and footer of Microsoft Word using LotusScript and COM.Continue Reading

• Don't change created date of a Lotus Notes document via LotusScript

  This user wants to know if it's possible to modify the created date of a Notes document and a Notes database --either with (or without) LotusScript or with another Windows utility.Continue Reading

• Common function for sending mail

  This LotusScript agent presents a common function for sending e-mail. It can be set up to send e-mail to multiple users.Continue Reading

• Open a document in a dialog box from a view

  With this LotusScript code, a document will open in a dialog box instead of in a new window.Continue Reading

• Using w.dialogBox in LotusScript

  Are you tired of response documents with @command[compose]... in full screen ? Do you want something more user friendly? Try the NotesUiWorkSpace.DialogBox method class.Continue Reading