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.
Paul,
Nice one – I cannot believe I have not picked up on that!!
Chris
This tipp is around for ages; but always good to bubble these little helpers to the surface from time to time.
It makes me wonder how many other little gems like this have been floating around, especially if you started notes around version 5 like I did.
Great tip!!! I’ve known and forgotten about this tip several times over the years. Currently I was in the “Forgotten” state until your blog post.
Thanks!
Thank you for the helpful reminder!