CLEAR Instruction

The CLEAR instruction removes all current rows from the Table variable you specify.

The CLEAR Instruction is only available when you are creating a computation.

The ADD instruction enables you to add rows to a Table variable, but before you can add new rows, you first have to clear all existing rows in the table using a CLEAR instruction. Once the rows are empty, you can use the ADD instruction to add new rows.

Instruction name Model After you drag and drop the model into the script tab:
CLEAR CLEAR ⟦TABLE_VAR⟧ Replace ⟦TABLE_VAR⟧ with the Table variable whose rows you want to remove in preparation for adding new ones.

Example

The CLEAR instruction is useful for when you want to present a table to the template user that is populated with information gathered from earlier questions in the interview. For example, assume you want to ask for the client's name early in the interview (using a Text variable named Client Name), then ask information about the client's family (using a repeated dialog named Children Dialog that repeats a Text variable named Child Name), and later in the interview ask information about the client's attorney (using a Text variable named Attorney Info). Finally, toward the end of the interview, you want the user to be able to select from a list of all persons previously entered (such as which persons the client wants to grant power of attorney) using a Multi Select variable with a Table variable named Power of Attorney List as its option source. To achieve this, your script will have to start with the CLEAR instruction, and the entire script of the Computation looks like the following:

CLEAR Power of Attorney List

ADD {Name:Client Name} TO Power of Attorney List

REPEAT Children Dialog

ADD {Name:Child Name} TO Power of Attorney List

END REPEAT

ADD {Name:Attorney Info} TO Power of Attorney List