Extending Calculations

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

Layout Basics

Creating Layouts

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

Advanced Calculations

Extending Calculations

Part V: Scripting

Scripting Basics

Script Steps

Advanced Scripting

Part VI: Security and Integration

Security

Exporting and Importing

Sharing Your Database

Developer Utilities

Part VII: Appendixes

Appendix A. Getting Help



FileMaker Pro 8. The Missing Manual
FileMaker Pro 8: The Missing Manual
ISBN: 0596005792
EAN: 2147483647
Year: 2004
Pages: 176

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net