UPDATE: 2013-06-20 FileMaker 12 version of the demo is available that should work with Windows. UPDATE: 2012-08-07 Windows users with FileMaker 12 have an option to solve the JSON error message issue by swapping out the Web Viewer steps and instead employ the new Insert from URL script step. This will save a few lines of code […]
Continue reading
Archive | FileMaker Pro Techniques RSS feed for this section
Shortening URLs using FileMaker
September 6, 2010 
5 Comments
Update: 2012-11-27 At the request for reader Robin, I had a closer look at this and it seems that both Google and Bit.ly have gone to POST method (rather than the simpler GET method) and are more locked down. They both now require an API key. You could build a method for this approach, but […]
Continue reading How to Clear a Saved Password in FileMaker
August 23, 2010 Comments Off on How to Clear a Saved Password in FileMaker
Saved your password and can’t get to it? Here is how to get it ‘unsaved’ “Remember this password in my keychain” clicked accidentally? Sometimes, whether accidentally or intentionally, users will click the ‘Remember this password in my keychain. I usually recommend, especially for laptop users, that they not check this option, because then password control […]
Continue reading Drag and Drop List or Portal Sorting
August 17, 2010 6 Comments
2014-06-16 Update: After spending a fair bit of time on getting this technique to work, I have come to the conclusion that it is too slow to use on a network and can’t recommend it to others. If you plan to use this on stand alone or runtime solutions, it could still be an interesting approach. […]
Continue reading Growl Integration with FileMaker
August 12, 2010 4 Comments
FileMaker dialog boxes can be informative, but sometimes they are just annoying. You have to click them to get them to go away. Lots of times, you just want to give a little bit of feedback to the user, so they they get a clue as to what your scripts are doing, without requiring them […]
Continue reading Creating an Action Items Menu Button on a Layout
August 5, 2010 3 Comments
FileMaker 10 and 11 Script triggers allow you to clean up your interface by condensing a number of script buttons into a single popup. Here is how to get rid of unsightly buttons on your main layout by condensing a bunch of scripts into a single Action button. Source: FileMaker Advisor: http://my.advisor.com/doc/19582 1) Create a […]
Continue reading ‘Type Ahead’ Style Searching through Portals in FileMaker Pro
July 29, 2010 5 Comments
FileMaker’s new Script Triggers allow you to achieve a Google-like type ahead search in FileMaker, searching through a Portal. Here is how to set something like this up based on a person’s first and last name. The more letters you type… The more the portal gets filtered… Define a Search Field Later we will tie […]
Continue reading Highlighting Rows in FileMaker lists or portals
July 24, 2010 11 Comments
Update: New Demo File is here. Added demo of Portal Row highlighting as well. This new demo employs a similar technique, except instead of using the Get(RecordID), instead, the script gets the actual ID from a field. It requires a few additional steps, but if you read through the stuff below, you should be able […]
Continue reading Listening for Keystrokes
July 19, 2010 1 Comment
Here is another great Script Trigger technique. Sometimes you want to use Up and Down arrow keys to navigate a portal or list view. Here is how you can do it, by writing a simple script and attaching a script trigger to the layout. In this example, I use the Up/Down keys to move through […]
Continue reading MailChimp Integration with FileMaker Pro – Part 2 of 4
July 14, 2010 29 Comments
UPDATE: 2013-06-20 FileMaker 12 version of the demo is available that should work with Windows. UPDATE: 2012-08-07 Windows users with FileMaker 12 have an option to solve the JSON error message issue by swapping out the Web Viewer steps and instead employ the new Insert from URL script step. This will save a few lines of code and […]
Continue reading MailChimp Integration with FileMaker Pro – Part 1 of 4
July 10, 2010 27 Comments
UPDATE: 2013-09-03 For those of you who find all this stuff a little too confusing or too much work, you may want to consider a recently announced FileMaker database/web service just came through my email box. The application is called Mail List Maker, is built in FileMaker Pro and offers a full fledge email management system that […]
Continue reading 99 Bottles of Beer – in FileMaker 11
July 5, 2010 Comments Off on 99 Bottles of Beer – in FileMaker 11
A while back I took a PHP course. The instructor pointed out a website that had demonstrations of the old song ’99 Bottles of Beer’ as implemented in hundreds of different programming languages (1,342 different languages when I looked). 99 Bottles of Beer is a good beginners programming exercise, because it involves a loop, with […]
Continue reading Processing Indicator in FileMaker 11
June 13, 2010 1 Comment
A processing indicator is something that FileMaker has long needed. Various developers have come up with different solutions to this missing feature. With FileMaker 11’s ability to create charts and graphs, finally there is a fairly easy built-in method to doing a processing indicator. What follows is a description of a fairly portable approach to […]
Continue reading
HomeBase Software 