Tips
Tips
Lotus Notes Domino Formula Language
-
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
-
Case-insensitive @Unique version combines fields on Lotus Notes forms
The @Unique function is case sensitive, which can cause problems if you use it to combine values from different fields with differing cases. Here's another Formula language function that will work. 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
-
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 Web 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
-
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
-
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
-
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
-
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
-
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
-
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
-
@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
-
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
-
Formula debugger
There is an undocumented function that is very handy for developers. It's a "formula debugger." 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
-
Create a dynamic table row
This tip shows you how to create a dynamic table row creation with the help of formula at run time. 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
-
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
-
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 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
-
Using the open DB dialogue box to get DB paths and RepID
This tip describes how to link DBs together without hard coding the DB paths. Continue Reading
-
Treating multiple fields with the same name
This tip describes how to access multiple instances of the same item individually. 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
-
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
-
@Member in reverse
How to find the last position in a text list up to 99 elements. 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
-
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
-
Managing attachments on Web browser
This tip describes a procedure for managing attachments in a Web browser. Continue Reading
-
Easy viewing of hidden fields
This tip describes a method for viewing hidden fields. Continue Reading
-
Nth position of a list
This tip describes how to get to a specific list item. 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
-
Embedded views must be sorted on a text field
This tip describes how to avoid an error message associated with embedded views. 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
-
Mark calendar entries red and strikethrough
This tip describes how to mark calender entries. 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
-
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
-
Creating A "Users By Group" View
-
Radio Buttons with De-Select
-
Deleting Duplicate Documents
-
Sending and receiving mail from many different Internet domain names