Home >

Specify Field dialog box

This dialog box appears so that you can choose a field.

1.	Select the field you want in the list.

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.

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.

Examples of calculated repetition

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.

Insert Text [Select; FileName::FieldName [DayOfWeek(Get (Current Date))]; Text.

In the following example, you create a script to clear the contents of a field with five repetitions.

count=1
Loop
Clear [Select;FileName::FieldName[count]
count=count+1
Exit Loop If [FileName::count=5]
End Loop

Related topics 

Adding a web viewer

Check Selection script step

Clear script step

Copy script step

Cut script step

Export Field Contents script step

Go to Field script step

Insert Calculated Result script step

Insert Current Date script step

Insert Current Time script step

Insert Current User Name script step

Insert From Index script step

Insert From URL script step

Insert Text script step

Paste script step

Relookup Field Contents script step

Replace Field Contents script step

Set Field script step

Set Next Serial Value script step

Set Selection script step