This updates the back-end table object as well as the front-end html table. This is only needed when content is updated after the initial table has been drawn and you're using the Datatables native PDF, XLS, CSV exports.

https://tamble.github.io/jquery-ui-daterangepicker/#

There are a number of reasons why the CSS position: sticky property might not work such as browser compatibility, ancestor element has OVERFLOW property set, height is not set on parent element, or parent element is a flexbox.

Use this agent code to break up the attachments into their own notes documents.

1st, 2nd, 3rd, 4th, etc...

The iPhone and iPad automatically adds hyperlinks to things it thinks it knows how to handle, like linking dates to the Calendar app and phone numbers to the dialer. (Several desktop email and webmail systems do this too, especially for dates.)

You can prevent the form from submitting, but still specify functions to execute when a user hits ENTER within a specific field or object.

The popstate event will be triggered by doing a browser action such as a click on the back or forward button (or calling history.back() or history.forward() in JavaScript).

Use this when you need to determine the web-friendly URL for the current database directly.

1. Use prependTo() to insert the thead element
2. Use append() to insert the first tr inside the thead

I also had this problem with the latest Bootstrap v4.1.1. As a workaround, adding this css rule after Bootstrap js/css loaded.

This tip shows you how to set the date without the time section via LotusScript. Most methods for setting a date field via LotusScript leave you with a date in this format: 13/07/2014 00:00:00 GDT The time section always seems to get set either to the current time or 00:00:00. If the date is required to be stored in the same format as it would be if chosen from the date picker on a form, the time part must be removed.
The LotusScript functions, CDat, DateNumber, DateValue, Format are no help here, nor is the notesddatetime object -- unless you do what I have done below.

Use the formula below in your Lotus Formula agent to convert values for specific fields.

Features of Bootstrap that break:
- Collapsible components bounce disruptively due to Effects.
- Drop down menus parent disappears upon closing child.
- Tooltip trigger/parent disappear on blur.
- Popover trigger/parent disappears on blur or toggle.
- Tabs disappear on trigger and toggle.
With most of these issues, the cause is that Prototype.js applies display:none; to the parent element, making it disappear.

Issue when the table header columns are not fully aligned with the table body columns using datatables.net
This can occur when the table is located within a modal window. Use either the CSS or JQuery methods below.

Format the output of @AttachmentLengths into a more useful result.

If you have a workbook contains multiple protected worksheets with the same password, and now you need to unprotect them for modifying some information. Maybe, you can unprotect the sheets one by one with Unprotect Sheet in Excel, but this will waste a lot of time when there are multiple sheets need to be unprotected. Here, I will introduce you some quick ways to unprotect multiple protected sheets.

When you display content based on the presence of a URL query string value. For example
"http://website.com/page.html&smsg=You saved successfully"
will display the message, fade out after X seconds (2.5 seconds below) and then remove the query string from the address bar to display just this
"http://website.com/page.html"

This little snippet won't display the email address unless javascript is enabled in the browser, which web-bots do not run. The fully formatted email address won't be present in the html file, just in the browser ram.

As soon as you apply the .table-responsive class to a table, the table shrinks horizontally and no longer takes up 100% of the width.

Just a convenient multi-colored block to assist while performing your layouts.

Modal boxes are a frequently utilized tool in the web developer’s arsenal. Used for, amongst many things, login/register forms; advertisements; or just notifications to the user.
However despite the fact that modal windows frequently contain mission critical information, they are routinely created with JavaScript, which does not sit well with the best-practices of progressive enhancement or graceful degration.
This doesn’t need to be a problem, because HTML5 & CSS3 allow us to create modal windows with ease.
What we are going to do is use CSS3’s transition, opacity, pointer-event, and background gradient properties to create a very beautiful and functional modal box.

Unfortunately, you cannot place multiple onload events on a single page. You can nest multiple functions within the one onload call, but what if you need to cascade an onload script across multiple pages, some which may already have an existing onload event? use the addLoadEvent function below.

This formula will help you calculate the hours difference between two times, even when the end time crosses midnight (Ex 7pm - 2am)

@Unique is case-sensitive, so "pear" and "Pear" and "PEAR" in a list will remain as three separate values. The formula below will truly return one value "Pear".

Have you found that your database's full-text index doesn't update immediately when you save a document, even when the frequency setting is set to "IMMEDIATE"?
The UPDATE function on the server checks the queue every 5 seconds for new task requests, however it uses the "Update Suppression Time" setting to wait until multiple, similar requests get deposited in the queue before it runs. This can take up to 15 minutes to execute.
Decreasing the suppression time interval on the server isn't a good solution since it will exponentially increase the load on the server's resources. And it still doesn't solve your problem because even a minute delay could frustrate a web user when their new document doesn't show up in search. So instead, the solution below will fire off the UPDALL routine directly in the server console for the specific database.

There are several reserved fields available.

In the event that a disk has become stuck in your Apple computer, there are several steps you can take to try to force it to eject.

Simple, clean effect that works everywhere.

Use this handy LotusScript function to convert a string from ISO-8859-1 to UFT-8.

You can perform specific word/sentence lookups against Google Translate via the AJAX the function below.

You can override the i18n 639-1 locale code so you can test your international apps.

This problem was caused by a conflict in Dropbox’s cache. Because a file with the same basic name and properties already existed, Dropbox wasn’t able to create the new file on our end. This isn’t always a problem, but it can be if the sun and moon are aligned in a certain way.
Either way, you can solve these issues almost every time by clearing Dropbox’s hidden cache folder. This folder holds gigabytes of miscellaneous data collected during file downloads and sync processes in a series of smaller files with crazy alphanumeric names. This folder should reset itself every three days, though in cases where your Dropbox application is experiencing a conflict, you may not want to wait for the problem to resolve itself.

How to reveal secret hidden files on the Mac OS X desktop: this Mac Finder trick displays hidden files and folders.

You want to use the percent to control the width of td. In each td there is a div which has a 100% width relative to parent element td. If so, the overflow:hidden of div will no effective.

JavaScript contains a handy built-in function, 'escape', that encodes text so that it can appear as part of a URL. For instance, the space character is changed to %20, ampersand to %3B, and so on. The 'unescape' function converts these "percent" codes back to their original representation.
These are helpful functions to have available when you write Domino agents. These agents could use unescape to read arguments from their own URLs, and use escape when they need to print a new URL when they finish execution.

Converts 24-hour time to 12-hour time with an AM or PM designation.

This is a helpful agent when you have a minor memory leak that you can't isolate in your system. Over time, the JVM will eventually fill up and cause an Out-Of-Memory failure and you won't be able to perform any Java remote calls until you reset/restart the JVM to clear the memory. One method to do this is to reboot the entire Domino and/or Windows server, but this takes a lot of time and can't be called via LotusScript. The agent below will check the server log every five minutes and if it finds an out-of-memory error, it sends the "restart task http" command which will restart the entire JVM and notify you via email. This typically takes around 20 seconds to complete, so it's much more efficient that restarting the server.

Domino automatically creates a label for every value in a checkbox or radio button field. You can use this solution on a per form or server level to disable the automatic functionality.

Simple css to dynamically hide the first column in a table that's a child of another object.

Simple way to detect orientation changes and positions.

The code example below was used on a default Domino calendar view template form. It removes the HREF values for the automatically generated links for each day (which annoyingly opens to a dual day view). Just call the function below in the onLoad event. Domino adds a target="_self" to all these links, so you can filter by them.

The java.lang.Double.compareTo() method compares two Double objects numerically. There are two ways in which comparisons performed by this method differ from those performed by the Java language numerical comparison operators (, =, ==, = ) when applied to primitive double values:

Use this when the choices for both field will be the same and you want to have a function that swaps them.

A simple layover popup with all inline styling, no external css.

The R5+ Frameset InfoBox does not contain an HTML Header object for use by the developer - meaning you can't easily include META tags, if you are using a Domino Frameset as your Home Page. Here's a way around it.

This column formula will group the entries into the correct number of weeks. Weeks start with Sunday and it also accounts for the overlap of days at New Year's.

For when you always want to display the full list in edit and read mode. It will show which values are checked.

Use this simple fix is to overcome the bug which prevents you from deselecting the "allow selection of documents" option in a notes view properties.

Use this to randomly pick a single value from a @DBLookup, @DBColumn, or any other list array.

Use this package to create a modal-like popup layer to show text messages or images on the current window. You can customize any of the aesthetics via css and the content window will stretch vertically and horizontally based on the content. Good to avoid popup blockers and keep the user on the same page.

This is code provided by DynamicDrive.com and customized for a custom Lotus Domino implementation. I'm providing the code for my implementation along with the original files and a PDF with the original instructions.

Lets you upload whatever dimension image you want and ensure that it can/will be displayed at a fixed max size limit, regardless of browser, and still maintain the aspect ratio. Some tweaks had to be made from the original documentation regarding IE8 and above. The code below works :)

Works well to encode and decode from @URLencode. Escape characters.

Simple countdown timer in minutes and seconds. 00:00

Use "visibility:hidden" instead of "display:none" since IE can't determine an image size when hidden.

Applies to Safari and Chrome, hopefully IE too one day ;-)

Allows you to trigger an evert when the browser window is resized and use the returned height and width to adjust other objects on the page. For example, you can use it to resize a div box on the page that you always want to be 30px less on each side of the window. Using width =100% and margin doesn't always display consistently across different browsers and edge borders skew the margins. This solution works regardless of margins, padding, and content.
Will work for most browsers (IE, Firefox, Sarari, Chrome, etc...)

Tired of the no-frills way Domino displays attachments on the web for your users? This solution will allow you to choose where and how they're displayed, complete with the appropriate icons. It's setup for an individual deletion button for each file, but could be easily adapted to use checkboxes and allow multiple file deletions. I just prefer single click over the checkboxes and save buttons. I've attached a library of 100+ file type icons in various sizes and a database example. This package is comprised of 8 steps. All the elements above should be hidden in read-mode, except for step 5 which should only be hidden when @Attachments=0.

This is an example of our current GigaChef newsletter. This agent is used for testing and pulls the content and imagery from the document. Both the HTML version and Plain text version are contained within the single email. Emails clients with HTML enabled will automatically display that version, otherwise the plain text version is displayed.

Works in Internet Explorer, Firefox, Sarari, and Chrome.

Simple code to open a specific server and list all the visible databases.

A down and dirty easy version which returns the value of the key passed

Simple approach using a replacesubstring function

This is a basic template for a java agent. It can be called directly from a button or from a URL. It can return variables for AJAX calls or redirect the browser to another URL.

Simple conversion formula

Control the cellspacing and cellpadding with CSS (works in IE too!)

Simple equivalents to these Lotus Notes formulas

Includes whole numbers or numbers with decimals

The following code will output the date in the form of "Sunday, November 27th, 2005":

Retrieve the current webusername from an agent called via OpenAgent and "use current web user"

The java agent code allows you to find a document by UNID and change it to another value. Once run, it will create a new document with that ID. Them you can delete the original.

This is a simple MP3 player that can be embedded into any HTML and play a referenced MP3 file. You just need to upload the attached swf file to the "FILES" design element section and insert your formula/HTML.

The example below is used to inject html bold, italic and hyperlink tags around the highlighted text in a field.

This simple agent stamps two reader fields on every selected document with a static role value.

This is the basic package of code you need to perform an AJAX lookup for single or multiple values.

Drop down menus will not work correctly in IE6 without calling the following function.

How to disable autocomplete on a field

This is a hybrid between my legacy code and ViewProcessor code from Jake Howlett (Codestore.net 2003). The problem with the legacy code was that $$ViewTemplates don't execute WebQuerySave agents. Attached sample database - Used for the INBOX view template to change the status to "unread" or "saved"

Simple mouse event code to change the color when the user places the mouse over the div.

Better lightweight code to toggle the status.

Simple code to change the default message.

Simple @For loop to add placeholder text

A similar situation arises when trying to programmatically replace the design of a Lotus Notes database. IBM doesn't provide a LotusScript method or C-API function to accomplish this task. In fact, the only way to replace a database design is by manually choosing File - Database - Design Replace for each specific database. However, this manual method doesn't make much sense when replacing the design of several databases. The following LotusScript code can be used to replace the design of multiple databases. The script actually deletes all design notes from the target database and copies them from the source database.

Use this automatic code to display all sibling links on a document

A generic LotusScript function to mimic @ReplaceSubstring is described. This is a JavaScript version of that function. It handles several situations. For example:

Use the CSS to automatically ensure that a DIV appears at the bottom of a page.

This code is basic, but works well.

A reverse redirection to prevent HTTPS session.

This tutorial teaches you how to use JavaScript to set an inactivity timer and close a browser window. Provides a warning message using a hidden DIV.

Insert the code below in the onLoad event of the form to automatically hide the last row. Typically used in total views to hide the grand total on the bottom.

This code prevents the user from using the backspace key to page back, but still allows it within text and textbox fields

The formula below translates each value in the "website" field to insert the "http://" prefix if needed. It uses the new @Transform which applies a formula to each value.

the name says it all

Here's a simple countdown timer for the screen using a DIV instead of HTML field

Insert the code in your HTML when generating Microsoft Word documents and Adobe Acrobat PDF files.

Maybe you'd like a page break at a specific point to keep a particular look. You do that by setting up a class of page breaks. You can set up the class on any HTML command, but I think the best method is to set up the class within paragraph tags. That way there's some white space where the page can break. Here's a look at the format (this will sit between your HEAD tags):

Use this code when creating Word documents via HTML from LotusScript. It allows you to pass variables to the Word translation code upon first opening.

This code will allow you to scroll the page in javascript to the current selected object

This is a way to pass a single variable to an agent. Simple modifications can be made to the loop for multiple values.

Insert the code below in the form's onkeypress event

Creates an ascending array of years ending with this year. (2004, 2005, 2006, 2007, etc...)

Basic auto-suggest functionality using only javascript

Auto Suggest with Javascript (#2) from www.go4expert.com

Use this code to add type-ahead functionality for your web text fields. You can use a computed text field to perform @DbLookups or @DbColumns to produce the source datalists. It must be set to multi-valued with a comma delimiter. Each entry field must have a unique "Id" value assigned (example "Ingredient01") The code in the Onload event sets-up each field. The JSHeader code has two sections, the static standard reusable code and the source custom section which you cater to your source computed fields.

Returns the difference in a clean text readable format. Includes both a LotusScript and formula version.

Simple code to append at the end of a function or agent to open up the generated file or other file.

This function will automatically strip out any leading and trailing spacers from a string.

Normal fields can be disabled using a single line of code. Radio button fields require you to loop thru all instances and disable each one.

This method works but has a potential risk of deleting data if the function gets interrupted. Use the property "CutOffDelete" of the class "NotesReplication". When you switch from enable to disable the cutoff date in that field will also be deleted. After that use the method save(). Important: Be sure not to use the method rep.save() when cutoffdelete is set to true! Otherwise this will result in loss of data!!!

Use the three subfunctions below to reformat any amount in a currency format, complete with commas for thousands delimiter and two decimal points. (Example: 12,345.00)

This agent will retrieve the value of the "Added In This File" property of a notes document and populate it in string field for easy reference.

Simple HTML CSS code to preload images and hide them.

Build a custom date string from today's date

Control twisty URLs in embedded views

The code below will hide all elements with the id="XYZ123"

Helpful when creating links over images without hotspots.

This code was used to manually re-associate two records. The user just selects the two records and the agent code automatically determines which one is the parent and which one is the child. Then it performs the re-association and saves.

This was used to re-associate "database access profiles" to each user's "user profile"

The code example below hides some hyperlinks based on the users operating system

To detect the operating system on the client machine, your script should analyze the navigator.appVersion string. Below is a simple example of a script that sets the variable OSName to reflect the actual client OS.

Reload every 20 minutes, forces the browser to return to Login page after server timeout

This is a sample OK/Cancel prompt for the user to proceed, which includes carriage returns ( \n ).

A date string with a day of the 15th or last day (28th, 29th, 30th, 31st) is provided and a dynamic array with 24 cycles is created starting with that date.

Use this easy code to click another button. The target button can be hidden via javascript and contain Notes formula functions.

This code works, but need to review it later for differences.

Drop this code into a view action button or agent. It will automatically create the fields based on the first row values of the XLS file. The only configurable variable that needs to be set is the desired form name for the new records. THIS ONLY DIFFERENCE IS THIS CODE FROM VERSION 1 IS THAT IT WILL STRIP OUT ANY/ALL SPACES FROM THE FIELDNAMES AUTOMATICALLY.

Drop this code into a view action button or agent. It will automatically create the fields based on the first row values of the XLS file. The only configurable variable that needs to be set is the desired form name for the new records.

This code consists of one parent function and two child sub functions.
Example 100,000.00

Javascript sometimes treats checkbox fields differently if they only have one value. It's treated as an array if multi-values exist and a standard string field if only one exists, thus the method of selecting and deselecting all must account for this. The code below checks the length of the fieldname object. A single value will return false to a length call.

Will return the full text string for a date (December 31, 2005) when passed a date string value.

The code below was placed in an agent to re-associate user responses (children) to a different data request (parent). The variables and conditions can be easily modified to suit your needs

can be used in field and form events

Same as formula function "@Date(@TextToTime(@Text(FIELDNAME)))"

This is helpful when exporting on the web to Excel and numbers have leading zeros or extremely long numerical values and truncation is not desired.

You can call this from within the field itself or from other fields

This formula will count the total weekdays between two days.

Just drop the function below and make the call as shown below. You can either replace each value with a tilde (~) or HTML hex codes.

This code will execute very efficiently on the web to retrieve collections of documents based off a date range the user specifies. It uses the DateRange class as the key for the view. The view may not be categorized, otherwise inconsistent results will be returned.

Simple formula to dynamically sort by Fiscal Year

The code below, when dropped into a LotusScript view action button, will dump the entire view contents to Microsoft Excel. This has been modified from a previous version which had a few glitches. This revised code will account for any/all hidden columns and truly export the value being displayed in the view column (fixes date issues).

Reads and rewrite the contents of a cell table. It sets the HTML contents of the cell to an array and then rewrites all the content except for the 1st and last 2 indexs of the arrays.

Reads and re-write the contents of a cell table. It removes the first X characters before re-writing.

Loops through all the options and stops when if finds the desired value, in this case, "Finland" and marks it as selected.

This code allows you to embed a second page on the existing page in a new layer on top.

The code below, when used in a view action button, will dynamically export the entire contents of the view to a text file in the C:\Temp directory. The user will be prompted for the desired filename and if they wish to include the column titles as headers. The code will retrieve the actual values displayed in the view, not the back-end fields, which is helpful when columns are combined field and text values. Also is helpful with date formats, ensure that date fields export in the format consistent with the user's local settings.

Will generate an auto countdown timer to whatever date/time you specify

The PostOpen event code below will populate the "CurrentRoles" field when the document is opened.

This functionality saves your users time from having to remove the default placeholder value each time they go to populate the field. An date field example has been provided below. MM/DD/YYYY are pre-populated in the fields and automatically disappear when the cursor moves the the field. The code example below was used on the "YYYY" field and the "this" handle allows you drop this code in any field without having to have specific field references.

Resolves the problem the Safari browser has in displaying iframes within a table. Simple insert your iframe contents inside the DIV and it will display correctly.

This code will trap if the ENTER key was pressed in both Internet Explorer and Netscape browsers

This code will move the current window to the x=0 and y=0 position on the screen

Determine the access level and deletion rights

Insert the code below into the Querydocumentdelete database script.

This is as user friendly as it gets. The core of this Date Picker code is housed in a single subform, then all you need to do is append some small html after each date field you want to use it with. You can use this multiple times on the same form.

This code simple looks at the twistie code to the left on the screen and clicks it. "Category" is the actual field value In the example below.

Using this attribute will allow the field to be visibily hidden but still accessible by javascript functions.

The code below will display the URL the user was just at before entering your page.

The code number below can be replaced with any other key number.

The code below retrieves the x & y coordinates of the current mouse position and opens the popup window there.

This code will place a dynamic and self-refreshing clock in the title of your web page

Extract all the selected values of a listbox field

This function grabs the value from a passed in field. You should pass in the handle to the field, as in "document.forms0.MyField". The return value is either a string or an array, depending on the field type (a check box would return an array).

The LotusScript version of @ReplaceSubstring. The example below was used to take a Windows filepath and convert it to a URL filepath.

Attach a file to a Notes document via LotusScript

Use the syntax below to open any Notes database in the Notes client from a trigger within a web page.

This was required after a strange error began occuring where all cells after the 42nd row would begin being formatted as text, regardless of the formatting you specify and number value. Inserting the =Sum formula seemed to resolve the problem and the totals work correctly.

Insert this code in the input translation of a field to remove and replace the carriage returns.

The agent below extracts the current active web page data to excel. There's a subfunction inserted in the code below to parse out a long comments field to 130 characters per line over multiple varying lines to maintain the table on one page.

Custom coding examples from Primeapple for forcing page-breaks.

The code below was used on the web to populate a rich text field on the current session document with rich text contained in another back-end template document.

The codes below will translate a timestamp so it can be used in a Windows filename. Removing characters such as spaces, colons, and dashs ( :/). A LotusScript version has also been added below.

Create a hotspot button, formula, javascript, etc... and assign it a ID value (i.e. "ContinueBtn"). Then add the code below to the onKeyPress form event to trap the keystroke.

The code below inserted into the onChange event will prevent users from selecting unacceptable combinations.

Use this simple code to force the browser to the previous page in history. Substitute -1 with -2, -3, etc as desired.

Insert the code portions below in JSHeader and onLoad events of a $$SearchTemplateDefault form in your Lotus Notes database.

Contains the complete listing of IBM Code Page 850 characters typically used with @Char function in Notes.

Forces the cell style to be "Text" ideal for EmployeeID's and SSN's that contain leading zeros.

By default, a Notes form will auto-submit on the web if there is only one editable/visible field. To disable this function, create another editable field and insert the code below into the properties window.

The meta tags below will force the browser to not cache the page and always reload from server. This is very helpful for pages with embedded views when the content is changing during the users session.

There are different ways to retrieve values from each of these field types.

This code will automatically open a popup window in the center of the user's screen, regarless of the resolution.

This will force the page to close itself if the user click on any other open window.

Insert this code on your form to force the window/page to close when the ESC key is pressed.

Create a new view and insert the code below as the view selection.

Insert the code into the onBlur event of a field to prompt the user to populate the field if it is blank and they attempt to exit the field with the mouse or tab button

This is an informative error handler that is ideal for both Notes clients and Web clients. Provides line#, error# and error description.

Use the HTML below to covert all scrollbars to a specific color and fill as shown in the example provided below.

Get current day month year from users browser

Insert the HTML Style code below at the top of the page and then insert either dontprint or printonly in the class property of the design element.

R6 has trouble getting a handle on the currentdocument from the NotesUIWorkspace. The example below was is a dialog box that was called from an agent. The solution was to use the source handle on the notesuidocument rather than retrieve it from the uiworkspace

Ideal code to add the the for OnLoad event

Set the KeyField below to the field containing the target month.

Display negative excel exported values in parenthesis and in red

Use these tags when exporting to excel via the web. The full Microsoft Word documentation with screen-shots has been attached below.

Insert the code below in the onLoad event and the page will refresh itself out until it is no longer contained in a frame.

Use this code when you only want a subset of the documents to have checkboxes available in a web view. The view property "Allow selection of documents" will display checkboxes for all documents. You can nest the code below in an if statement that checks for different form types or other flag fields.

Provide the user with a file selection prompt and set the specified file path to the field "filename".

Use the code to apply your own attributes to a document link in a view, such as target, class, style, etc...

Place the code in frameA to print frameb

Insert the code below when you want to select all documents in a embedded web view that has the "Allow Selection of Documents" option enabled. Check the boolean value from true to false for a Deselect All button.

The steps below outline how to process the selected documents of a view. Normally, the selected documents option is used for deletion of documents
where a simple action button with the formulas @Command(MoveToTrash) & @Command(EmptyTrash) will do the trick, but allowing the user to perform much more complex functions on the selected documents requires much more. Embedded views in Domino create a (on-the-fly) multi-valued field called $$SelectDoc, which contains all the DocumentUniqueID's of the selected documents. However, the values of this field are only transferred to a physical notes field when the document is saved by using a javascript submit button. Using @Command(FileSave) will not populate the values.

Insert the code shown below in the onKeyPress event of the form.

The code below will loop thru all the selected documents in a web view (embedded or standard).
(1) Verifies than documents have actually been selected and prompts the user if none have been.
(2) Prompts the user with an OK/Cancel window if the wish to proceed.
(3) Loops thru the collection and only processes unique documents (helpful if you have the same document shown multiple times when showing multiple values as seperate entries).
(4) For each unique document, the code launches an agent in the "AFrame" frame and passes the selected documents UNID variable via the URL.
(5) The code will shortly pause after each call to the agent to allow process time.
(6) Finally, the code refreshes the agent frame to blank and reloads itself.

Can be used in place of Yes/No prompt.

Use the code below to call the users Print dialog box in the broswer for the selected page

The code below was used in a looping process to delay between each action.

The code was used in a popup window to refresh the parent when then popup was unloaded.

This code is used in the onLoad event of a popup window once a choice has been selected. The code automatically forces the parent window (frame) to refresh and closes itself.

Forces the user to satisfy the requirements of the popup window. (note: OnBlur events may only work on some browsers)

Use the values below in the HTML Attibutes event for a field to limit it's physical size and maximum number of characters.

The code below will remove the value of the username variable from the Members field in the group document in the nab.

This code will strip out all the specified characters from a single or multi-value field, while preserving the multiple values. Just enter the code below into your field InputTranslation event.

Use of @ReplaceSubstring to make filepaths acceptable for URL paths

The buttons below will add the groups from one field and assign each group the corresponding role from the role field. The index of each group and role must match for proper entry.

The example below returns "Wednesday February 26, 2003"

The code below was used to pass the child's parent document ID to the agent. The agent used the UNID to get a handle on the parent document and extract the attachment.

Normally, files such as PDF's and XLS will open directly in the browser without prompting the user. The agent below will force the browser to provide the open/save dialog box when downloading files from the web.

The example below was used in Global Data Collect. It performs four steps:
(1) Sets the flag fields and download date
(2) Saves/posts the document which refreshes in the browser to show the new status
(3) OnSubmit checks which button was pressed and sends a URL to the browser (after the refresh) to download the file.
(4) The background agent extracts the UNID from the URL string, gets a handle on the parent document, sends a print statement to the browser to force the open/save dialog box (otherwise PDFs would open in browser automatically), and finally sends the file URL to the browser to kick off the download.

The example below uses a global variable to track which web button the user clicked. In the example below, the agent referenced is only launched when the user clicks the "Download" button. This is required since both buttons perform a @Command(FileSave) command. The major point of this is that you can save and refresh the document by using formula and still have a background agent product output which is normally not possible. FYI - The url passes a variable to the agent from this form for the parent document. This code was used in the Global Data Collect database.

This code is useful for PDF's, Word doc's, etc... when the browser automatically opens the document. Inserting the two lines of code below will force the browser to prompt the user with the Open/Save/Cancel dialog box.

Use the code below to custom format a the weekday, full text month, day and year.

Use the LotusScript or Formula to open the desired view selected by the user. The database has a graphic navigator in a dual frameset, where the data resides in the "RightPane" named frame.

The code below will display the user's Print window when the page loads.

The code example below resorts and filters out duplicate entries in any dynamic array. The array you pass to it must be dynamic, not fixed.

The code was inserted on the top of a Lotus Notes form which forces all links on the page to open in a new browser window. You can replace the value with _top, _self, _parent, etc...

Categorized PickListStrings lookups will fail if you enable the "Collapse all when database if first opened" option in the view. There is no logical reason for this, but it tested true.

Inserting the code below will prevent your page from opening within another framed page. It will open (_top) for occupy the full page.

Create a computed field called "$$Return" and insert the formula below. Have a button on the document for save and close and the URL specified below will be directed to once the save has completed.

The formula below only allows the user to compose a new document if the database is on the server. The LotusScript version of the same code will exit the sub routine if the database is not on the server.

Follow the instuctions below to create a shortcut that will launch Windows Explorer in the specified directory.

The code example below calculates the time it takes to copy a set interval of documents. Then based on that interval and remaining documents left to copy it estimates how much time is remaining. Currently the interval count is set to 5% of the total number of documents (250 for 5000 docs). It performs the rounding and displays the remaining time in hours and minutes.

Use this code to loop through all the items in a document and remove the attachment(s) which matches the specified filename.

Insert the code below in the OnKeyPress event of the form to disable the ENTER key. This code will work for both IE and Netscape

Follow these steps to hide any attachments from a web user.

Note that as of 2019, Safari will prevent 1st party cookies from expiring later than 7 days.
https://alightanalytics.com/alight-insights/safari-first-party-cookies/

Use this code to maximize a frameset. The code below is inserted into the OnLoad event of the form. Replace the "parent" reference with "self" below to maximaize the form/page itself.

Determine if Lotus Notes Client or Web Browser. Use this code to prevent the JavaScript from running in the Notes client.

Use this code to show/hide the scrollbars of the browser window.

Use this code to automatically maximize any window where the code is placed. Insert the following code into the section of your html document.

The code below was used in the Resource Brio Reporting database for IBM. This code creates CSV files on the local PC writtien to C:\Temp and dumps the content of each into their own tab in the newly created Resource.xls file. The "tabs" array contains the names of the files in the folder on the local drive. Rangebounds is used to calculate the end column and row based on the total column & row counts. All the modules of the agent have been pasted below in their own sections.

This code will return the correct column title letters when you pass the total number of desiried columns. For example the last column letters for a spreadsheet containing 44 columns would be "AR". You would append the row count to those letters to get the last cell in the spreadsheet (if so desired)

Use the formulas listed below to remove the stored form from your documents.

Insert the code below to determine if the specified document is a replication/save conflict

New to R5, the example code below displays all the sounds on the local PC and prompts the user to select one to play. You can modify the "Call" line to specifically call a desiried sound in your scripts or agents.

This document shows you two ways to loop all the values of an array notesitem or doc field containing multiple values.

In the example below, the target path is being set in a dialog box.

Use this simple formula to access the Windows registry for any version. Pass to it the Key, SubKey and Valuename as shown below

This agent code loops each document in the specified view, compares the values of each doc to the next doc in the view. The view must be sorted by atleast the first value you are comparing. The example below looks for duplicate assignment documents for the same employee.

Insert the formula into an agent, change the "Rate" field to whatever field you're targeting and run on selected documents. This will modify documents with values above 1.0 and leave alone values already in the desiried format. The example below show the data conversion. Example: (38.8 to 0.388)

This code is generic and can be modified to pull from other databases or execute the selected agent, etc...
Used in a Button - AGENT LIST Selection from database

The code below will prompt the user and not allow them to edit a document if they're using a version of Lotus Notes below R5. They will be able to open the document in read-mode. You can specify a more specific version by changing the number of characters that are scanned ( 9 characters are shown below - reading left to right). Examples of version output have been listed below in red.

Prompt's the user for a month/year within the last 12 months, Returns a date value equal to the first day of the selected Month/Year. Used in the "Save and Close" button in the "SBD Report" form of the iTeam Marketing Database.

The formula and LotusScript below can be used to extract text from a RichText field.

This code will allow you to populate any field you specify with any value you specify. Create a new agent and insert this code with the agent properties set to Selected Documents.

Use this formula in an agent with selected

Use this code to find out what the current user's access is to the current database. You could use this with any database, just set the "db" to any database

Used for date/time comparisons, use portions of the code below to covert your date/time values.

Evaluate returns an Boolean array value in the example below based on the presence of the $Conflict field.

The code below will return all the docs in the specified database whose EmployeeUniqueID field matches the value specified. You can nest this code in a For Next loop and replace the EmployeeUniqueID with an array. You will need to populate Server and Path in the example below.

The example below returns the current users day & time in the following format = 03/27/2002 05:36:00 PM

Create Log Document function code

This code will sort the values of an array in alphabetical or numerical order. The test example below creates a text array of letters in random order and calls the SortArray Sub function to sort the values in ascending order

This code will sort the values of an array in alphabetical or numerical order. The test example below creates a text array of letters in random order and calls the SortArray Sub function to sort the values.

This code will sort the values of an array in alphabetical or numerical order. The test example below creates a text array of letters in random order and calls the SortArray Sub function to sort the values in descending order

The code below opens navigator "Two" if the user is a member of the specified role, otherwise navigator "One" is opened.

Use this code to dynamically build an array. It will redim the array and add one more index for input for each new entry.

The code below will allow you to get a handle on a document using multiple keys. The view must have the first value in the first column and the second value in the second column, etc...

Use this sub function to create and send emails based off the current uidocument. It automatically references the source database server and path.

The script below is used in a view action button for the selected document. It will make a new data list document and populate the Form & dl_category fields with static values. The dl_entry field will get populated with each value from the ListValues field found on the source document.

If the ComposeDocument method is used in a view action, the form formula of the view will override the form specified in the method. To avoid this problem add the following line to the form formula.

Remove all seleted docs from Inbox folder and stamp flag field

This code will create a new DLE form for each value in the specified field, for every document that is selected in the view.

The script below is used in a form action button for the current document. It will make a new DLE document and populate the Form & dl_category fields with static values. The dl_entry field will get populated with each value from the ListValues field found on the source document.

If the user clicks Cancel, picklist returns nothing, if the user clicks OK picklist is populated with a string array value. You cannot use If picklist is Nothing in this situation because it will return an error when the user clicks OK. The solution is to use the Datatype function to determine what datatype picklist is. Clicking Cancel causes the datatype to = 0 . Any other value will be covered by the Else shown below.

Returns a text string with the date specified and day of the week. ( 02/26/2002 03:45:00PM ~ Tuesday )

Use this code if you want to prevent a user from adding more than one document to a view.
(1) The code looks to the specified view for an existing document.
(2) If document is found, then prompt user to edit that document instead.
(3) If no document is found, compose a new document using the specified form.

Simple little script to delete a view from the current database

Write contents of a String Array to a text file on the local PC. You need to specify the text file and the string array

Use this code to copy documents from one database to another while maintaining their document/response relationships. The DOCID's on the parents & $REF's on the children documents will not be changed. Note: The database portion of the ID will change, but not the actual document portion. The code below was used inserted in an agent.

Use this code to detect if the current user has a local replica of the database. You can write this information to log documents or just prompt. You will need to replace the replica ID below with the ID from your database.

Function returns the server and path of the existing database. The path value is minus the filename itself which allows you to append other filenames to open other databases in the same directory.

This code collects the username from the current session and looks to the view you have created to get that user's profile document.

This code is used in the database Postopen event to lookup modify and/or create a user profile for any/all users who enter the database.
(1) Gathers the current users common name.
(2) Looks to see if an profile document exists for this person.
(3) If no, then a new doc will be created with all required info.
(4) If yes, then proceed with updating of this document with sesion information.
(5) Adds 1 to the total number of sessions for this user.
(6) Updates the last session date.
(7) Extracts the values from the SessionHistory field and repopulates it again adding in this current session while maintaining only 10 values.
(8) Saves the profile doc.

- allows users to sign-off on a document by pressing a button.
- When the user signs-off on the docuement, their name is removed from one field and transferred to another with a timestamp.
- Automatic emails are being generate to all users listed in the first field, thus once removed, the user will no longer receive emails.

The code below will take any date field format and convert it to a clean date only string. For example, the following dates will result in "01/01/2001" 01/01/2001 or 01/01/2001 7:00PM or January 1, 2001 or 2001/1/1 . You will need to dim and set the Doc1.

The LotusScript "Left" and "Right" functions can only use the numerical place-holder and not search for specific string value. The code below will allow you to mimic the functionality of the @Left and @Right commands in formula.

Returns the last day of the month

For use in a view action. -- Loops through all the selected documents in the view and sets the fields accordingly saves and refreshes the view.

For use in a view action. Prompts the user if no doc or more than one doc is selected. Also checks to see if the selected doc's form field is "Host". If all checks pass then the specified response document is created in edit mode.

Allows you to call a specific agent via LotusScript. The example below was inserted in the "Initialize" event of a view to refresh the docs.

The formula below will hide the action button if the current user is not a member of the Administrator role.

This HTML will wait 0 seconds upon entry and goto the specified URL. The entry below is used on a Domino web page, but any URL can be inserted.

This script will, upon entering, place the field value in a variable, then upon exiting place the current value in another variable. If the two values are the same no action is taken, if they are different, take action.

There's a bug with R5 which causes files to close when the DialogBox function is used. For example: A text file has been opened and is being used for data retrieval. When the BEFORE script below is evaluated, the user is prompted with the Dialogbox and then clicks OK or CANCEL. Regardless of the user's selection, the text file will be closed and the preceeding process will cause a "File Not Open" error. A solution around this is to use the new PROMPT function in R5 to replace Dialogbox. However, this new PROMPT script will not work in previous versions. So the solution is to check the version of Notes currently being used, use DIALOGBOX if R4 and PROMPT if R5 or higher.

(1)Extracts all attachments from the current uidoc.
(2)Create a new doc using the "Memo" form and insert those attachments.

(1) Collects all the selected docs in the view.
(2) Prompts user if no docs are selected.
(3) Creates a new doc using the "Memo" form
(4) Searches through every doc in the collection and copies the attachments to the memo doc.
(5) Opens the new memo doc as a uidoc.

The script below will prevent the doc from being saved on close and will not prompt the user with a save dialog box.

The formulas below trrim the values of a phone number to the U.S. Format and result in the following format xxx.xxx.xxxx Input validation will only occur if the value of the field is less than 12 and not 0.

Insert the script into the Querysave event for the form.

Insert the script below in the DB 'Querydocumentdelete' event. This will prevent any user who isn't the doc author or a member of the Admin role the ability to delete the document. There are three variable types (docauthor field, role name, formname#). You will need to identify every form title. This script will also disallow users from deleting a doc if is has existing children docs.

Insert the script for the two events listed below. This will only allow users who name appears in the "created_by" field or are a member of the Admin role to edit the document.

Two steps to prevent users from editing a doc if a field contains a specific value. (Queryopen & Querymodechange)

Insert the formula below into the Input Validation for a Date/Time field. Returns a failure prompt if the year entered has a difference of more that 200 years.

Will prompt the user if the current doc's field "Field1" value equals "value"

There is no built in function to find the amount of free, used, or total bytes on a drive using LotusScript. Listed below is a LotusScript that makes the necessary API call inserted into a button.

Use this to display the date in a YY/MM/DD format.

The object will be hidden if the current user is not in the Admin role.

This script will search a specific view and check all documents to see if a specific form type exists for each staff serial number. Output is sent to a text file on the root of the hard drive

Output is sent to a text file in the format you specify:
Value1, 2, 3, etc... are the fields (string values only) you wish to write to the file.

Refresh fields if doc is in edit mode

Counts documents in the view "viewname" in the sample.nsf database.

Copy a field's contents to the clipboard. Doc will be placed in edit mode for script to execute correctly.

Checks to see if the current doc is in edit mode. If doc is in read mode, formula switches the doc to edit mode.

This script allows you to save a newly created document and create another response type document that will inherit the data.