Top 10 Formula language tips

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.