Filemaker Pro 10 TU692LL/A Benutzerhandbuch

Lesson 7

  

|

  Simplifying data entry     49

When you want FileMaker Pro to perform a calculation for you, for example to determine the amount of tax 
owed or the proper fee to be paid, you use a calculation field. Calculation fields are one of the FileMaker Pro 
field types. FileMaker Pro can perform simple and complex calculations.

The calculation formula uses values from the current record or related records. The formula can use values 
from all field types. You can use calculations to return text values (for example, combining the contents of 
first name and last name fields into a full name field), dates, times, timestamps, and the contents of container 
fields.

Members of the Corporate Travelers Club pay an annual fee. New members pay a fee of $200, while 
continuing members pay $100. The following calculation returns a membership renewal fee based on 
membership type.

There are several ways of formulating a calculation, each of which can yield the correct result. The following 
method uses an If statement to compare the data entered in the Membership Type field with one of the 
membership types. The calculation returns one of two results. 

1. Click Edit Layout.

2. Select the Membership info tab panel to bring it forward.

3. Click Manage in the status toolbar, then select Database.

4. In the Manage Database dialog box, click the Fields tab, if it is not already selected.

5. For Field Name, type Renewal Fee.

6. For Type, select Calculation to make this a calculation field.

7. Click Create. 

The Specify Calculation dialog box appears.

Select Calculation