Subsections: Invalid If and Raise Flag If - j5 - 30 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Reference

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
30

The cell’s input is flagged or marked as invalid, when:

  • List – The specified choice option is selected. More than one option can be configured to invalidate or flag when selected. This rule can be used for Choice and Checklist Item type cells.

  • Range range icon – The entered value is outside of the specified range (Min to Max). This rule can be used for Number and Integer type cells.

    When there are multiple ranges defined on an input cell and a flag is triggered, only the highest or lowest trigger value is displayed. For example, if the cell’s flag ranges are 10-20 and 5-25 and the entered value is 26, only the greater than 25 flag is displayed. The greater than 20 flag is raised but not displayed.

  • Equal – The entered value is equal to the specified value or calculation. This rule can be used for any cell type other than those supported by the List rule.

  • Less than – The entered value is less than the specified value or calculation. This rule can be used for Number and Integer type cells.

  • Greater than – The entered value is greater than the specified value or calculation. This rule can be used for Number and Integer type cells.

  • Function – The entered value meets the conditions specified in the formula. The formula needs to evaluate to True to trigger the invalidation or flag (for example, =IF(D1>10,"True", "False"). This rule can be used for any cell type (except Chart and Sparkline cells).

  • Time – The entered date is not in the configured time range. This rule can be used to compare the entered date-and-time to the current date-and-time. It can be set to trigger if the date is in the PAST (before the current time) or FUTURE (after the current time).

Edit a validation/flag

An Edit option appears under each configured validation/flag rule. It allows you to change the following options:

  • Value - The input/s the rule is evaluated against.

  • Message - The message that appears when the rule condition is met. Both the rule and the message are displayed underneath the triggered input cell.

The configured Raise Flag If rules have the following additional options when you click Edit:

  • Category - Select the category you want to apply to the flag.

  • Priority - Select the priority you want to apply to the flag.

  • Hidden - Select this checkbox to hide the flag. The flag isn’t displayed on the IndustraForm when it is triggered, but it is still logged on the flag history table.

For details on how to create and edit the Category and Priority lists, refer to Flag Categories and Flag Priorities.