Submitted by Peter Rosenberg on Feb 15, 2012 7:16:41 AM

Re: The Lotus Notes In-Built Formula Tester

To Mark, pointing at Jeff's sidebar plugin: URL is pointing to nowhere (404)

Submitted by Peter Rosenberg on Feb 15, 2012 7:13:01 AM

Re: The Lotus Notes In-Built Formula Tester

If one have a Notes "container" like a button on a Draft memo, one can utilize this for approx. the same thing:

REM {Idea by Peter Rosenberg, to help debuggers who earlier relied upon using Memo Subject field to evaluate formulas};

REM "Date: 2012-02-15";

source:=@Prompt([OkCancelEdit];"Enter your Formula";"Please enter you formula below."+@NewLine+"Tip: Use a notepad to keep the code before testing is here";"@Now");

parseresult:=@Eval(source);

result:=@Prompt([Ok];"Your Formula result";"Your formula:"+@NewLine+@Text(source)+@NewLine+"---------------------"+@NewLine+"Resulted in this:"+@NewLine+@Text(parseresult));

@True

Submitted by Robert F Harwood on Jan 13, 2012 9:55:08 AM

Re: The Lotus Notes In-Built Formula Tester

checked

Submitted by Mark A Sta-Ana on Nov 2, 2011 8:25:46 AM

Re: The Lotus Notes In-Built Formula Tester

For doing serious work, I like to use Jeff Gilfelt's Formul8 sidebar plugin (http://www.jeffgilfelt.com/Formul8/). Especially when you're testing several lines of formula code.

Submitted by P Davies on Mar 5, 2010 6:55:32 AM

The Lotus Notes In-Built Formula Tester

this fantastic feature has been around since R3 I believe - very very useful - glad its working in 8.5.1

CTRL M to create the memo saves valuable time too :D