#CONDITIONALENTRY

Conditional Entry allows you to define a set the conditions for entry cells. This feature only applies to the template type FORM.

Functionality for Conditional No Entry commands is the same, the only difference is, if the condition is satisfied it will apply the no entry command. For more information on Conditional No Entry, see #CONDITIONALNOENTRY.

This topic contains the following sections:

• Create Conditional Entry Rules

• Format Conditional Entry Cells

• Edit Conditional Entry Cells

• Delete Conditional Entry Cells

Create Conditional Entry Rules

1. To apply a conditional entry rule to an active cell, right-click a cell(s) in your template and select Cell Commands.

2. Then, select #CONDITIONALENTRY from the drop-down list:

A Conditional Entry dialog displays, as shown below:

3. To add a rule, select +New:

4. Choose whether you want your rule to be based on Cell Values or Formulas. By default, Cell Values is selected.

   Note: If you chose Formula, continue to Step 6.

5. Select the Operation drop-down and choose an operation from the list:

6. Enter the value(s) in the Value 1 and 2 fields, if necessary. If utilizing a formula, enter a standard formula consisting of an expression that operates on values in a range of cells, or a cell. For more information about admissible Bizview functions, see Template Variables.

In the example below, if the cell value is between 0 and 100 then it will allow it as entry:

Below is an example of a Conditional Entry rule based on a Formula:

Repeat the previous steps to add up to two additional rules. Rules are applied in the order shown, with a maximum of three rules.

7. To change the order, select the rule, then utilize the Up and Down buttons, as demonstrated below:

8. Don't forget to select Apply!

Format Conditional Entry Cells

Format the cell by changing the font style, font color, and background color in the right panel of the Conditional Entry dialog.

1. To edit formatting, first select the rule:

The right panel displays, with formatting options displaying at the top of the dialog.

2. Select the corresponding formatting option(s) to customize your Conditional Entry cell.

As you customize the Conditional Entry cell format, the Format Preview section allows you to preview these changes, as demonstrated below:

3. Select Apply to take all of the created rules, their content and formatting, and apply this to the cell/selection of cells originally selected. Or, select Cancel to revert all changes and close the dialogue.

Edit Conditional Entry Rules

Any cell(s) containing a command will be visible with an orange triangle in the bottom-left corner, as shown below:

1. To edit your rule's content or formatting, right-click the marked cell and select Cell Commands.

2. The command that is currently applied to the selected cell displays at the top of the list. Select the cell command:

3. A Conditional Entry dialog displays. Select the rule you want to edit:

Conditions for the rule display in the right panel, where you can make the necessary changes. Don't forget to select Apply!

Delete Conditional Entry Rules

Once the rule is selected, the Delete button becomes active. To remove the rule altogether, select Delete:

The rule is removed from the list, but is not removed from the template until you select Apply.

To revert any changes or deletions, select Cancel. All changes made in the dialogue will be forgotten and the dialogue will close.