Review: FileMaker 9 easier, but still not easy

Posted by Don Foy Nov 29, 2007 at 2:11am

FileMaker Pro 9 is billed as the database for the rest of us. Let’s get this out of the way: I’m not a programmer. I’m a tech support guy. I test software. I make sure it works right. I break it, if I can. I don’t write it. So I was anxious to see if they had brought this down to my level.

With 9’s Quick Start Screen, you can start a new database, open the user guide, open an existing database or go to the FileMaker Knowledgebase. That makes getting started easier.

But does that make database development easy? Easier, yes. Easy, no.

FileMaker 9 makes it easier to keep up with what you’ve done, with better script organization, better tab control, better toolbars, better database sharing (Instant Web Publishing does not yet work on Leopard), conditional formatting, better reporting—lots of improvements.

I had used FileMaker Pro 7 before and was looking forward to the promised enhancements in FileMaker Pro 9—especially the script grouping, the lack of which really confused me in 7 (all the scripts were just kind of lumped together in a mish-mash of scripts).

But it still isn’t as easy as I’d like for it to be. Maybe I’m making it harder that I should. Maybe I’m just not that smart. Maybe I’m trying to do too much fancy stuff before I learn the basics. It’s just not that easy for me. Maybe I’m trying to make it too nice and should just worry about making it functional.

Part of my regular job is to support nine newspapers, all on Macs, some old, some new. Keeping up with serial numbers, versions of software, what software is on what hardware and all of that, I wanted to build myself a database with all that info. I got it done, but it wasn’t pretty, and some things didn’t work the way I wanted them to.

I can’t blame that on the program, however. Most of it was my inexperience.

But it does bring up one of the best features of FileMaker Pro—the user base. There are a lot of FileMaker experts out there who will answer questions on forums. I got tremendous help with my database from those folks.

There are also other resources, like a white paper by David Kachel of Foundation">http://www.foundationdbs.com/downloads.html">Foundation Database Systems, which really helped me understand the basics I was lacking. There are other resources, but this was the best I found of this type. There are also many, many examples of FileMaker databases out there, many in a form that you can learn from the programmer. There are many plugins and add-ons, as well.

This is a very rich support community.

There are multiple version of FM Pro 9. The base version ($299) can be used to create or use a database. The Advanced version (US$499) is for folks who administer or frequently modify databases. Server ($999) is for folks who are on teams of users or Web developers. Server Advanced ($2,499) for teams who use Instant Web Publishing or submit SQL queries to FMP databases.

So, should you go out and buy FileMaker Pro 9. It depends on what you want to do. Simple databases are very easy to build with the program. If that’s all you are looking to build, and you have time to learn a few basics, FileMaker Pro may be your answer. It’s definitely easier than anything else out there.

If you have your sights set on a professionally designed database, hire a professional to design it for you.

Macsimum rating: 8 out of 10.

Advanced Search

Article Information

Comment on this Article Print this Article Email this Article Digg This

Contributor

Recent Articles