Formula language is a simple scripting language for Lotus Notes Domino that is often referred to as @Formula, because so many of its elements begin with the @ character. Several tasks can be accomplished by using Formula language -- from retrieving lists of values in a Lotus Notes database or processing documents to opening a database or starting an agent. Whatever you want to learn in Formula language, these tips, tutorials and resources will help you code it.
FORMULA LANGUAGE TUTORIALS AND RESOURCES--------------------------------------
introduction to Formula language for Lotus Notes -- 7 tips in 7 minutes
From working with Formula keywords to using Formula operators, functions and commands, learn everything you need to know to start scripting with Formula language in Lotus Notes.
Is Formula language frustrating you? If so, check out this list of frequently asked Formula language questions. From building a single computed subform with Formula to using Formula to create a back button to changing your organization's name with Formula language, we should have all of your bases covered with any inquiries you may have.
Language Learning Guide
This SearchDomino.com guide introduces you to Formula language, explains best practices and pitfalls to avoid and provides troubleshooting help and advice. You'll find Formula language articles, tutorials, tips, tools, white papers, expert advice and more to pump up your Formula language know-how quickly.
Language Reference Center
With over 100 postings, the Formula Language Reference Center is the mother lode of Formula technical tips and code samples for Lotus Notes and Domino developers.
FORMULA LANGUAGE TIPS--------------------------------------------------------------------
your Formula lookups more readable and maintainable
Instead of performing multiple lookups with Formula language, you're better off doing one lookup, getting a summarized value from a document, and then parsing out the information to different fields on the form.
language code to modify 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 by SearchDomino.com member Blessan Philip to change selected item values.
to create a forgiving Notes/Domino date parser with Formula language
Here's a Formula language Notes/Domino date parser, from SearchDomino.com member Mick Crowder, that will graciously accept differently formatted date entries.
code for alphanumeric validation
This is simple Formula code from SearchDomino.com member Vijay Sreegiriraju will validate and allow a field value to have only alphanumeric characters -- both letters and numbers are mandatory. All you need to do is paste the code in the field's input validation.
language for a simpler pagination view for Lotus Notes documents
If you're frustrated by clicking through endless "Next" buttons to reach a buried Lotus Notes document, you can learn how to create a simpler pagination view for Lotus Notes documents on the Web with Formula language.
language to easily implement attachment fields in a Web form
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.
This was first published in July 2007