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 […]
Category Archives: Scripting
Instant Messaging In FileMaker – No Plugins or Internet Access Required
August 5, 2011 – 8:15 am
Note: This article was written many years ago (2011), and although the basic principles still apply, the solution may not work perfectly with the newest versions of FileMaker. It shows you how to build a product that we sell: Triple-i Messenger. The product has since been updated and is now more feature rich, cleaner and […]
Alarm Clocks – Dynamic Multi-Threading with Web Viewers
July 29, 2011 – 10:30 am
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 […]
Countdown Timers – Multi-Threading With Web Viewers
July 22, 2011 – 5:00 am
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 […]
Checkbox Record Selection In A Multi-User Environment
June 3, 2011 – 1:03 pm
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 […]
Dynamic Portal Filters With Multiple Criteria
October 11, 2010 – 11:01 pm
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.
Dynamic Portal Filtering While You Type
October 2, 2010 – 10:04 pm
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!
Live, As-You-Type Search in FileMaker
October 14, 2009 – 11:35 am
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 […]
Faster, Maintainable Scripts with Variables
February 26, 2009 – 1:15 am
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 […]
Google-Like Searches In FileMaker – Non-Contiguous
October 28, 2008 – 12:00 pm
This article is a part of a series on Advanced Search Interfaces. In my article, Google-Like Searches In FileMaker, I described a method for creating a search-engine-like interface for searching the contents of a FileMaker Pro database. This article expands on that method by eliminating one of it’s shortcomings: it would only find records containing […]
