Retrieve table rows to be used as records.
Retrieve each row from the table of the specified source record. You can use the retrieved rows in other Dos, just like records.
To apply each Do in the field category to a field in the table, you must first retrieve table row as record and pass in the source record. For example, if you set the record parameter of Set Field Value to the record retrieved by Retrieve Table Rows as Records, you can set field value to each row in the table.
Set Record, Destination Table, and Retrieve Empty Rows or Not.
Select the Action you used to retrieve the records, including the target table.
If this contains multiple records, get the table row from each record. If there are no records, nothing is done.
Select the table from which to retrieve the data.
If you select Do Not Get Empty Rows, the table does not get rows with empty rows.
Empty rows mean all columns (Fields) are empty. Note that a field with a default value will not be considered empty. Fields that cannot be unselected, such as radio buttons, are always exported, as they cannot be empty. However, calculated fields, even if they have values, are ignored.
| Criteria | Occurrence |
|---|---|
| When Record Is Ready | |
| When All Records Are Ready |
* Not raised if no record exists that matches the criteria.
Use caution when the record parameter contains multiple lines. In this case, for each row in the record parameter, whenever the table row is finished getting all rows, a When All Records Are Ready occurs. If you connect with When All Record Are Ready, the result of this action, visible from the record, is all of the table rows for one record. The table row for the other records is not included.
For example, if the record parameter has three records called A, B, and C, and there are 10 table rows in A, 5 table rows in B, and 3 table rows in C, When All Record Are Ready occurs three times in A, B, and C, and When the Record is Ready occurs 10 + 5 + 3 = 18.
If you want the criteria to be when you have finished getting table rows for all records, use When Other Actions Finished. If connected by When Other Action Completes, the result of retrieve table row as record is simply a collection of table rows of all records. This can also contain the same record repeatedly.