Use text in a function field with an expression

You can include text in a function field with an expression, such as a calculation or a comparison.

The following syntax applies:

• Fields names are between {curly brackets} (as is always the case in the formula editor).
• Text is between "quotation marks".
• You link text and variables using the ‘&’ symbol.

  Example:

  You want to include a payment reference in your invoices. However, it should only be printed if the invoice is not paid based on an agreement about automatic collection. The payment reference consists of:

  <sales contact code>/<invoice number>

  You use a function field that has the following expression:

  If {Collect} = False Then

     Result = “Payment reference: " & {Sales contact (invoice to)} & "/" & {Invoice number} & "."

  End If

  If you print invoice 2011556 for sales contact 21039, and the invoice will not be collected automatically, Profit prints the following:

  Payment reference: 21039/2011556

  If the invoice is collected automatically, Profit does not print the line at all.