A tutorial that introduces Lotus Notes/Domino developers and administrators to Formula language continues to be one of the most sought-after pieces of content on our site. To
add one more instrument to your coding toolbox, we've compiled our top 10 best Formula language tips into one handy guide. Here you'll learn how to use Formula language code to modify document item values, generate formatted sequence numbers, cull elements from a list and more. Refer to this collection of our 10 most popular tips as a source of inspiration when developing with Formula language.
TOP 10 FORMULA LANGUAGE TIPS
#1. Converting a date to a week number and vice versa
Discover how to convert a date to a week listing in Lotus Notes, and vice versa using Formula Language.
#2. How to add an audit trail to Lotus Notes documents
In many Lotus Notes/Domino applications, you need to track critical field values any time a document is modified and saved. In this tip, member Mohammed Misbahuddin explains step-by-step how you can easily add audit trails using Formula language code.
#3. Modifying Lotus Notes 6.5 document item values
This Formula Language code can be incorporated into a toolbar button for Lotus Notes 6.5. When a database document is selected and the button is clicked, all item values will be displayed in a pop-up window. Follow these steps to change selected item values.
#4. A simpler pagination view for Lotus Notes documents on the Web
Frustrated when 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.
#5. 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 with the @explode command in Formula language. Learn step-by-step how to implement this technique to set up a budget table in a Lotus Notes view.
#6. How to send a document as a link in a Lotus Notes email
Use this tip to learn how to implement Formula language code that sends documents as links within Lotus Notes email messages.
#7. How to generate formatted sequence numbers with Formula language
Get step-by-step instructions and the Formula language code needed to generate five-digit sequence numbers in a Lotus Notes application.
#8. Create a computed Lotus Notes field to list Personal Address Book names
Learn how to create a computed Lotus Notes field that generates a complete list of users in a specific Personal Address Book (names.nsf) group.
#9. How to cull elements from a list using Formula
String and list handling are not completely covered in Formula language. Here's a way to avoid that issue using an 'invented' Formula function that culls elements from a list.
#10. Implement attachment fields in a Lotus Notes Web form
Get details on how one member created multiple attachment fields in a Lotus Notes Domino Web form, e.g., Requester and Approver, using Formula language.
Related resources from SearchDomino.com:
- Using Formula language code to sort Lotus Notes messages by subject
- Formula language button manages Deny Access list searches