FileMaker Goes to 11

By  |  Wednesday, March 10, 2010 at 1:13 am

You’d think there’d be a huge audience for powerful, easy-to-use database programs–especially ones that run on both Windows PCs and Macs. But FileMaker Pro, from Apple’s FileMaker, Inc. subsidiary, has long had the market pretty much to itself. Which is fine, because it’s a terrific program.

On Tuesday the company announced FileMaker Pro 11, an upgrade whose major new features are so logical that I was startled in some cases to realize that the software didn’t already have them:

  • FileMaker now has a built-in charting engine that lets you create slick-looking bar, line, area, and pie charts based on information from your database, then embed them in records. It’s pretty easy to use; I’d like it even better if it gave you a what-you-see-is-what-you-get preview with real data as you tweak your chart.
  • The program’s spreadsheet-like Table View has been beefed up a lot: It’s now easy to group records for reporting purposes, hide fields, and add fields and data without switching views.
  • A jumbo-sized, floating Inspector palette lets you click on an item in Layout Mode to see all the aspects you can control, such as position and alignment.
  • The Quick Find search field in the upper right-hand corner–similar to OS X’s Spotlight and the search in iTunes–lets you quickly do searches in the current layout.
  • You can now organize layouts into folders.
  • By using Recurring Import, you can set up a database to automatically import an external file such as an Excel worksheet every time you open the database. It’s handy if you use FileMaker to navigate your way around data created and update in another application. You can’t, however, make changes to records and then save them back into the original file, making the feature useful for viewing of external information but not editing.
  • Snapshot Link lets you capture a query result, then share it with other Filemaker users as a static lists of records that shows what you got at a particular point in time.

As before, FileMaker packs lots of power into a user interface that’s much friendlier than Microsoft’s still-gnarly Access 2007. Starter Solutions” provide templates for a variety of applications, from businessy ones (asset management) to personal productivity (a task list) to the purely personal (a database for organizing your music). Bento’s approachable enough to make it a good choice for serious home users as well as corporate types, but I wish that the company would bring its even more approachable (and much cheaper) Mac database Bento to Windows users. (It wouldn’t be a cakewalk, since the Mac version ties itself heavily into Mac-specific stuff like iPhoto’s photo library–but I don’t know of any Windows apps that are even Bento-esque.)

FileMaker Pro 11 is $299 for the full version or $179 as an upgrade; FileMaker Pro 11 Advanced, which adds more features aimed at professional database developers, is $499 or $299 as an upgrade. It’s available now, and there are free trial versions at the FileMaker site. A few screens after the jump.



6 Comments For This Post

  1. IcyFog Says:

    I’m at a quandary as to which database program I should choose when I buy my new Mac. Should I choose FileMaker, Bento or a maybe a freeware app?

  2. Tom B Says:

    I have been a fan of Filemaker for a long time. Very intuitive, and powerful.

  3. SirFatty Says:

    Been using FMP since V1 (1993?)… fantastic program, and since v9 it has native SQL connectivity. Much better than Access….

  4. Mikeycav Says:

    Start with Bento for $40. If it fits, great. If you need more, make the more expensive plunge. The good news is that you can import your Bento creation in FileMaker if you wish.

    Heck, as an FM Developer, I sometimes find Bento a good little sidekick for temporary “throw away” database needs.

  5. Dr. Brad Campbell Says:

    this is a very great blog that the readers having an interest to visit it often
    more on interesting things to follow and can give the satisfactions to the people.
    thank you guise for this article.

  6. dog house plans Says:
    this is a very nice blog very much interesting especially to all wide readers please come and visit blog often.

    dog house plans