Skip to content

I want to make another classification column required when a date is not entered

Answer

You can achieve this as follows.

  1. Set Range for the date column in the Date Column Filter Mode Selection
  2. On the "General" tab of Control by Status, make the classification column Input Required, and on the Conditions tab select "Not set" for the date column
  3. In the Editor, check Auto post back in the advanced settings of the date column

Overview

When you want to control "input required" by a condition, such as "I want to make Classification A required when Date A is not entered", you can achieve this with Control by Status and Auto post back. When you want the condition to be that a Date column is not entered, select "Not set" for the date column on the Conditions tab.

Operation Procedure

  1. From Manage Table - the Filter tab, select "Date A" and click the "Advanced Settings" button. In the advanced settings dialog, set "Mode selection" to "Default".

    Advanced settings dialog of Date A, with Mode selection set to Default

  2. On the Manage Table - Control by Status tab, register the control with the following content.

    1. Open the General tab, select "Classification A" in "Column control", and click the Input Required button.

      General tab of Control by Status, where Classification A is set to required

    2. Open the Conditions tab, add Date A, and check "Not set" as the condition.

      Conditions tab of Control by Status, with "Not set" checked for Date A

  3. On the Manage Table - Editor tab, enable Classification A and Date A, and check Auto post back in the advanced settings of Date A.

    Advanced settings of Date A with Auto post back checked

Behaviour After the Settings

  • When Date A is not entered, Classification A is required

    Editing screen where Classification A is required because Date A is empty

  • When you enter a value in Date A, the requirement on Classification A is released

    Editing screen where the requirement on Classification A is released once Date A has a value