FileMaker 14 review: 30 years old and it's still an innovative database

FileMaker 14’s new navigation and control elements resembles the old header or footer layout parts, but it doesn’t scroll out of sight in form view and it is always displayed at 100 percent. Here, the listing of records has been zoomed out considerably, but the navigation part stays full size.

FileMaker 14’s new navigation and control elements resembles the old header or footer layout parts, but it doesn’t scroll out of sight in form view and it is always displayed at 100 percent. Here, the listing of records has been zoomed out considerably, but the navigation part stays full size.

Major improvements to FileMaker's infrastructure in its last two releases (versions 12 and 13) required a new file format (.fmp12) and sent a lot of developers back to school. FileMaker 14 maintains the existing file format and solidifies some of these earlier advancements (especially in WebDirect) but also keeps the pressure on developers by introducing powerful innovations that affect the design of databases for FileMaker Pro, FileMaker Go, and web browsers.

FileMaker Pro: Layout design

Since the news for solution developers applies equally to FileMaker Pro 14 and FileMaker Pro 14 Advanced, I refer to both when I say "FileMaker Pro." (These products have the same core feature set, but I do offer an overview of the differences.) Whichever tool you use, it's easier than ever before to create consistent and attractive layouts for your users to work in, whatever platform they're on.

FileMaker Pro 14 introduces the first change in ages to the basic part structure of layouts: a new part for navigation elements. Navigation parts can be placed at the top and/or at the bottom of a layout, and at first glance, look like the old header and footer layout parts. But unlike headers and footers, navigation parts don't scroll out of view and they aren't affected when users zoom in or out. I expect that FileMaker 14 developers will soon start using the navigation part for UI widgets like buttons, and will leave headers and footers for printed reports.

FileMaker 14 innovates in another surprising area: buttons. For starters, you can now format buttons to display text only, or text with an icon, or if you're the silent type, an icon without text. FileMaker Pro 14 provides a generous assortment of ready-made buttons for your use, but you can create your own if you like and add them to the assortment.

A more significant new feature is a new layout object called a button bar. It's always been possible to drop multiple buttons on a layout, then copy and paste them on another layout. Invariably, however, you'd spend a lot of time fiddling with the placement of individual buttons. The new button bar object eliminates most of the busy work, because the buttons in a button bar are defined as a set from the get-go.

Equally--if not more important--the button bar eliminates an old headache for developers and users alike. Developers of large solutions often want their buttons to have calculated or dynamic labels. There are many reasons why this matters, but one reason is that it makes it possible to change a button's label simply by modifying the calculated result; if you couldn't do that, you've have to edit each instance of the button on possibly scores of layouts, one button at a time. The old way to get dynamically labeled buttons involved defining fields in a utility table, placing the fields on layouts and turning them into de facto buttons by attaching actions to them. This works okay but has an undesirable side-effect: when users are shown a dialog that lists the fields on the current layout--for example, the sort dialog--the fields used as objects will be listed, too, even though they are not data fields at all. The presence of those user-interface elements in the dialogs inevitably confuses users. If you use button bars in FileMaker Pro 14, sort and export dialogs will display only data fields to users. This is a great example of how a rather technical new feature, put to use properly by a developer, ultimately makes life easier for end-users.

There are other improvements in the design tools, including some modest improvements to the handling of custom styles, but I do want to mention the new placeholder label. This lets you display the field label right inside the field, which, at least in some circumstances, can make for much cleaner data-entry interfaces.

FileMaker Pro: Scripting and calculations

For advanced developers, the most welcomed change in FileMaker Pro is likely to be the redesigned and renamed "script workplace"--in particular, the ability to enter scripts almost entirely from the keyboard. Those of you who don't spend hours every day scripting will be happy to know that you can continue to build scripts by pulling steps from the script step library. But developers who daydream in code will be delighted that they can now create a new script and simply start typing. You can add script parameters from the keyboard, too, and even edit calc formulas inline; and when the calc formula is a little too long to edit inline, you can switch to the more spacious old-fashioned calculation editor. This change doesn't make a whit of difference to end users, but FileMaker adepts are going to love it.

The script workplace lets you keep multiple scripts open for editing at the same time, which can be useful. It also now shows the listing of existing scripts and the list of script steps in panes on the left and right sides of the editing area that can be shown or hidden, as you like. If you have all the script steps in your head and can type well, you can just hide the script steps pane and forget about it. One quibble: I wish the list of existing scripts could be made wider, because it's not wide enough to display long script names.

At about this point you're probably getting nervous that I'm going to blab on about the ability to run FileMaker Pro in 32-bit or 64-bit, how cool it is that we can use "

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags filemakerProductivity softwaredatabaseproductivitysoftware

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

William Porter

Macworld.com
Show Comments

Essentials

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?