Chapter 8, "Getting Started with Calculations," presented an introduction to FileMaker Pro calculation formulas. Our goals there were to give you a foundation in how and where calculation functions are used, and to present what we feel are the core functions and formulas FileMaker Pro developers need to know and use on a daily basis.
This chapter covers functions and usages that are more advanced or specialized in nature. Think of the core functions covered in Chapter 8 as the hammers, screwdrivers, and wrenches of a developer's toolkit. They're the tools you use every day. The specialized functions covered here are the metric socket sets, the low-angled block planes, and the self-leveling laser levels of your toolkit. These might not be things you use on every project, but they sure come in handy at times. The nice thing, of course, is that after you've made the "investment" in the specialized "tool," you'll have it handy for all future projects.
Certainly, our characterization of some functions or usages being part of a core and others being advanced is subjective and open to debate. We do want to stress that advanced doesn't necessarily mean difficult. Nor does it mean arcane or esoteric. We think that all the specialized functions presented here have very practical uses. In some cases, what's specialized isn't the function itself, but perhaps some usage of a core function that's not something you're likely to encounter on a routine basis.
We don't intend to present here a comprehensive list of functions. That can be found in the companion to this book, FileMaker 8 Functions and Scripts Desk Reference. Rather, similar to our approach in Chapter 8, we take a thematic approach and focus on demonstrating practical uses of a handful of functions.
Part I: Getting Started with FileMaker 8
Using FileMaker Pro
Defining and Working with Fields
Working with Layouts
Part II: Developing Solutions with FileMaker
Relational Database Design
Working with Multiple Tables
Working with Relationships
Getting Started with Calculations
Getting Started with Scripting
Getting Started with Reporting
Part III: Developer Techniques
Developing for Multiuser Deployment
Advanced Interface Techniques
Advanced Calculation Techniques
Advanced Scripting Techniques
Advanced Portal Techniques
Debugging and Troubleshooting
Converting Systems from Previous Versions of FileMaker Pro
Part IV: Data Integration and Publishing
Importing Data into FileMaker Pro
Exporting Data from FileMaker
Instant Web Publishing
FileMaker and Web Services
Custom Web Publishing
Part V: Deploying a FileMaker Solution
Deploying and Extending FileMaker
FileMaker Server and Server Advanced
Documenting Your FileMaker Solutions