Here’s a nice little tip if you want to check the output from an @Formula. I don’t think it’s documented anywhere, but I’ve been using it since R5 (I think) and it’s come in quite useful. I’m sure that when I tried it in the new Eclipse client in R8, it didn’t work. But I happened to try it yesterday in the 8.5.1 client, and it does work again.
All you need is a text field, your @Formula and two fingers. I usually create a new memo and use the Subject field. Type or paste your formula into the text field, like so.
Then press Shift + F9 (this is the Windows shortcut, I’m not sure about Macs). Hey presto! The @Formula is evaluated.
This can be particularly useful for testing an @DbLookup, complex formula or formula you want to put into an Evaluate statement in LotusScript. It also gives you an opportunity to quickly test formulae including a value from a field.