Creating a logical formula field

  1. Specify the virtual field ID using the naming convention, &XXXX. Use option 1='Create'.
  2. Specify the column heading by either specifying a description or a message ID. If specifying a description, you can defined the column heading per language by pressing the language button. If specifying a message ID, the column heading is automatically displayed in the end user's M3 language.
  3. Select virtual field type 6-'Logical formula'.
  4. Specify the logical type for the condition, alphanumeric or numeric.
  5. Specify the first operand which is a field from the field group.
  6. Specify the condition.
  7. Specify how to set the second operand which are field from field group, specific value, or blank.
  8. Specify how to combine two or three different conditions.
  9. Specify how to set the value if condition is true which are field from field group, specific value, or blank.
  10. Specify how to set the value if condition is false which are field from field group, specific value, or blank.
  11. Press Enter.