The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

FileMaker Script Debugging And Analysis – FileMaker Today

Get real time updates directly on you device, subscribe now.

 Have you ever created a script and it fails? Have you ever created a script that worked perfectly but now is giving you errors? Ever created a FileMaker solution, came back to it months / years later, look at the scripts and say ” What in the world is going on here?” Finally, have you ever inherited a FileMaker database that is as organized as a soccer riot?

In a series of upcoming posts, we are going to discuss bugs that can be found in some FileMaker scripts ( preventing, finding and fixing). We also will cover tools that can help provide analysis for your scripts. Sometimes you inherit a database that has been under development by at least a half dozen developers. Sometimes it’s a database that has always been designed on the fly. So not that much documentation is available about the solution. Here we will talk about ways to get out of trouble … and … learn more about your databases!

FileMaker Script Debugging And Analysis WHAT CAN GO WRONG WITH DESIGNING ON THE FLY

You have probably heard the quote that some folks spend more time on planning a vacation than they do planning for their retirement. You might even be saying to yourself, “I do that!” Well, I’m not going to write a guide about retirement planning but I will tell you a little about the woes you can get when designing a FileMaker solution on the fly.

Can you imagine building a house on the fly? Forget about those blueprints, they are simply a waste of time! You are about through building the house, when you realize that you need a basement. You realize that the pipes for the hot water are running into the den and the bathroom has no electricity.

In the database world, you may realize that your data will not relate to other key files to meet your users needs. You have to do major deconstruction and reconstruction to get it to work. Since it was all on the fly, you might or might not be able to remember exactly what fields, calculations, scripts, relationships and layout do exactly what. You are paralyzed with fear that if you delete something, it may very well break another aspect of the database solution.

Don’t get me started on those FileMaker database solutions that have been worked on the fly by multiple developers, over many years and with literally no documentation. These are commonly called Winchester Mansion databases.

NOTE: The Winchester Mansion was built by the widow of the original maker of Winchester rifles. She built the mansion with fake doors, stairways the went nowhere and the like. The idea was to confuse the vengeful ghosts of those killed with those rifles. From what I understand, additions to the mansion are ongoing and they still are designing it to the original specifications of confusing the ghosts. So you can see how we can make the connection of a staircase that doesn’t go anywhere to a FileMaker script or relationship that is never called upon.


Much the same can be said for perfect FileMaker scripts. Everyone wants their scripts to be perfect but no one wants to spend the time planning, documenting and debugging them. As we are talking about debugging, we should say there are many levels. In most cases, the bug notification information comes in after the product has been rolled out and is in use.

Some of us, think we run pretty tight scripts. Some of us can get by just dandy with the “at the moment testing” and fix it on the fly routines. In some cases, the tight code we write doesn’t mean anything because we are working on someone else’s database.

As we all know ” the devil is in the details”, debugging is a very important part of the design process. In fact, some believe that debugging is a very under rated skill. If you have 10 programmers at a somewhat competitive level, the best debugger is the best of the bunch.


More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

© 2008 – Dwayne Wright –

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.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More