Pause table processing

When you work with a table, you might want to wait with individual actions until your table meets certain criteria. For instance, you might want to wait until the Bot has processed all rows before you perform a specific table action.

To pause processing, you work with ActionMode WaitOn.

You can define one of the following criteria:

• A cell has a specific value.

• Your table, a row, or a column has adopted a specific property. For instance, your table has reached a certain number of rows.

If the specified wait time has passed and the table doesn't fulfill the defined criteria, the Step fails.

Specify a wait time

By default, the Bot waits 20.000 milliseconds.

You can specify a different wait time in the setting Synchronization Timeout during WaitOn at Project > Settings > TBox > Synchronization.

Alternatively, you can add the special task configuration parameter SynchronizationTimeoutDuringWaitOn. Unlike the global setting, this parameter only applies to the object for which you set it. For instance a particular Bot or folder.

Define a wait for a specific cell value

To define a wait until a cell has certain content, follow the steps below:

1. In your Table element, identify the cell you want to wait for (see "Define which cell to steer").

2. Enter the expected value into the Value field of the cell. You can enter the following values:

   • any text (case-sensitive), date, number, or Value Expression

   • wildcards if the value is a string

3. Select the ActionMode WaitOn.

4. Select one of the following data types from the DataType drop-down menu:

   • String: processes the input value as a string

   • Date: processes the input value as a date

   • Numeric: processes the input value as a number

5. Define the action you want to take as soon as the criteria is fulfilled. To do so, identify the cell you want to steer and define one of the following actions:

   • "Write data into a table"

   • "Save cell and table data"

   • "Verify the contents of a table"

Define a wait for a property

To define a wait until your table, a row, or a column have adopted a certain property, follow the steps below:

1. Select the ActionMode WaitOn for your Table, Row, or Col.

2. Open the drop-down menu of the Value field:

   • In the left entry field, enter the property. You can choose one from the drop-down list, or you can type in another one.

   • Select your operator from the operator drop-down menu: == (equals) or != (does not equal).

   • In the right entry field, enter the expected value.

3. Define the action you want to take as soon as the criteria is fulfilled (see step 5 above).