Lotus Formula language coding primer

Lotus Formula language coding primer

    Requires Free Membership to View

    Register today to access targeted resources from our editorial writers and independent industry experts focused on Lotus Domino, Notes, Workplace and other related technologies.

    By submitting your registration information to SearchDomino.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchDomino.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

More Lotus Notes and Domino Formula language resources:
Have a question about Formula language? Consult our Domino development expert!

For more resources, check out our Formula Language Reference Center.

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

An 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.

Formula language FAQs
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.

Formula 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.

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

Making 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.

Formula 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.

How 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.

Formula 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.

Formula 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.

Formula 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