Standard Format Field

The Standard Format Field is used throughout the Longitude Connectors Interface to control the format and content of fields.

Simple Format Field

The first text box supports simple formatting functionality. Any bracketed "[]" values are replaced by the corresponding data from the record. Simple formatting can be achieved by mixing in additional characters.

Example:

   [code] - [desc] results in "BL - Blue."

Select Column Drop-Down This is pre-filled with available columns and when selected will append the column into the current selected text box .
Advanced Scripting Field This text box is enabled when the Advanced box is checked and supports advanced scripting capabilities with VB.NET. In this box you can write custom script code that leverages any standard VB.NET function as well as our own script functions. The output of the script is determined by your final "return" statement, and it can be either a string or a string array. For more information, seeVB.Net Scripting.