Start/End Loop Through Grid
Solution No. 34
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”.
So Where Would We Use It?
Allows the user to select the records they wish 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 to Only select rows that are checked 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 that 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”.
So Where Would We Use It?
Allows the user to select the records they wish to include, that are 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 | John C. on | Nov-19-2012 |
| Last modified by | John C. on | Nov-19-2012 |
