Help

Table Of Contents

FILEMAKER PRO HELP 1018

Options

• Select entire contents replaces the contents of a field. If you don't select this option, Insert

Calculated Result replaces only the selected portion of the current field, or inserts the result

at the insertion point. The default insertion point is at the end of the field's data.

• Select Go to target field or click Specify to specify the field to paste the calculated results

into. The target field must be present on the layout to paste successfully. If no field is active

when the script is performed, the step has no effect.

• Calculated result: Click Specify to define the calculation whose results will be inserted by

this script step. In the Specify Calculation dialog box, type the calculation you want

evaluated, or use the field list (on the left) and the functions list (on the right) with the

mathematical and text

operators to build the calculation.

Compatibility

Originated in

FileMaker Pro 6.0 or earlier

Description

If the specified field does not exist on the layout where the script is being performed, Insert

Calculated Result returns an error code which can be captured with the

Get(LastError) function.

Example 1

Inserts the current date if the invoice prints successfully.

Set Error Capture [On]

Print [ ]

Insert Calculated Result [Select; Invoices::Print Status; If ( Get (

LastError ) = 0 ; "Printed on " & Get ( CurrentDate ) ; "Not Printed" )]