Tutorial

40 FileMaker Pro Tutorial
8. Select the placeholder test and type Membership Type =
“Continuing”
exactly as it appears here.
9. Select the placeholder resultOne, and type 100.
10. Select the placeholder resultTwo, and type 200.
11. Make sure the calculation result is set to Number.
12. Click OK.
If you receive an error message, make sure that all spaces and
punctuation are identical to the formula shown above.
13. Click OK to close the Define Database dialog box.
The Renewal Fee field appears at the bottom of the layout.
Depending on the size of your screen, you may need to scroll down
to see it.
Your calculation formula is now complete. When data is entered in
the Membership Type field, FileMaker Pro will compare it to the
word we are testing for, “Continuing.” The test is true if it matches
this word, and the calculation will return your first result, 100. If it
doesn’t match, the test is false, and the second result is returned.
Test your calculation
To see if your calculation works, try changing the value in the
Membership Type field to Continuing, and notice the result in the
Renewal Fee field—it should change as the membership type
changes.
Automatically enter a serial number
FileMaker Pro lets you automatically enter certain types of data—for
example, incremental numbers—when you create a new record.
Look at a serial number example
1. Choose Window menu > Sample07.
2. Go to the last record in the database.
3. Locate the Member Number field, and note the current number of
this record.
4. Create a new record by choosing Records menu > New Record.
The value in the Member Number field of the new record is
increased by one.
Field list
Formula
list
Replace these placeholders with your calculation
Verify the type of data to be
returned by the calculation
The completed calculation