Specify Field dialog box
To choose a field in another table, choose the table from the tables list above the list of fields. (You can also choose Manage Database to create a relationship or a table.) Then select a field from the list of fields.
You can also click the Manage button 
to choose a field from the current or a related table, if the button is visible.
to choose a field from the current or a related table, if the button is visible.
Note When the Specify Field dialog box opens from within the Send Mail dialog box, the tables list may default to Current Layout (LayoutName) and display only the visible fields on the current layout. To display all field names from the current table, choose Current Table (TableName) from the list.
|
2.
|
If the field you’re specifying is a repeating field, for Repetition, enter which repetition you want.
|
You can also click Specify to create a formula to calculate the repetition.
|
3.
|
Click OK.
|
In the following example, you create a script step that inserts text in a repetition based on the day. You have a database that has a date field with seven repetitions. Each repetition represents a day of the week starting from Sunday. If you run the script on a Wednesday, the calculation returns 4 and the text is inserted in the fourth repetition.
count=1
Loop
Clear [Select;FileName::FieldName[count]
count=count+1
Exit Loop If [FileName::count=5]
End Loop
Loop
Clear [Select;FileName::FieldName[count]
count=count+1
Exit Loop If [FileName::count=5]
End Loop