Advanced Techniques

Not of the faint of heart, these posts talk about advanced (and oh-so-cool) FileMaker Pro tips and techniques.

  • The OnObjectValidate Trigger

    9-3-2010 by Geoff Coffey

    FileMaker 11 added just one new object trigger, and it is a strange little dude: OnObjectValidate. This trigger fires after you edit a field, before it is validated. If you thought FileMaker already had enough after-you-change-a-field triggers, you were mistaken. In this article, I explain how the various field triggers fit together and why OnObjectValidate […]

  • Pop: Goes the…um…Variable

    8-26-2010 by Geoff Coffey

    We start our return to semi-regular writing with a small-but-awesome custom function: Pop. If you grew up in the American mid-west like me you might think I’m talking about [soda|soda pop|coke|soft drinks]. But I’m actually talking about stacks. In the computer science world, pop means to take something off the top of a list, and […]

  • Using Global Variables for List Selections

    3-4-2009 by Daniel Antunes

    A funny thing happened while I was stumped over the question of how to allow one of our clients to select and deselect multiple items in a list.  Multiple people would be using the list at the same time.  I was struck by the fact that I’ve been making something more complicated than it needs […]

  • Script Triggers: Filter as You Type

    1-13-2009 by Geoff Coffey

    For years, FileMaker developers have been devising various filter techniques. The idea is that you type all or part of a name, part number, description, etc… and a list of results filters down to show relevant matches. As handy as these techniques are, they always stop just short of perfect because, before FileMaker 10, you […]

  • Script Triggers: Using the Keystroke Trigger

    1-6-2009 by Jesse Antunes

    Adding Script Triggers has opened up a world of possibilities for FileMaker developers. Each different type of script triggers has it’s own nuances and pitfalls to be aware of. In fact, with script triggers, FileMaker, in some ways, begins to expose the complexity of more advanced programming environments. Nothing illustrates this more than the OnLayoutKeystroke […]

  • Set Field by Name Exposed

    1-5-2009 by Geoff Coffey

    In our article about FileMaker 10, we promised some tips on using the new Set Field by Name script step, which gives FileMaker the power of indirection. This is a complicated concept, and we’ll be posting some real world examples along the way, as well. But first, we’ll give you a full explanation of the […]

  • Filemaker Server 10 New Features & Backup Scheduling

    1-5-2009 by Daniel Antunes

    At long last, 10 has arrived!  After all the tantalizing little glimpses that we got last devcon, I for one am glad we finally have something we can get our hands on.  There are a lot of new features and changes to go over, and I’m going to mention them all here, but for this […]

  • Alternating Color Based on Alternating Data

    6-5-2008 by Geoff Coffey

    An interesting question popped up on the TechNet discussion list this evening: I have a list of records with dates, which often repeat from one record to the next. I want all the same dates to be one colour. Then the next date would be another color. The background color of the date field would […]

  • Duplicating a Set of Records in FileMaker

    4-21-2008 by Jesse Antunes

    Duplicating in a Record in FileMaker is very easy…. but a found set???? That takes a little bit of thought. Here is how I would approach the task.

  • Restoring Active Tab State

    11-23-2007 by Geoff Coffey

    Out of Date: If you’re using FileMaker Pro 10 or later, you can accomplish the goal in this article more easily using script triggers. See this newer article for details. If you use Tab Controls a lot (and don’t we all?) then you may have run into a little snag: When you switch to a […]

  • Need our help?

    We're ready when you are. Simply fill out our simple request form. We'll evaluate your needs and get in touch ASAP.