As you've seen in the past three chapters, FileMaker's calculation functions can do everything from text processing to financial analysis. Since calculations show up in so many different places in FileMaker, you might want to use the same calculation more than once. It would be a shame to have to type it in every timeand then make changes in several places the next time you need to modify it. In fact, a creative person like you may need a unique calculation to do something FileMaker, Inc. never thought of.
For these situations and more, FileMaker provides two ways to extend the calculation system. The first, called Custom Functions, lets you design your own calculation functions using the same syntax you use to create a calculation. You can then use these functions in any calculation in the same FileMaker file.
The second way is more complex, and thus more powerful. You (or someone you hire) can create a FileMaker plug-in in a programming language like C++. The plug-in also adds new functions to FileMaker's Specify Calculation window. The difference is that those functions can do anything a programmer wants them to do.
Note: To create custom functions or plug-ins, you need FileMaker Pro Advanced (a special version of FileMaker that has extra tools for developers). You can find out more here: www.filemaker.com/products/index.html. Once you've defined a custom function, though, it can be used in any version of FileMaker. Read on to find out more.
Part I: Introduction to FileMaker Pro
Your First Database
Organizing and Editing Records
Building a New Database
Part II: Layout Basics
Advanced Layouts and Reports
Part III: Multiple Tables and Relationships
Multiple Tables and Relationships
Advanced Relationship Techniques
Part IV: Calculations
Introduction to Calculations
Calculations and Data Types
Part V: Scripting
Part VI: Security and Integration
Exporting and Importing
Sharing Your Database
Part VII: Appendixes
Appendix A. Getting Help