Calculations and Data Types

The last chapter introduced the terminology and concepts behind FileMaker's calculations. You learned how to create them using the Specify Calculation dialog box's tools. Functions, as you saw in the previous chapter, play a big role in good calculation construction. In this chapter, you'll learn the details about the most common functions for the various data typestext, number, date, time, timestamp, and containerand when to use them. As in your FileMaker design life, if you want to test a calculation, just create a calculation field and start building it using the techniques you've learned so far. If it doesn't work the way you expect, or if you don't need it after your experiment is done, just delete the field.

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