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 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 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 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

• 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

• 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

• 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

• 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

• Sending specific agent errors to a mailbox instead of debugging

  In order to get a better handle on application errors, SearchDomino.com member Yonit David built a script library that sends an e-mail to a specific mail database with the error information that can then be categorized by database. In this tip, he ...  Continue Reading

• Export a view to Excel without coding

  This tip shows you how to export a view to Excel without any coding.  Continue Reading

• Dynamically change background color of a Notes doc

  This tip allows you to change background color on the fly by the user choosing the color on the form itself.  Continue Reading

• Simulating dynamic fields and labels

  Often, one must dynamically create labels and fields on the Notes client. This code simulates dynamic fields and labels creation on the Notes Client.  Continue Reading

• Chapter 18: JavaScript and embedded objects

  Get an introduction to what is possible with embedded objects when using JavaScript.  Continue Reading

• Categorizing views based on related multi-valued fields

  How to show related multi-valued fields sorted in a view.  Continue Reading

• Leverage the progress bar within Notes

  How to utilize a progress bar that displays percentage progress within a message box display.  Continue Reading

• Managing recertification

  How to best deal with ID recertification timing.  Continue Reading

• Debugging QuerySave and QueryClose form events

  How to avoid skipping over the default LS debugger when debugging the LotusScript QuerySave and LotusScript QueryClose events.  Continue Reading

• Entering unicode characters

  This tip describes entering unicode characters on a Domino system.  Continue Reading

• JavaScript to open a form in a browser window without tool bar & menu bar

  This script will hide your toolbar and menu bar from window browser.  Continue Reading

• Merge multiple Excel spreahsheets into single one

  This tip describes how to mrge multiple Excel spreahsheets into single one.  Continue Reading

• How to remove "Enforce uniform/consistent access" flag even without access to the database!

  This tip describes how to remove the remove "Enforce uniform/consistent access" flag without access to the database.  Continue Reading

• OCR: Abbyy FineReader integration

  This tip describes how to integrate optical character recognition into your system.  Continue Reading

• Bullet proof the PickListStrings method

  This tip describes how to make the PickListStrings method more resiliant.  Continue Reading

• Importance of adding all data fields to a form

  This tip highlights the importance of adding fields to a form.  Continue Reading

• Easiest way to get server time

  This tip describes how to retrieve the server time  Continue Reading

• Multiple e-mail addresses

  If your company has merged with another, or your company is changing its name here's how to get multiple email addresses.  Continue Reading

• Remove consistent ACL flag

  The following code for a button removes the flag and allows me to open the database with manager rights.  Continue Reading

• Log deleted documents

  This short script makes a copy of documents that are deleted.  Continue Reading

• Fix corrupted view on local database

  I recently had to help a remote user, working of their c: drive, fix a corrupted view.  Continue Reading

• Lookup information from the NAB

  Lookup information from the NAB (Domino Directory) using @Commands or LotusScript.  Continue Reading

• LotusScript class to track modification history

  This code computes and displays the modification history of a document.  Continue Reading

• Resolve the groups using formula language

  The "@ExpandNameList" is an undocumented formula which is used which can be used in resolving the groups.  Continue Reading

• Printing document with embedded view - Show single category

  To mimic what you see on screen when printing documents I created another form with 4 rich text fields.  Continue Reading

• Field validation for file upload control element

  Here's a field validation for the File Upload Control element. I've only tried this where there is one Upload Control.  Continue Reading

• Right icon attaching file via LotusScript

  Here is an easy way to attach a file via Lotus Script and display the right icon (not Appear as V2 Style Attachments).  Continue Reading

• Programmatically set "User Preferences" options

  You can set most user preference options by affecting a change to the "Preferences=" Notes.ini variable.  Continue Reading

• Read email without sending read receipt

  How to read an email without sending a read receipt.  Continue Reading

• LotusScript agent to send all field values to email recipient

  LotusScript agent to send all field values to email recipient  Continue Reading

• Scrollable checkboxes

  Using HTML Style sheets, checkbox fields can now have scrollbars.  Continue Reading

• Excel import into Lotus Notes

  This imports data from Excel into Lotus Notes, skipping blank lines and column headers.  Continue Reading

• Peer-to-Peer

  Groove: peer-to-peer instant messaging and collaboration tool  Continue Reading

• Using the Admin Client on the Domino Server without installing it

  Using the Admin Client on the Domino Server without installing it  Continue Reading

• Re-Attach ID files

  We needed a way to re-attach the Notes ID file back to the person document for iNotes Outlook/DOLS installs.  Continue Reading

• Popup Menus made easy in your applications

   Continue Reading