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

   Continue Reading

• Radio Buttons with De-Select

   Continue Reading

• Deleting Duplicate Documents

   Continue Reading

• Sending and receiving mail from many different Internet domain names

   Continue Reading