Manage Lotus Notes Domino Formula Language Technology

Open a specific frameset of a database in Lotus Notes

Get the steps necessary for a workaround to open a specific framset of a database in Lotus Notes. Continue Reading

Provide rich-text formatting via the Profile document and Formula

This tip explains a method for providing content to a separate Lotus Notes form while allowing rich-text formatting using the Profile document. Not only will Lotus Notes users be able to edit the form, but using this Formula language code will also ... Continue Reading

Top 10 Formula language tips

We've done the research to present you with our top 10 Formula language tips for Lotus Notes Domino. Discover how to use Formula language code to modify Notes document item values, generate formatted sequence numbers, cull elements from a list and ... Continue Reading

Using Formula language code to sort Lotus Notes messages by subject

Lotus Notes will sort messages by Date, Sender and Subject with prefixes such as Re: and Fwd:. This Formula language code will customize your All documents view by stripping out prefixes to easily sort Lotus Notes messages by subject alone. Continue Reading

How to create dynamic JavaScript in Notes Domino without formulas

If you need to create a large amount of dynamic JavaScript and you're not familiar with the use of @DBColumn and @DBLookup formulas, this tip is for you. Placing this code in your HTML Head Content section is a simple workaround for busy Lotus Notes... Continue Reading

Formula language button manages Deny Access list searches

Get details on how to create a button using Formula language code to search Deny Access lists from the toolbar of a Lotus Notes administrator client.Continue Reading

Add a program doc to compact Lotus Notes databases automatically

Learn the steps to add a program doc to Lotus Notes users' local public address books to compact large Lotus Notes databases automatically without closing the client.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

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

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

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

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

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

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

Universal @Formula for converting list synonyms

Have you ever needed to use a list description and its synonym in different views? This universal @Formula script from SearchDomino.com member John Humphreys allows you to set a field with the description value of a list for later use.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

Formula to list users added to groups view in Lotus Notes Personal Address Book

SearchDomino.com member Gaurav Prabhakar provides a Formula script that lists users added to groups view in the Lotus Notes Personal Address Book. This 'people by groups' view data is particularly helpful to administrators of large organizations ...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

Creating a marquee effect in a Lotus Notes client

The marquee effect tags in Internet Explorer and Mozilla can also be used in Lotus Notes client welcome forms. SearchDomino.com member Sunilkumar Vishwakarma provides step-by-step instructions and code in this tip.Continue Reading

How to add an audit trail to Lotus Notes documents using Formula

In many Notes/Domino applications, you need to track critical field values any time a document is modified and saved. In this tip, SearchDomino.com member Mohammed Misbahuddin explains step-by-step how you can easily add audit trails using Formula ...Continue Reading

Modifying document item values

This Formula Language code can be incorporated into a toolbar button for Lotus Notes client 6.5. When a database document is selected and the button is clicked, all item values will be displayed in a pop-up. You can then follow these steps provided ...Continue Reading

Converting a date to a week number and vice versa

SearchDomino.com member Klavs Thor Olesan explains how to convert a date to a week number and vice versa using Formula Language.Continue Reading

Reusable revision history log

This is a quick and easy-to-use code snippet that is very handy when you need to build a Revision History control in your application.Continue Reading

Formula code for alphanumeric validation

This tip offers simple Formula code to validate and allow a field value to have only alphanumeric characters.Continue Reading

Simplifying dialog list maintenance

This Formula Language tip shows how to add a new entry to a dialog list via only one form and one view.Continue Reading

Computed subform based on user's action

If a computed subform formula is based on a field and the user changes that field's value, the subform does not refresh. This quick tip changes that.Continue Reading

@Transform formula for use in R6

These are a couple of formulas that this developer finds more effective than their LotusScript counterparts.Continue Reading

Fix for modified Form field value is ignored when document is submitted from the Web

By changing the value in the Form field, you can determine through which form a document displays. But if the document is created on the Web, the value in the field is ignored.Continue Reading

A new, better pad technique

Let's say you want to pad a number with leading zeroes, no matter how large it is. This shows you how to pad a number if it's less then x but leave it alone if it's greater than x.Continue Reading

Expand group members and nested groups in @formula

In R6, @expandgrouplist doesn't seem to work anymore. This @formula will get all members of groups, and it will also work for nested groups.Continue Reading

Pull a specific element from a list

If you are given a list of items, do you know how to pull out the 1st, 2nd, 3rd, 4th, etc. elements? This tip shows you how.Continue Reading

Prevent users from saving multiple documents with same key data

This tip shows you how to prevent users from saving more than one document with the same key data.Continue Reading

@Formula library

Writing a function once and then using it in many places is easy to do when you use LotusScript -- but what about @formula's? In Notes 6 you can do this for @formula's as well.Continue Reading

Creating RSS feed with Notes URI

Many Lotus Notes developers have started adding RSS feeds to their repertoire. Using this method, you can present an RSS feed to documents stored in a Notes database.Continue Reading

Link hotspots vs. action hotspots

I wanted to create a link from a page to an Excel spreadsheet in a shared server.Continue Reading

Alternate approach to simulating @Unique in Java

This tip is in response to Mike Marcavage's tip Java version of @Unique. It is an alternate approach to simulating @Unique in Java.Continue Reading

@today in view selection formulas

By now you all must know that using @Yesterday, @today ,@tommorrow in column or selection formulas impacts the efficiency of your application.Continue Reading

Java version of @Unique

This is a static method of the Lotus formula @Unique.Continue Reading

Convert number value to text string (R5 and earlier)

This code will convert a number value to a text string.Continue Reading

@Unique and @Elements for LotusScript

The @Unique function in formula is a handy way of removing duplicates. This LotusScript function allows you perform the same function in LotusScript.Continue Reading

JavaScript version of @DBLookup and @DBColumn

The objective of this tip is to avoid page refreshes while looking up data from the browser.Continue Reading

Dialog list and combo box size limitations

If your data comes from Domino you can overcome size limitations for the dialog list or the combo box.Continue Reading

Document unique ID from lookup

In R6, it's easy to retrieve the document unique ID from a view. @DbLookup has an extra keyword that will return the lookup document unique ID.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

Test your formulas

Need to test your formula quickly? Here is a quick keyboard trick that does it in a jiff.Continue Reading

Open a database to a specific frameset

Learn how to use formulas to open a database to a specified frameset by setting an environment variable and using computed frames.Continue Reading

Developer tool: Read/set document fields from view

This handy tip makes testing and debugging applications easier by letting you reassign a field without editing the document.Continue Reading

An easier way to use Validate

Ever have to use Validate to ensure that all fields in a form are filled in before it can be submitted? Here's an easy way to do it.Continue Reading

Let users filter any view

Here's a great little Action (or Agent) that lets a user filter any categorized view based on whichever category they choose.Continue Reading

@Word in Java

This is a simple class that emulates the @Word function in Lotus Notes.Continue Reading

@Word in LotusScript

This function in LotusScript is equivalent to @Word function.Continue Reading

Delete current viewing document over the Web

This tip explains to use @Formulas and @Commands instead of LotusScript to delete a current document on the Web.Continue Reading

Creating sequence numbers

How to create numbers in sequence in a workflow application.Continue Reading

Treating multiple fields with the same name

This tip describes how to access multiple instances of the same item individually.Continue Reading

Run agent from a Web page

This tip provides one way to run an agent from a Web page and access field values from the backend doc behind every page.Continue Reading

Counting unique elements in a text list

This tip's formula will count the number of elements that are the same in a text list.Continue Reading

Parse query from URL

This tip describes how to parse a query string from the URL in a form using a CGI server variable.Continue Reading

Looping through @Implode and @Explode

Learn how to perform multiple lookups in one shot.Continue Reading

Year and quarter -- the Formula language way

How to show when a doc was created in the format Year, Qx -- using formula.Continue Reading

Warning on trimming strings with @Trim and Trim

A warning about trimming functions in LotusScript and Formula.Continue Reading

Smart icon to set field value/type, version 2

Version one of this tip, "Set field value/type via smart icon" by Janet Rogers, was submitted on Sept. 4, 2001.Continue Reading

Specific day of the month

If you've ever had to determine a specific day of the month, for example the third Tuesday or the first Thursday, then this formula can help you out.Continue Reading

Reorder CommonName of User Name

This tip describes how to reorder CommonName of User Name.Continue Reading

Simple method to put LastName first and FirstName last from CommonUserName

This tip describes a procedure to put LastName first and FirstName last from CommonUserName.Continue Reading

Easy viewing of hidden fields

This tip describes a method for viewing hidden fields.Continue Reading

Managing attachments on Web browser

This tip describes a procedure for managing attachments in a Web browser.Continue Reading

Nth position of a list

This tip describes how to get to a specific list item.Continue Reading

Toggle debug LotusScript

This tip describes how to toggle LotusScript debug.Continue Reading

admin4.nsf replication settings

This tip describes how to configure admin4.nsf replication settings.Continue Reading

One URL for all Webmail

This tip describes how to access Webmail from a single URL.Continue Reading

Change field values without creating an agent

This tip describes a method for changing field values without creating an agent.Continue Reading

@Userroles and multiple userroles

This tip descrbes a method for handling userroles.Continue Reading

Spacing columns in the client

This tip describes how to space columns in the client.Continue Reading

Modify hidden or internal fields without writing an agent

This tip describes how to modify hidden or internal fields without writing an agent.Continue Reading

Embedded views must be sorted on a text field

This tip describes how to avoid an error message associated with embedded views.Continue Reading

Option to send return receipt

This tip describes how to send a return receipt.Continue Reading

Forcing a line break in a view

This tip describes how to force a line break in a view using Formula language.Continue Reading

Using @PickList with LotusScript agents

This tip describes using @PickList with LotusScript agents.Continue Reading

Remote_User & SSO login

This tip describes remote_User & SSO login.Continue Reading

Response only columns in views

This tip describes how to create response only columns in views.Continue Reading

Mark calendar entries red and strikethrough

This tip describes how to mark calender entries.Continue Reading

FTSearch, display matching items

This tip describes the procedure for mathing items using FTSearch.Continue Reading

64k-limit error when sending mail to a group containing a large number of members

This tip describes setting up a 64k-limit error when sending mail to a group containing a large number of members.Continue Reading

Solution for DbColumn 64k limit on the Web

DbColumn is very useful and is frequently used in Domino applications. But what if the limit exceeds 64 KB?Continue Reading

Quick import-export smart icons

My users often need to send a "snapshot" from a view via e-mail.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

Formula Functions

LotusScript functionsContinue Reading

How to keep freetime lookups current in large environments

Using Hide When formulas in forms

Sending and receiving mail from many different Internet domain names