A READER ASKS: Don’t want calculations on a layout

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Ok, here is the scenario, I have created a deflation database, I have a data table, where most of the calculations are done, I have a Suppliers table, this table references the data table for Supplier spend, however I created a layout form my supplier table for quantity, spend, inflation, deflation, I created calculation in the data table for yearly spend per part number, deflation, projected deflation, deflation %, I reference the data table for supplier spend, I have created a table view layout of the supplier list, my goal is for this layout to do no calculation, is this possible?

Well, if the calculation needed is unique to that supplier, then “No”. You would have to have some sort of reference to the supplier record in question. If the calculations have nothing at all to do with the supplier, then the answer might be “yes” but probably not.

Layouts themselves don’t normally have much to do with calculations. There are Get functions that are specific to a layout as viewed in a window.


There are situations in which you may want a calculated value but not all the time.

For example, you might want an inventory calculation to take place once a day. If you have FileMaker 9 Server, you can have it run scripts as part of a schedule. So at midnight, you could set a non calculation field equal to a calculated value. Then as your daily user go from record to record, the calculation will not trigger. In cases like this, I often add a “refresh” button next to a field like this. That would trigger the calculation for that field alone for that record alone.
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.