Author Archives: Darren Terry

About Darren Terry

I am a FileMaker 13 Certified developer who works for a company called Pacific Data Management. I have spoken at numerous FileMaker Developer Conferences and user group meetings.

Shaking the Dependency Tree

Editor’s Note: few names in the FileMaker community command as much respect andĀ  admiration as that of today’s guest author, Darren Terry. This article is a distilled summary of Darren’s popular “Shaking the Dependency Tree” presentation, as seen at the PauseOnError unconference, the FileMaker Developers’ Conference, and FMPUG user group meetings.

8-7-2014 9-27-05 PM

Demo file: Shaking The Dependency Tree.zipĀ 

INTRODUCTION

FileMaker Pro has a very powerful calculation engine built into it. The calculation engine is exposed to us in a number of ways: calculation fields, script steps, conditional formatting, filtered portals, web viewers, chart objects, etc. But it can be a challenge to determine precisely when various kinds of calculations will refresh, and what causes them to refresh. Continue reading