This form is displayed when you right-click a line in the grid on the Script Editor's Derived Fields tab and select Amend from the pop-up menu or when you double-click a line in the grid. It enables you to add or amend a derived field; a user-defined variable.
Identification:
Name: Identifies the derived field
Description: Typically the nature of the derived field, for example Greeting
Format:
Type: Select from the drop-down
menu the kind of data that the field can contain:
Boolean: Can contain only two values; true or false, normally displayed as Y for yes or N for no
Character: Alphanumeric values including capital letters A to Z, lower case letters a to z, digits 0 to 9, and other symbols on your keyboard
Base currency: Default currency with which the system has been set up
Date: Year, month, and day
Foreign currency: Another currency that the system has been set up with other than the Base currency
Numeric: Holds an actual number, on which arithmetic operations can be performed, as distinct from a string of alphanumeric digits
Time: Time of day
Size: If Type is set to Character or Event notes, this is the maximum number of characters the field can contain, otherwise it is not applicable
Update: Select from the drop-down
Startup: Opens the file when the script is launched
Each from: Opens the file only when required by a form in the script
Contents:
Value: Use the Ellipsis button
to select from a list of standard derived fields
PUSH BUTTONS:
Insert field: Add a field based on a field belonging to a table in an Autoline module
Standard Derived Field...: Enables selection from a menu of standard field types
