How do you test Lotus Notes/Domino Formula language code? Put it in the application and see what happens?
Instead, save debugging time. Find out if your code is valid, before you use it in an application. Here's a better way to do it in IBM Lotus Notes/Domino 6.
A new @Formula validator/evaluator is available for download from the IBM Lotus Sandbox. You get a toolbar icon that validates formula syntax and evaluates formulas in Lotus Notes and Domino 6.
Here's how it works. The formula asks for a custom @Formula as input and checks the syntax. If the formula is syntactically correct, it executes and the result is displayed. If not, the error message along with the column and the erroneous code snippet is displayed.
Because the original formula uses the new @CheckFormulaSyntax formula introduced with Notes 6, it won't run with Notes 5. A stripped version is available for Notes 5, but there's no syntax check, and therefore error handling is clumsy.
The download is available at http://www-10.lotus.com/ldd/sandbox.nsf/ByDateNJ/56698e2267ccff1385256cd30061d8a0?OpenDocument.
Like other downloads from the site, SOAPConnect is offered "as is" and is not supported by IBM.