Remember to Freeze the Window

Read an interesting post by Chad Novotny at the Support Group this morning (read it here), which pointed out something I have never considered, but I suppose had frequently noticed. It’s changed the way I think about Looping through Records and is a simple, quick and easy way to improve performance whilst using the Loop […]

Navigate Multi-Page PDFs in Container Fields

So if you’ve read my last post, you’ll know I had been searching for and had found the right syntax for adding a QuickTime Movie to a Container Field via a Set Field Script Step, but why was I looking to do this? Well it’s not because I wanted to store movies in a Container […]

Import Quicktime into Container Fields via a Set Script Step

I had some problems finding the correct syntax for this process, so now I have successfully found it I thought I’d share it: On a Mac: moviemac:/path_to_your_file On Windows: moviewin:/path_to_your_file Oh and why might you want to do this? Because if you use the Insert File, Insert Picture or Insert Quicktime Script steps you have […]

Upgrading FileMaker Pro from a Trial Version

So over the weekend I needed to install FileMaker Pro 11 to a customer’s new computer, unfortunately they had misplaced the CD, but total disaster was averted as they had emailed me the serial number when I had first installed FileMaker for them on the old computer. So my main problem was how to locate […]

Record Count in Portal Fields

I used to use this very simple calculation to display a record count in all my solutions: c_Record_Status “Record ” & Get(RecordNumber) & ” of ” & Get(FoundCount) & ” ( ” &  Get(TotalRecordCount) & ” total )” and though it still works in my main layouts in FileMaker 11 it seems to have stopped […]

FileMaker Custom Messages for Validation Errors

Sometimes you can’t see something because it’s straight in-front of your eyes. So if you’re looking for how to display a custom validation message when validating a field then it’s right at the bottom of the validation pane for that field: And yup I had to google to find this out. This is what happens […]

FileMaker Custom Function for File Path to @Dropbox

From the second version of my first database (back in 2002) I have used my FileMaker databases to control the creation of a structured folder system to enable the efficient and uniform storing of structured data for each of the businesses I have worked with. Early on in my development of FileMaker systems I stumbled […]

Default @Dropbox File Paths

So I needed to know the default file paths for dropbox on the Mac and different versions of Windows for a Filemaker Custom Function I’m building and couldn’t find a simple listing anywhere on the internet so if you’re interested here they are: Default Dropbox location on Mac OS X: Macintosh HD/Users/YourUserName/Dropbox/ or more quickly […]

Exporting to vCard from FileMaker

FileMaker doesn’t offer the same level of system integration with OS X as it’s little brother Bento, although it offers more power. It is possible, however, with a little work to extract the data you want to use, in the format you need. The advantage of being able to export a contact to a vCard […]

FileMaker Custom Function for Initials

So in my last blog post you’ll of noticed that I used a custom function called format.initials. I used the function in my calculated field: c_Postal_Name so that I could extract the initials from a name. Custom functions are a great way to reuse FileMaker code again and perform the same function on multiple fields. […]