Start/end loop through grid
Solution No. 150
Start loop through grid
All subsequent actions will be processed between “Start Loop Through Grid” and “End Loop Through Grid” for each row of the grid. Note: This must be used in conjunction with the “End Loop Through Grid” action.
So where would we use it?
This action allows you to select the records you want to include in subsequent actions. All unselected records in the grid will be omitted from the action set.
Properties
To set the properties for this action, follow these steps:
1. Select Start loop through grid from the Action dropdown list.
2. Select Grid/Table from the dropdown list.
3. Check the option "Only select rows that are checked" in order to include selected records; otherwise, leave unchecked to include all records in the grid.
4. Check the option "Only rows that are edited in grid" if you only want to include rows that have had changes made.
5. Click Advanced Options (Optional); otherwise, skip to Step 10.
6. Select a value from the dropdown to "Only show distinct values from field".
7. Select Where condition from the dropdown.
8. Select the condition from the dropdown.
The choices are:
- Type In - Sets the condition to a value the user types in manually.
- Action Result – Sets the condition to a user-defined action result.
- Value From Screen – Sets the condition to a value pulled from a specific field within the specified screen.
- Value From Session – Sets the condition to a value that results from the current session information.
9. If you selected Type In for Step 7, enter the predefined value and proceed to Step 10; otherwise, specify a Value in the dropdown list below.
10. Enter Internal note (Optional).
11. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
End loop through grid
All subsequent actions will be processed between “Start Loop Through Grid” and “End Loop Through Grid” for each row of the grid. Note: This must be used in conjunction with the “Start Loop Through Grid” action.
So where would we use it?
This action allows you to select the records you want to include, found within the "loop through grid" actions. All unselected records in the grid will be omitted from the action set.
Properties
To set the properties for this action, follow these steps:
1. Select End loop through grid from the Action dropdown list.
2. Enter Internal note (Optional).
3. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
| Created by | Saudia A. on | Oct-19-2011 |
| Last modified on | Sep-17-2015 |
