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 […]

FileMaker Custom Function for formating Date Separators

I’ve finally created from scratch my own custom function for date formatting, I’ve appropriately called format.date (renaming my earlier format.date custom function to format.versions.date) as all it does is replace the date dividers or separators “.” and “-” with a standard “/”. So here it is: format.date (theDate) Let ( _divider = “/”; GetAsDate ( […]

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. […]