Formula Show Line

The Formula Show Line function calculation shows or hides checklist lines. This function is applicable for all checklist lines, including headings and questions.

The input in the Input field or in the Selected (Boolean) field is stored in the variable. The variable content is evaluated in the Formula Show Line field and the result of the formula Show Line (TRUE or FALSE) controls the value in the Formula Show Line field. The calculation is performed automatically using the Automatic Recalculation field in the checklist header and the checklist lines.

Example

In the following video, one question and two answers have been defined in a checklist template. The answers expect Boolean type of values (Yes/True or No/False). The variables "C_LINE1" and "C_LINE2" are assigned to the answers in the Variable for Dynamic BOM fields. The Show Line checkboxes are selected as per the default and the Formula Show Line fields use a NOT formula for the opposing line, therefore:

• If answer line 1 is selected, then do not show line 2 (Formula Show Line = NOT C_LINE2).
• If answer line 2 is selected, then do not show line 1 (Formula Show Line = NOT C_LINE1).

Based on the formula calculations, when you select the Selected checkbox on one of the answer lines in the checklist template, the Show Line checkbox is cleared automatically for the other line; therefore, this line is not shown in the document checklist. If the Selected checkbox is cleared, the Show Line checkbox is selected again.

The Show Line checkbox is updated automatically when selections are made due to the activated Automatic Recalculation fields on the header and answer lines.

Feedback

Submit feedback for this page .