O'Reilly logo

FileMaker Pro 9: The Missing Manual by Susan Prosser, Geoff Coffey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Introduction to Calculations

Fields and layouts form the basis of every database: You can’t have a FileMaker database without them. Using just what you know so far, you can build all kinds of useful systems that store data, from an address list to a catalog of products.

But if you want to do the really useful stuff with your data—total an invoice, analyze trends, compare figures—you need specific tools. For those tasks, FileMaker provides calculation fields and a whole drawer full of functions that let you examine, compare, and combine field values. And calculations aren’t just limited to number-crunching tasks. You can use them to find out about the computer your database is running on, track who’s logged into the system, monitor their privileges, and then perform logical tests based on what you find. You’ll start by learning how FileMaker handles calculations, and then you’ll see how some common functions can take your database up to a new level of power.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required