Controlling row selection in a table field
To set an integer field with the number of the selected row
- Create an active link with a Set Fields If action.
- In Field column of the Set Fields panel, enter the field where you want the row number entered. (This is usually an integer field.)
- In the Value column, enter the table field name.
- Click the corresponding cell in the Value column, and then click the ellipsis (...) button.
- In the Expression Editor, select the table field, and click Add Field.
- Click OK.
The field name appears in the Value column in the proper format (for example, $Help Desk Requests$ ).
When the active link is executed, the number of the selected row is entered in the field from step 2. For example, if row 5 is selected, 5 is entered.
To set how a row is selected in a table field
- Create an active link with a Set Fields If action.
- In Field column of the Set Fields panel, enter the table field where you want to select a row.
- In the Value column, enter one of the following:
- A variable for a field that contains an integer (for example, $Select Row$ )
An integer
If you enter an integer in the Value column, use the following table to learn how to enter values that determine whether the user sees the row highlighted and whether the active link (which is executed through the Row Choice execution option) is executed.Value column contents
Result
n
Selects and highlights row n and executes the active link. The user sees the row highlighted.
-n
Selects and highlights row n and does not execute the active link. The user sees the row highlighted.
n + 100000000
Selects row n and executes the active link. The user does not see the row highlighted. If a row is selected and is already highlighted, the highlighting does not move.
-(n + 100000000)
Selects row n and does not execute the active link. The user does not see the row highlighted. If a row is selected and is already highlighted, the highlighting does not move.