With new versions of its entire
FileMaker product line (FileMaker Pro, FileMaker Pro Advanced, FileMaker Server, FileMaker Server Advanced, and FileMaker Go), FileMaker, Inc. offers improvements for every type of FileMaker user: end users both in the office and out, and developers of every level of ability, from amateurs to aces.
We outline the new features of FileMaker Pro 12 here, and on the next page, those of FileMaker Go 12. New Zealand pricing is at the bottom of the page.
Extreme makeover done extremely easily
The most obvious improvement in FileMaker Pro 12 is its library of 40 fresh layout themes. A theme controls the initial appearance of objects on a layout: the color scheme, the shape and style of buttons, the text formatting and borders of data fields. I never made use of FileMaker's themes in the past; the old themes were somewhat homely, and a theme could only be applied at the moment a layout was created and couldn't be changed. However, I may reconsider my avoidance of themes. The new themes in FileMaker Pro are fairly attractive, and it is now possible to switch to a different theme later. You can even start a layout without a theme and apply a theme afterwards -- that's what I've done with some of my own old databases. It's a quick and remarkably effective way to perform a facelift on your databases. My one regret -- one I suspect a lot of developers will share -- is that it is still not possible to define and save custom themes.
The new themes library includes a number of boffo themes designed specifically for use on the iPad and iPhone. The interoperability with FileMaker Go is the most exciting part of the FileMaker 12 release, and with the themes for iOS, even beginners can create great looking apps for the iPad and iPhone.
The snazzier aspects of the new themes are made possible by new layout options, such as the ability to add gradients to almost any layout object, the ability to change the look of buttons by controlling corner radius precisely for rounded buttons and the ability to highlight buttons differently when users mouse over or press them -- behaviors we all expect from well-designed websites. There are many other new design enhancements in FileMaker Pro 12, and one of my favorites is the option "Delineate fields on current record only" in the Layout Setup dialog. You can highlight the selected record in a list simply by putting a check in a box. In the past this required advanced techniques (capturing record ID with a script trigger and using conditional formatting based on a calculation).
Growing pains
Two other changes in layout mode may seem awkward to experienced developers for a while, until old habits give way to new. Layouts in FileMaker Pro 12 now have explicit widths and expect to be used within windows of a certain size. This change is part of FileMaker Pro 12's much better support for different types of displays (desktop computer, iPad, or iPhone, and iPod touch) and is complemented by the new screen-size guides or "stencils" that make it easy for you to tell if a particular layout will fit on a particular screen.
As a longtime FileMaker developer, I found it difficult to adjust to the new way objects are selected in layout mode. In the past, you drew the selection rectangle completely around the object (say, a field, or field label, or button) to select it. In FileMaker Pro 12, objects are selected if the selection rectangle touches any part of the object. The new behavior is consistent with Apple's user interface guidelines -- it's how selection works in the OS X Finder, for example. And whether you're an old hand or a tenderfoot, the new behavior certainly makes it more difficult to select one object in a crowded group. Fortunately when you really need it, the old behavior can be recovered by holding down the Command key while selecting.
FileMaker Pro for amateurs
What about the database amateur, the non-developer or the person who just doesn't have a lot of experience creating databases? Too timid to enter layout mode? Not to worry. FileMaker Pro 12 still has lots to offer you, too.
There are starter solutions: 16 diverse, professionally designed, ready-to-go databases for inventory, to-do lists, personnel, scheduling, time and billing, research notes, and more. The starter solutions make use of the new themes and include layouts optimized for FileMaker Go on iOS devices, as well as layouts for desktop computers running FileMaker Pro. These solutions are fairly generic, of course, but the ones I have played with are pretty slick. If you are in need of one of these solutions, you can get it at no extra charge. They come with every copy of FileMaker Pro 12.
And you might become a developer yet, or at least a dabbler. They're called "starter solutions" for a reason -- you're expected to tweak them to suit your own needs, and if you can resist the temptation, you're stronger than me. Want to learn your way around FileMaker Pro in a hurry? One of the best things you can do is take a starter solution apart.
Interesting odds and ends
FileMaker Pro 12 contains scores of enhancements that are beyond the scope of this review--new functions and script steps and many other improvements. But there are a two items that deserve special mention.
Container fields in FileMaker Pro 12 are greatly enhanced. Some of the improvements are a bit esoteric (scripted handling of the installation of plug-ins) but one that many will appreciate is the ability to handle certain kinds of dynamic content. You can now read a PDF right in a container field, moving from page to page, even searching, without having to extract the document from the field.
The Chart Setup dialog has been improved and several new chart types have been added. Saving a chart still requires developer access to the file, but it's now possible for ordinary end users to create ad hoc (temporary) charts, even without any special privileges. Sweet.
What's the catch?
This is a major upgrade loaded with improvements to a product that was already best in class, so you will want to place your orders immediately, right? Right, but there is a catch: The file format for FileMaker Pro databases has changed.
The last five versions of FileMaker Pro, since the release of FileMaker Pro 7 in 2004, have used the same file format, distinguished by the file type extension .fp7. For almost eight years, it's been possible to open any FileMaker Pro database with any recent version of FileMaker Pro, or even to open a new database with an old version, provided the database didn't make use of features introduced after the release of the version of FileMaker Pro used to open it. All this backwards and forwards compatibility was great while it lasted.
FileMaker Pro 12 has a new file format with the file type extension .fmp12. The new format was necessary to support the new themes technology. If you want to use an old database in the new version of FileMaker Pro, the file will have to be converted to the new format. (Conversion is a breeze and is done right in FileMaker Pro 12.) If you work by yourself, by all means, upgrade. But if your databases are shared -- with 100 other users or just one -- be aware that it will be necessary to upgrade to FileMaker Pro 12 on every computer that must access the files. iOS users of FileMaker Go must upgrade to FileMaker Go 12. And if the files are shared with FileMaker Server, you'll have to upgrade that software too, to FileMaker Server 12 or Server 12 Advanced.
New Zealand pricing
FileMaker Pro 12 is NZ$499. The upgrade is NZ$299.
FileMaker Pro 12 Advanced is NZ$ 799. The upgrade is NZ$499.
FileMaker Server 12 is NZ$1,800. The upgrade is NZ$1,080.
FileMaker Server 12 Advanced is NZ$5,500. The upgrade is NZ$2,475.
FileMaker Go 12 for iPad and FileMaker Go 12 for iPhone are free from the iTunes App Store.