There is an undocumented function that is very handy for developers. It's a "formula debugger." To activate this formula debugger, hold down the Control and Shift keys, go into the menu and selecting File -> Tools -> Debug LotusScript. To turn it off, just repeat the same steps. You won't see a check mark or any indication of its activation in the menu, but when you go into a database and choose an action that uses formula code, a debugging window will pop up similar to the LotusScript debugger.
The top half of the panel displays your formula code with the returned values in the bottom half of the screen. You can step through your code. It's really handy and you don't have to fool around with the laborious process of inserting and removing @Prompts in your code. Of course, Lotus doesn't support this (yet).
MEMBER FEEDBACK TO THIS TIP
Yes, this is a great tip, but the author forgot to mention two very important points:
—Jens-B. A.
******************************************
Here's a little formula I have put into a smart icon that helps me debug formula. It uses the built in function in ND6 that was created to check formula code (i.e., @CheckFormulaSyntax).
The code allows you to copy and paste the formula code into the input box and it check's whether it has been put together correctly.
—Graham F.
******************************************
This does
To continue reading for free, register below or login
To read more you must become a member of SearchDomino.com
n't appear to work in Notes 6. When I hold the Ctrl-Shift keys simultaneously, and click on File-Tools-Debug LotusScript, it doesn't turn the Debugger on (i.e., there isn't a checkmark next to "Debug LotusScript" in that menu). Can you confirm whether that's for Notes 6 or just Notes 5 and earlier?
—Daniel T.
******************************************
Yeah this tip works great for R5x or earlier clients but won't work in R6x clients.
—Amit Bhardwaj, tip author
******************************************
I think this is a great tip! The writer suggested using it prior to any Evaluate() call. suggest using it to debug any @Formulas you are working with during routine development. I created a simple form that I put in my utilities database and will use it all the time. The form has one field and one action button. Put something like this in the button:
You may also want to check out another tip, called Validating a Notes formula from LotusScript. That tip is closely related to this one.
—Doug J.
Do you have comments on this tip? Let us know.
This tip was submitted to the SearchDomino.com tip exchange by member Amit Bhardwaj. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.
