Skip to Main Content
FileMaker Pro 9: The Missing Manual
book

FileMaker Pro 9: The Missing Manual

by Geoff Coffey, Susan Prosser
August 2007
Beginner to intermediate content levelBeginner to intermediate
799 pages
28h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 9: The Missing Manual

Auto-Enter Calculations

Calculation fields are fantastic—they save time and ensure error-free results. But they have one serious limitation: You can’t change their values. Of course, you can adjust the calculation itself, or the fields the calculation depends on, but sometimes you need to be able to override a field’s calculated value on a record-by-record basis.

For example, it would be nice if your invoice’s Date Due field automatically showed a date 30 days after the date of the invoice itself. But sometimes you may want to make an invoice due earlier or later, based on special circumstances (like a holiday). If you make the Date Due field a calculation field, you don’t have this flexibility. The solution is to use a normal Date field with an Auto-Enter calculation (see the box on Auto-Enter Calculations).

Like all the Auto-Enter options (Auto-Enter Options), an Auto-Enter calculation automatically fills in a field’s value, but leaves it changeable. You can get all the accuracy and time savings of a calculation field, plus the power to change your mind. Here’s how to put it to use:

  1. Bring up the Manage Database window and switch to the now-familiar Fields tab. From the Table pop-up menu, choose Invoices.

    The fields from the Invoices table appear.

  2. Select the Date Due field in the list, and then click Options.

    The Field Options dialog box makes an appearance.

  3. On the Auto-Enter tab, turn on the Calculated Value checkbox.

    The Specify Calculation window appears. It looks just like it did before, ...

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

FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

Susan Prosser, Geoff Coffey
FileMaker Pro 13: The Missing Manual

FileMaker Pro 13: The Missing Manual

Susan Prosser, Stuart Gripman
FileMaker Pro 11: The Missing Manual

FileMaker Pro 11: The Missing Manual

Stuart Gripman, Susan Prosser
FileMaker Pro 14: The Missing Manual

FileMaker Pro 14: The Missing Manual

Stuart Gripman, Susan Prosser

Publisher Resources

ISBN: 9780596514136Supplemental ContentErrata Page