#CONDITIONALNOENTRY

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

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

This topic contains the following sections:

• Create Conditional No Entry Rules

• Format Conditional No Entry Cells

• Edit Conditional No Entry Cells

• Delete Conditional No Entry Cells

Create Conditional No Entry Rules

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

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

A Conditional No 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 not allow it as entry:

Below is an example of a Conditional No 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 No Entry Cells

Format the cell by changing the font style, font color, and background color in the right panel of the Conditional No 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 No Entry cell.

As you customize the Conditional No 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 No 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 No 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 No 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.