Skip to Content
FileMaker® Pro 9 Bible
book

FileMaker® Pro 9 Bible

by Ray Cologon, Dennis R. Cohen
March 2008
Intermediate to advanced content levelIntermediate to advanced
768 pages
21h 46m
English
Wiley
Content preview from FileMaker® Pro 9 Bible

Chapter 12. Calculation Wizardry

In Chapter 7, we introduce you to the Specify Calculation dialog and demonstrate a few aspects of its utility and capability. However, if you have the impression that calculation is mainly about numbers, we have some surprises in store for you. Calculating in FileMaker is about getting the computer to work things out, but not necessarily just with numbers. In fact, calculations are great for people who aren't all that impressed with numbers. A bit of clear thinking will go a very long way, and the computer can do the rest!

Like scripting, calculations are integral to structuring and automating your solution. You can use calculations to determine access, control displays, and implement a variety of other features in your solution, as demonstrated in this chapter.

With FileMaker, a little work upfront can save you a lot of work later on. Calculations are one of the most extreme examples of this principle. Set one up, and it will keep chugging away producing results for thousands or even millions of records—enough to wear the buttons off a whole storeroom full of portable calculators.

You can employ the 243 built-in calculation functions FileMaker 9 offers, each of which is designed to do something very particular. However, what calculation functions can do on their own isn't the subject of this chapter, but how you can combine them together to achieve everything from clever tricks to downright astonishing feats is.

Note

A full alphabetical list of the calculation ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using FileMaker 8

Special Edition Using FileMaker 8

Steve Lane, Scott Love, Bob Bowers
FileMaker Pro 14: The Missing Manual

FileMaker Pro 14: The Missing Manual

Stuart Gripman, Susan Prosser
Domino Designer 6: A Developer’s Handbook

Domino Designer 6: A Developer’s Handbook

Tommi Tulisalo, Rune Carlsen, Andre Guirard, Pekka Hartikainen, Grant McCarthy, Gustavo Pecly

Publisher Resources

ISBN: 9780470177433Purchase book