“Snapshots” offer a way to freeze (and share) the results of a query at a point in time, as opposed to a saved search query, where the number of records can change as the database does. Views can now be sorted in folders (a feature I’ve had in Zoho Creator from the outset), which becomes important if your application mushrooms to include dozens of customized displays. The chart popped up with layoff numbers properly grouped by category. I tried adding one table of categories, a second table of companies where I assigned them to categories, and a third table of announced layoffs by companies. The new charting option was simpler than creating reports and worked as advertised, even when following relationships across three tables. The problem may well have been user error - still, after going through eight windows, some with multiple options, I felt the process should have been a bit more foolproof.ĭoing basic grouping of data in a table view, much like grouping similar entries in a spreadsheet (such as all entries by state), was a lot easier. The report option felt needlessly complicated, with numerous dialog windows that I was required to click through, explaining what to do yet when I tried to follow the directions, the options I wanted were grayed out. It’s also quite simple to create views where some fields are read only and others are editable. The program offers an easy way to display data from related tables, such as showing a customer’s name, address and phone number based simply on adding the customer ID to that record - no SQL inner join statements required. This would be a useful feature in the database-driven application we use at Computerworld for story planning, for example, where a key phrase might appear in the headline, description or comments fields.įileMaker Pro offers flexibility in field definition for users who don’t want to write their own SQL or code their own front end. The new Quick Find search box looks through all fields in all records and is a handy addition to version 11, allowing users to quickly find a key word or phrase without having to guess which field it’s in. Once I got there, though, the new inspector panel was a useful addition to zero in on any editing need - look and feel or data structure. I would have preferred an obvious way to jump to layout editing even when in table view. Specifically, when I was in a table view, the “modify” button offered access to just a few change options I needed to be in a list or form view to see the “edit layout” button and inspector access. It can be a bit confusing finding the inspector panel if you’re in a table layout, since it isn’t readily available. A new feature in version 11 is the “inspector” panel, which offers a single place to tweak layout, structure and field behavior. Once you’ve set up your tables and imported your data, you can edit both the structure and appearance of your database in several ways. This is helpful if you’re unfamiliar with the interface it can be turned off if you are. The opening QuickStart screen is straightforward enough, letting you create a new database from scratch, from a template or by importing via another file. FileMaker Pro 11 adds several more features such as charting, “recurring import” to automatically update a database from an Excel or text file and a “Quick Find” search box. Version 10 had already improved on previous versions, including saved searches, triggers that launch scripts based on certain events, and a major revamp of the interface. FileMaker Pro 11 lists for $299 or $179 to upgrade from previous versions. And while I’ve largely turned to online database apps, notably Zoho Creator, it becomes frustrating when I try to do more complex work, such as querying multiple tables or setting up sophisticated many-to-many relationships, or customizing data view layouts.Īs a result, when I heard about the introduction of FileMaker Pro 11, it seemed time at last to take FileMaker out for a spin. Yet while I’m most comfortable with the database I learned on - MySQL - I don’t work with it often enough to feel confident writing complex SQL commands. Having parsed and plotted three years worth of pedestrian accident data from my town just because the info was available, it’s fair to say I’m somewhat of a data geek.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |