Tips

Tips

• Load balancing relay hosts

  Use IP addresses separated by a comma.  Continue Reading

• Field change agent

  A LotusScript agent that prompts the FLS member for the field name to be zeroed out.  Continue Reading

• Date/Time of created documents is incorrect

  Date/Time of created documents is incorrect. Here's how to fix it.  Continue Reading

• Gather usage statistics within a database

  Track the activity in a database, who is using it and what exactly is being used.  Continue Reading

• Reader fields - - an oldie but goodie

  Reader fields are Domino's per-document security method.  Continue Reading

• Creating a random/unique number

  Get a 4-digit random number.  Continue Reading

• Table of view and action icons

  Here is how to display a list of view and action icons available for use.  Continue Reading

• Dblookup w/o 64k limit

  Instructions to make a dblookup with more than 64k of data.  Continue Reading

• Reply without attachments

  There is nothing more annoying than receiving a reply to a message you sent with your original attachment included.  Continue Reading

• DOLS offline address book

  A way to DOLS enable the Public Address Book for use with Inotes.  Continue Reading

• Delete dead mail agent

  Here's how to delete a dead mail agent.  Continue Reading

• Discovery Server

  IBM has pulled the plug on K-station; parts of it will be appear in IBM?s WebSphere Server Portal early next year.  Continue Reading

• Replace database design on selected people in address book

  Replace database design on selected people in address book  Continue Reading

• Restrict users from opening new Domino sessions

  Restrict users from opening new sessions with the Domino server.  Continue Reading

• Most useful Notes/Domino URLs

  URLs to help the beginner.  Continue Reading

• Collect data with LotusScript and output to Excel

  Use LotusScript to collect data from a view or from a database and output it to MS Excel.  Continue Reading

• Storing user-created HTML form fields in Notes

  Storing user-created HTML form fields in Notes.  Continue Reading

• Concatenating two arrays/strings with Trim and Unique option

  Concatenating two arrays/strings with Trim and Unique option  Continue Reading

• Forcing frameset launch on database open

  Forcing frameset launch on database open  Continue Reading

• Alias email addresses

  How to set up email addresses.  Continue Reading

• Removing unwanted space from in between tables

  Simple method for removing unwanted space from in between tables  Continue Reading

• LotusScript agent to send all field values to email recipient

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

• Print attachments with OLE Automation or a WindowsAPI

  Print attachments with OLE Automation or WindowsAPI  Continue Reading

• Keeping the search bar enabled at all times

  Here's an easy way for keeping the search bar enabled at all times when the user open the database.  Continue Reading

• Removing document encryption

  Here's the method to remove the encription from a NotesDocument object through LotusScript.  Continue Reading

• Create link action hotspot

  Using keywords, run Agent on the Web.  Continue Reading

• Accessing a Domino server via the Internet using the Notes Client

  Accessing a Domino server via the Internet using the Notes Client  Continue Reading

• Cell background image for the Web

  Design a cell background image for the Web.  Continue Reading

• Javascript alternative to @ReplaceSubstring

  When pushing values in and out of the Query_String I often have to replace spaces with "+" symbols.  Continue Reading

• Using roles to build send to fields

  Using roles to build send to fields  Continue Reading

• Set the Window title of Notes client

  Set the Window title of Notes client  Continue Reading

• Get current location doc with LotusScript

  Get the current location doc with LotusScript.  Continue Reading

• Scrollable checkboxes

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

• Simple freetime (busytime.nsf) corruption fix

  Simple freetime (busytime.nsf) corruption fix  Continue Reading

• Developing Notes applications in Assembler language

  Tips on developing in Assembler  Continue Reading

• Moving a database to another server

  How to move a database to another server  Continue Reading

• Export to Word Script

  A short routine to export to Word script  Continue Reading

• View and open documents from another database

  View and open documents from another database.  Continue Reading

• Easy way to change HTTP password

  Here's an action to a mail template which automates the HTTP passwords.  Continue Reading

• Passing Parameter from LotusScript Agent to Java Agent

  Passing Parameter from LotusScript Agent to Java Agent and writing the data in Oracle using JDBC Oracle Thin Driver  Continue Reading

• Domino and Linux

  searchDomino users want to know -- about Linux, that is.  Continue Reading

• RichText objects appearing in UIDoc

  Add a doclink and have it appear immediately instead of closing the doc and opening again.  Continue Reading

• Print a greeting in the status bar

  Code to print a greeting in the status bar  Continue Reading

• Don't use GetNthDocument

  The GetNthDocument method is widely publicized as the way to loop through a collection.  Continue Reading

• Dynamic name/value pairs for HTML select fields

  Generate name/value pairs in Domino with a small amount of code.  Continue Reading

• Separate the "STG" graphics from the real attachments in @AttachmentNames

  This quick formula filters out all the associated Icon graphics and leaves you with just the "FilesNames".  Continue Reading

• Finding the Last Date of a Month

  Since not all the months in the calendar have the same number of days, this tip shows a simple way to find out the last date.  Continue Reading

• Recovering a Deleted Workspace Tab

  If you accidentally delete a Workspace tab, what can you do? Here's the answer!  Continue Reading

• Handling errors in @DbColumn/@DbLookup

  Entry not found in index or view index not built (or) Server Error: Entry not found in index! - Sounds familiar?  Continue Reading

• ACL manager

  Save ACL, stop Access to DB, Reload ACL  Continue Reading

• Get server environment variables from a script running on a workstation

  This tip is for getting the full directory path on which Domino is installed.  Continue Reading

• Export To Excel

  You can create an export to Excel agent that uses OLE to export contents of a Notes view directly into Excel.  Continue Reading

• Script to find a character code (CHR

  Find the ASCII character code for equivalent text. For example, ...CHR$(34)... is a double quote(").  Continue Reading

• Hide File-Edit-View menu in Notes applications

  There is a way in Lotus Notes 4+ to completely hide the Windows-standard menus at the top of the screen.  Continue Reading

• View all hidden views

  There is an undocumented feature built into the Notes client that allows users to view all hidden views in a database.  Continue Reading

• Recreating print view on the Web

  To recreate the "Print View" functionality of the Notes client on the web, I used a single agent.  Continue Reading

• Update workspace icon when moving a database

  A button that removes anold database, opens the new one and consequently adds a "corrected" icon to the workspace.  Continue Reading

• Script version to find last date of month

  This script finds the last date of the month whether or not the month has 28, 29, 30 or 31 days.  Continue Reading

• Desktop.dsk display workspace pages and icons

  ViewDesk is an executable file that will read an R4 desktop.dsk or R5 desktop5.dsk file.  Continue Reading

• Configuring Notes/Domino with Crystal Reports

  Crystal Reports 8.0 is a great tool for creating professional reports with Notes/Domino data.  Continue Reading

• View your local application on the web without a server

  You can watch your local web enabled applications. You don't even have to open your client.  Continue Reading

• Execute code when a radio button or checkbox is selected

  At times it can be useful to execute some code when a radio button or checkbox is selected.  Continue Reading

• Forward mail including mail headers

  How to visualize and forward spam mail including header information  Continue Reading

• Remove quotes from a string in a field

  Use this code to remove quotes from a string in a field.  Continue Reading

• @Command({ViewRefreshFields}) functionality in Javascript

  During web application development it would be great to have something like "@Command([ViewRefreshFields])"  Continue Reading

• Notes URL tricks

  People often overlooked capabilities of so-named Notes URLs.  Continue Reading

• Combining LotusScript, JavaScript and Formula language

  To create hidden hotspot buttons on a form. You can call these buttons with JavaScript in both the client and the web.  Continue Reading

• Validating a richtext field for attachments

  Validating a richtext field whether it is having an attachment or not.  Continue Reading

• Show who last edited document in view

  I used the following formula to easily show the Common Name of the person who last edited.  Continue Reading

• Calculate date ranges excluding weekends and company holidays

  To use this script, you need a form with the fields StartDate, and Length for the time frame.  Continue Reading

• Excel import into Lotus Notes

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

• Create a section with an action button

  Create a section with an action button.  Continue Reading

• Dynamic HTML table as an action bar

  For a recent Web-based intranet project using R5, the users wanted the main data entry form to have an action bar.  Continue Reading

• How to resolve the problem of planning in Lotus Notes

  It is used to draw a planning of room reservations for a defined day.  Continue Reading

• File upload validation for file type with JavaScript

  It is essential for security and very helpful for ensuring that files are of the correct format.  Continue Reading

• Peer-to-Peer

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

• Input validation for file attachments using JavaScript

  A solution is to validate the value of the HTML input element instead.  Continue Reading

• Document has not been saved yet

  Notes sometimes will prompt a dialog box saying that the document is not saved yet.  Continue Reading

• Writing more than 64k data to a single document

  Domino only allows for writing 64k of data to standard fields.  Continue Reading

• Calculate the number of working days between two dates

  There are times when you require to work out the number of working days between two given dates.  Continue Reading

• Make the hidden design visible

  From time to time, you may receive a copy of a Domino database with hidden design elements.  Continue Reading

• Migrating your (Notes) browser address book into Notes

  Notes mail people using a browser to get their mail but then later decide they want the robust features of the Notes client.  Continue Reading

• Rollover buttons and @formulas

  Here's how to have rollover buttons with @formula behind!  Continue Reading

• Activate a button using the ENTER key in any field

  Enter key always activate a button wich performs some actions.  Continue Reading

• Display Profile Documents in a view

  The "getProfileDocuments" agent creates a stub document for every profile document in a database.  Continue Reading

• Scanning Domino for security holes

  This month's tip focuses on security scanners for Domino Web sites.  Continue Reading

• Give a user editor access instead of Manager access to a database

  How to maintain the Access Control list.  Continue Reading

• Scheduled compact of open databases

  Here is the ability to schedule/automate the compact of open databases like names.nsf. log.nsf and statrep.nsf.  Continue Reading

• Printing a list of LotusScript error codes

  I created my own LotusScript agent to generate this list.  Continue Reading

• How to display a Rich Text Field from existing Notes document on the new Web Form

  Wouldn't it sometimes be nice to publish some rich text from Notes databases on another Web page?  Continue Reading

• Lotus Certification

  Certification may not be everything to everyone but it can be a good skills gauge and a resume booster.  Continue Reading

• Open/extract zip files from Notes client

  Many users believe that they have to have separate software to open zip files that are attached to emails.  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

• Elapsed Time

  Here is a simple formula that will calculate the time elapsed over several days.  Continue Reading

• Multi-line text fields on the web

  Quite often there's a need for multi-line text fields in native Notes.  Continue Reading

• Linking to Notes from Word Document

  Ever want to link to a Lotus Notes database from within a Word document? Works with views and documents, too.  Continue Reading

• @Adjust in LotusScript

  This function adjusts the specified time-date value by the number of years, months, days, hours, minutes, and/or seconds.  Continue Reading

• Avoid hard coding a database path

  The example below illustrates the technique of how to avoid hard coding a database path.  Continue Reading

• Appending embedded attachments in a document into a richtext field

  Appending embedded attachments in a document into a richtext field  Continue Reading

• Refer to a value in a view column from another view column

  Create a view column that takes advantage of the calculations already done in other view columns.  Continue Reading