Notes the Calculator
Posted by Theo Heselmans on August 13th, 2007
It's been a while (cfr. 'A Present for you') since I gave the 'end-user' a Notes tip. This is one I discovered some years ago, and I still use it frequently.
Whenever you have a editable field in Notes
(it can't be a rich-text-field, like the body of an email),
e.g. the 'To' field in an email, try this:
- enter a calculation formula, such as 9*3 or 345*121%
- press 'shift-F9'
- voilà: the formula is evaluated and the result is displayed instead !
Extra tip for us formula-geeks:
you can even put @ formulas in there, and have them evaluated too !
Category: Domino/Notes | 
Technorati: Show-n-Tell Thursday, SnTT
Comments (3)
WOW!
Thank you for the tip, this will come really handy at times.
Thomas
{ Link }
This is actually more generic and useful than you realise (it's been in Notes since at least V4). You can actually evaluate whole formulas in an editable field - I do it all the time to test stuff out without having to put stuff in buttons and switch between Designer and Notes.
Use @prompt to display the results of the formula you evaluate in the editable field - but NB, the prompt can be misleading if the result of the formula is a list (you'll need to explode that kind of result to display it in the prompt).
Hope this tip proves as helpful to you as it has been for me.
@Bernard
The post was primarily targeted at end-users.
That's why I mentioned @formulas as an 'extra tip', but indeed it can be quite powerful.
BTW, you do mean 'implode' to show lists in a prompt ;-)