Archive for the ‘Techniques’ Category

Script Trigger pitfalls: Get(LastError)

Wednesday, May 20th, 2009

Script Trigger Pitt Fall

Today I implemented some script triggers in an existing project and something strange happened. My navigation scripts that have worked correctly for years, suddenly stopped working. I checked my scripts over and over again and couldn't find any clue, until I discovered an unexpected behavior.

Drag-and-drop with FileMaker

Tuesday, July 22nd, 2008

We sometimes get requests from customers to implement drag-and-drop in our solutions, for selecting certain records, e.g. you want to select a nice beer and add it to you order. This week's example shows a simple technique to use drag-and-drop functionality to select a record and drag it to another record to create a link between them.

Drag-n-drop with FileMaker

The first thing you have to do is to give the images in the container the same name as the id for the record. So for record 1 we are going to store a picture with 1.png in the container field, for record 2, 2.png etc ...

Now we can use simple auto enter functions, to get the id from of the name of the container data.

Download the example file here.

Speed up your conditional formatting

Tuesday, April 29th, 2008

Conditional formatting is a great tool to enhance your layouts and add additional functionality to your solutions, e.g. for calendaring. But sometimes conditional formatting can slow down the display of your layouts, because FileMaker has to calculate all the conditions you have defined. Today we are going to look at a technique that allows you to speed up your calculations by caching some results temporarily.


“Final call for flight …”

Thursday, February 28th, 2008


A couple of weeks ago, we talked about the “Beam me up, Scotty” or “tele-porting” method. This technique described how you can transfer found sets from one table occurrence to another.

This week's technique will show you how you can write a re-usable script to go to a certain record or found set, independent of the current context.

We call this technique the “hub” method. It is also described in the myFMbutler/SHpartners Development Guidelines.