Skip to main content link. Accesskey S
  • Company Logo
  • Crossware Mail Signature Wiki
  •  




Original noneditable edition

Formula Lookup

ShowTable of Contents
HideTable of Contents
Formula lookups allow you to extend the simple database lookup functions, and use the Notes @Formula language to evaluate a formula and return a string.



Formula


A Lotus Notes Formula that will be executed.

NOTE:
  • The formula must not contain @DB Commands.
  • All text must use single quotes.
  • The formula must not contain any carriage returns.
  • The formula must return TEXT, e,g used the @Text() the result will be numeric.

The formula is parsed in the same way lookups are in the body of the signature.
In the above example the (!Fax!) lookup will be calculated and the results will be inserted between the single quotes to generate a string. This text is then used in the formula to determine if the fax number and description should be inserted into the signature.

   

 
File TypeSizeFile NameCreated On
image/gif 5 KB formulalookup.gif 8/2/10 2:05 PM