Formulas

Overview

• Formulas can be used to manipulate or transform the data on the fly. In this way you can adapt the data to match the destination system at the same time as transferring the data.
• A formula can be used in the Source Field in either the Table Link or in the Field List.
• To tell the system that you want this field to be a formula, you have to start the line with two #-signs (hash). For example:  ##CURRENTDATE().
• In formulas, single quote '' is used to enclose a text string - like in 'this is a text string'. And double quote "" is used to enclose field names (only needed if the field name contains blanks or special characters) - like in "Address 2".