Conditional Mandatory Data field

The goal of Conditional Mandatory Data Fields Display is to control under what conditions a Data Field is mandatory. As data is entered in some Data Fields, other Data Fields can then become mandatory and require the User to enter data before allowing a Record to be saved. For example, a Dropdown Data Field could have Yes and No as available options. When Yes is selected, a “Details” text area Data Field becomes mandatory to force the User to enter additional details.

Key Concepts

Form: The Form of a Database Application defines the Data Fields and Data Sections that define the structure and layout of the Form used to enter and edit Records. A form consists of the main section which can contain multiple Data Fields and optionally of Data Sections.

Data Field: Data Fields are specific fields that allow users to enter data in a Record. Each Data Field has a specific type (date, date & time, dropdown, number, etc.) and has various properties to adjust its validation settings and its behavior.

Mandatory Conditions: The conditions that must be met by the data entered into Data Fields in a Form for a Data Field to be mandatory.

Settings Display Conditions on a Data Field

To set the Mandatory Conditions of a Data Field, you first need to switch to the Builder tab. You then need to click on a Database Application to open it in the Form builder. Once, the Form builder appears, click on Data Field for which you want to set Mandatory Conditions, this will open the Data Field’s properties grid on the right-hand side of the Form builder.

In the properties grid, click on the “Conditions” button for the “Mandatory Conditions” property to open the Mandatory Conditions of the Data Field. You can then set conditions for one or more Data Fields that must be met for the Data Field for which you are setting conditions to be mandatory. You can also select whether all the criteria (i.e. AND logical operator) or only one criterion (i.e. OR logical operator) must be met for the Data Field to be mandatory.