How To Merge FileMaker Files

You may already know that merging FileMaker Pro database files can be a tedious and challenging process. After copying, you could spend hours fixing broken links, missing fields, remapping buttons, etc. For this reason, many people simply choose to maintain multiple files even when that may not be the ideal or preferred setup. With the […]

Continue reading ...

Instant Messaging In FileMaker – No Plugins or Internet Access Required

This article follows up on 2 previous articles discussing dynamic multi-threading with web viewers: Timers and Alarm Clocks. I recommend that you read those articles first if you have not already, especially the first one on Timers, as it covers the basics of this technique using web viewers, URIs and JavaScript. Note: This article shows […]

Continue reading ...

Alarm Clocks – Dynamic Multi-Threading with Web Viewers

With a FileMaker Pro Web Viewer and a little bit of JavaScript code, you can create a FileMaker Pro native alarm clock that updates every second: no plugins, no distracting refreshes and no affect on performance. This article follows up on the previous article, Countdown Timers – Dynamic Multi-Threading with Web Viewers. I recommend that […]

Continue reading ...

Countdown Timers – Multi-Threading With Web Viewers

In FileMaker Pro 10, FileMaker introduced OnTimer scripts which allow us to trigger a script to be run after a specified period of time. OnTimer scripts are great for implementing delays, timed refreshes and a whole host of possibilities yet to be discovered. However, one drawback that I have run into is that when the […]

Continue reading ...

Checkbox Record Selection In A Multi-User Environment

Click checkboxes to manually select records from a list. The ability to manually select individual records for filtering is useful and often necessary, but is not as straight forward as you might think. Your first thought may be to create a field in the table to act as a flag and place it on a […]

Continue reading ...

Dynamic Portal Filters With Multiple Criteria

Create a dynamically filtered portal with multiple filter criteria with two (or more) global fields, portal filtering and a script trigger calling a simple script to refresh the page. This article expands on the technique used in the previous article, Dynamic Portal Filtering While You Type.

Continue reading ...

Dynamic Portal Filtering While You Type

With portal filters, you can now show filtered views of related records in portals without having to define new relationships. What’s better than that? How about dynamically filtering your portal data while you’re typing letters into your search field! With a very simple script (4 steps), a custom function and a script trigger, you can search data in your FileMaker portals the same way you search for music in iTunes!

Continue reading ...

Live, As-You-Type Search in FileMaker

FileMaker 10’s Script Triggers feature opens the door to create richer, more dynamic and more responsive user interfaces.  For example, it is now possible to create as-you-type search functionality similar to that found in iTunes and Mac OS X Spotlight where the list of results updates dynamically as the user types. This is a slick […]

Continue reading ...

Faster, Maintainable Scripts with Variables

9 FileMaker Pro Tips using the Set Variable script step to make your scripts more efficient, portable and easier to maintain. Use variables instead of global fields. Variables are stored in active system memory while fields are stored on disk. Therefore, accessing a variable is much faster than accessing fields. So, use global variables instead […]

Continue reading ...

Google-like Search Through Relationship Filtering

This article describes a script-less technique for using dynamic relationships and portals to search values in a related table using a single global field. It is a part of a series on Advanced Search Interfaces. This technique produces an interface similar to the Google-like Search described in previous articles in this series, but instead of […]

Continue reading ...