Tips

Tips

• 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 return an HTML representation of a Lotus Notes rich-text field

  Get Java code that returns an HTML representation of a Lotus Notes document's rich-text field to the calling routine.  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

• How to export data from a Lotus Notes database to a CSV file

  Discover an agent that will export data from a Lotus Notes Domino database into a CSV file that can then be imported into almost any other application.  Continue Reading

• Retrieve Lotus Notes names from a nested group using @DBLookup

  Discover how to retrieve a list of Lotus Notes names from a nested group using the @DBLookup command and Formula language code, courtesy of SearchDomino.com member Mike Bryant.  Continue Reading

• Send SMS text messages between Lotus Notes 7 and mobile devices

  Discover a tool download called NotesSMS that enables the sending and receiving of SMS text messages between Lotus Notes 7 and mobile devices.  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

• More efficient local Lotus Notes database replication

  Learn how to make the scheduled replications of your local Lotus Notes databases more efficient by changing their replication priority settings.  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

• Track and record Lotus Notes user logins to Domino Server

  Discover notes.ini settings you can implement that will track and record the Lotus Notes users and IP addresses that log onto your Domino server.  Continue Reading

• How to add keyboard functionality for Lotus Notes documents

  Learn JavaScript code that adds keyboard functionality for Lotus Notes view documents so users can browse and open them via the "Up," "Down," and "Enter" buttons.  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

• Create a computed Lotus Notes field to list Personal Address Book names

  Find out how to create a computed Lotus Notes field that generates a complete list of users in a specific Personal Address Book (names.nsf) group.  Continue Reading

• Use SMTP outbound authentication to relay hosts in Lotus Notes Domino 8

  Discover a new feature in Lotus Notes Domino 8 called SMTP outbound authentication that lets you relay email through hosts instead of your Lotus Domino servers.  Continue Reading

• Show multiple Lotus Notes document fields in a single view column

  You can use multiple Lotus Notes document fields in a single column to show data by using the @explode command with Formula language. In this tip, SearchDomino.com member Olli-Pekka Kamarainen provides a step-by-step example of how to ...  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

• Creating custom views in Lotus Notes databases

  Get code and instructions to set up a Domino agent that lets users easily create custom views in Lotus Notes databases.  Continue Reading

• Converting Lotus Notes Domino Web pages to PDF files with a Java agent

  SearchDomino.com Hall of Famer Michael Marcavage explains how to create a Java agent that lets Lotus Notes Domino users convert Web pages to PDF documents with the push of a Web form button.  Continue Reading

• Validate Lotus Notes Domino fields using JavaScript

  Learn how to use JavaScript to validate any type of Lotus Notes Domino field types, including text, buttons and checkboxes, courtesy of SearchDomino.com member Brad Nelson.  Continue Reading

• Log off idle Lotus Notes users for better Domino Server performance

  You may not realize it, but idle Lotus Notes users are taking up load of unused space and resources on your Domino server. Learn about a simple notes.ini parameter that Domino administrators can set on their servers that will log idle Lotus Notes ...  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

• Copy Lotus Notes databases from the Domino Server console command line

  Learn an undocumented technique that lets you makes copies of Lotus Notes databases from the Domino Server console command line instead of a client.  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

• How to send a document as a link in a Lotus Notes email

  SearchDomino.com Gunasekaran Subramanian explains how to implement Formula language code that will send documents as links within Lotus Notes email.  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

• Setting up Rooms and Resources in Lotus Notes Domino 7

  The Rooms and Resources feature works differently under the covers in Lotus Notes Domino 7, causing configuration confusion for some administrators. This tip explains how to set it up correctly.  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

• Editing fields in a Lotus Notes view with Ajax

  Instead of opening a Lotus Notes view in a pop-up window, editing it and then saving it again, you can modify fields directly using Ajax. SearchDomino.com member Jinoy George explains how.  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

• How to generate formatted sequence numbers with Formula language

  SearchDomino.com member Mohammed Misbahuddin provides step-by-step instructions and Formula language code that will generate five-digit sequence numbers, such as 00001 and 00002, in a Lotus Notes application.  Continue Reading

• How to validate Lotus Notes forms on a Domino server without losing entered data

  When validating Lotus Notes forms in a Web application, loss of field data can occur on the Domino server. In this tip, SearchDomino.com member Sameer Thakur explains how to remedy this problem using a modified WebQuerySave method.  Continue Reading

• How to correct Lotus Notes public key mismatches in four easy steps

  If a public key in the Notes Address Book (NAB) isn't the same as the one in the ID file, processes fail, including email encryption, renames and recertifications, password checking and public key checking, and requests sent to the AdminP task. ...  Continue Reading

• Ajax code equivalent of the @DBColumn formula for Lotus Notes

  Learn how to use the Ajax code equivalent of the @DBColumn formula for Lotus Notes, which can be pasted onto events to return the results of a column.  Continue Reading

• A simpler pagination view for Lotus Notes documents on the Web

  Frustrated by clicking through endless "Next" buttons to reach a buried Lotus Notes document? Learn how to create a simpler pagination view for Lotus Notes documents on the Web  Continue Reading

• How to automatically create a backup copy of your Domino Directory

  SearchDomino.com member Jari Riihimaki provides a Lotus Notes agent that automatically creates a backup copy of your Domino Directory. After implementing this agent, you'll never again need to restore documents back to your Domino Directory or check...  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

• How to perform an in-place upgrade of Lotus Domino server hardware

  Because some Lotus Notes and Domino shops have their current server name deeply embedded in their Lotus Notes agents, they cannot replace their server with one that has a new name. This makes a gradual server upgrade impossible. To solve this ...  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

• Export Lotus Notes documents to Microsoft Word via Internet Explorer

  Use this shared agent to automatically open a Lotus Notes document in Internet Explorer and then copy and paste it into Microsoft Word using the user32.dll Windows system file.  Continue Reading

• Best practices for using the Lotus Notes WebQuerySave agent

  SearchDomino.com member Sameer Thakur explains common pitfalls associated with using WebQuerySave agent and how to avoid them when validating data on a Lotus Notes form.  Continue Reading

• Converting Web pages to images using Java

  Learn how you can use Java code to convert Web pages to images with the click of a button.  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

• Cracked users' HTTP passwords still a threat on many Lotus Notes R6 and R7 domains

  During the course of several recent Domino domain audits, consultant Andy Pedisich discovered what was thought to be an extinct Lotus Notes security problem. Unfortunately, it still seems prevalent in many Lotus Notes R6 and R7 domains. Find out if ...  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

• Easily implement attachment fields in a Web form using Formula

  Using Formula language, SearchDomino.com member Tan Seng Chye outlines how to create multiple attachment fields in a Web form -- e.g., Requester and Approver.  Continue Reading

• How to protect your Lotus Notes application design

  SearchDomino.com member Jim Mck explains how to hide your Lotus Notes database design, so no one can make design changes or copy your application's source code.  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

• Creating Microsoft Word documents from Lotus Notes

  Learn how to create Microsoft Word documents from a back-end Lotus Notes database using Java code.  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

• Loading XML from JavaScript

  SearchDomino.com member Chandra Teja explains how to load XML from JavaScript and manipulate the data in Internet Explorer using the DOMDocument object.  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

• Domino Domain Monitoring pros and cons

  SearchDomino.com contributor Chuck Connell provides an overview of Domino Domain Monitoring (DDM) and outlines strengths and weaknesses of the Notes/Domino 7 administration tool.  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 and why to change replica IDs during a Lotus Notes Domino upgrade

  Replica IDs for system templates like pubnames.ntf and admin4.ntf can cause unpleasant surprises during a Notes/Domino upgrade. SearchDomino.com contributor Andy Pedisich explains how and why you need to change your replica IDs to circumvent ...  Continue Reading

• How to cull elements from a list using Formula

  String and list handling are not completely covered in Formula language. Learn how SearchDomino.com member Peter Skold has circumvented that issue by "inventing" a Formula function to cull elements from a list.  Continue Reading

• Finding unused databases in Lotus Notes and Domino

  Organizations often have hundreds of Notes/Domino databases across many servers, only a few of which have significant usage. Learn how to find and remove unused databases to reduce the disk space and complexity of your Notes/Domino environment.  Continue Reading

• Styling Lotus Domino Web fields

  SearchDomino.com member Clive Atherton provides some simple HTML and step-by-step instructions on how to style Lotus Domino Web fields –- no previous CSS experience required.  Continue Reading

• Archiving Lotus Notes documents to a specified folder

  Archiving Lotus Notes documents is typically a laborious task -- but not anymore. SearchDomino.com member Bob Gouin has created an agent that simplifies the process.  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

• Comparing replicas on clustered Lotus Domino servers

  SearchDomino.com Hall of Fame veteran Blessan Philip provides a script that automatically generates a Microsoft Excel report to compare server replicas in a Lotus Domino cluster -- including actual mail file sizes, quotas and warning thresholds. ...  Continue Reading

• A Lotus Notes approval reminder agent

  Automatically notify coworkers that a Lotus Notes document is past due for approval with this Lotus Notes agent from SearchDomino.com member Stevenson Campbell.  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

• The truth about AutoSave in Lotus Notes/Domino 7

  SearchDomino.com contributor Andy Pedisich explains how the AutoSave feature works in Lotus Notes/Domino 7 for recovering documents from a Lotus Notes database after a nasty "red screen of death" crash occurs -- and warns of a big caveat you need to...  Continue Reading

• Enhanced Lotus Notes agent logging

  When multiple employees are using a Lotus Notes agent, it can be difficult to gather debugging information. This agent from SearchDomino.com member Dennis Lowe assigns each user session a random ID to simplify analysis of your Lotus Notes agent log ...  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

• Creating a Lotus Notes view column categorized by month

  A common problem when creating a Lotus Notes view is designing a column that categorizes documents by month (or quarter). Many Lotus Notes developers have reinvented this wheel many times over, with varying degrees of success. In this tip, ...  Continue Reading

• Remove commas from dollar amounts in JavaScript using a split

  Have you ever tried to add up multiple fields with JavaScript, only to find out that the client entered a comma to separate thousands and millions? This causes JavaScript to drop all of the digits after the comma. SearchDomino.com member Mike Parman...  Continue Reading

• Delete documents over the Web using Ajax and JavaScript

  SearchDomino.com member Rishikesh Sahi provides step-by-step instructions on how to delete documents over the Web using Ajax and JavaScript -- and without having to refresh the current open window.  Continue Reading

• JavaScript to find the operating system user name

  If a user is accessing a Lotus Notes database anonymously, you can find out the person's operating system user name by using the WScript.Shell ActiveX. Just use his JavaScript code provided by SearchDomino.com member Yossi Sabag.  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

• A project-tracking application for Lotus Notes Domino

  Lotus Notes and Domino expert Chuck Connell has revived and updated his popular "Things to Do" task- and project-tracking application for Lotus Notes Domino.  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

• Easily find a string in a Lotus Domino server log

  Finding specific error messages or monitoring for a particular event in a Lotus Domino server log can be almost impossible, given the size of most Lotus Domino server log files. But it just got a lot easier, thanks to this script 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

• How to configure DB2 on a single Lotus Domino server

  Here are 10 simple steps to configure DB2 on a single standalone Lotus Domino server, courtesy of SearchDomino.com member Ashutosh Chandra.  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

• Update a field in all Lotus Notes documents using a Lotus Notes agent

  SearchDomino.com member Mick Crowder provides a Lotus Notes agent that will allow you to update a specific field in all selected Lotus Notes documents with new data.  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

• Locate missing databases in a Lotus Domino cluster

  SearchDomino.com Hall of Famer Blessan Philip explains how to generate a report in Microsoft Excel of all databases that are not present on the Lotus Domino servers in a selected cluster.  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

• How to create non-scrolling Lotus Domino view headers on the Web

  Learn how you can use simple style sheet entries to prevent the scrolling of your Domino view headers.  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 create a dynamic SVG graph using a Lotus Notes agent

  Scalable Vector Graphic (SVG) is a language for describing two-dimensional graphics and graphical applications in XML. In this tip, SearchDomino.com member William Beh explains how to use a Lotus Notes agent to generate a dynamic SVG for a Web site.  Continue Reading

• Using the Enter key to click a button in Lotus Notes

  Instead of using your mouse to click a button or tabbing to a button and hitting the space bar, this JavaScript code from SearchDomino.com member Peter Smith will allow you to hit Enter to click a button in Lotus Notes, just like you can on a Web ...  Continue Reading

• Automatically scan Lotus Notes database document attachments for viruses

  SearchDomino.com member Darren Wright provides a Java agent that will automatically scan document attachments in a Lotus Notes database to check for viruses. If it finds an infected file, it will detach it, clean it and then reattach the ...  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

• Rebuilding views using a scheduled Lotus Domino agent

  This code from SearchDomino.com member Huzefa Amar Haider will rebuild views using a scheduled Lotus Domino agent, which is helpful when using @TextToNumber(today) in a view's column formula.  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