Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

January 2000

Are You Up for a Review?
by Brian Dunning

digg this article | this article

Reviewed In This Column - Two New Integrated Office Solutions

Wondersys (five clicks)
Editors Choice
Publisher: Data Dudes

Lame-O-File (one half click)
Publisher: Data Dorks

This month, we're going to examine two new commercial FileMaker Pro solutions. Wondersys, by Data Dudes, is a complete integrated database system to run every aspect of your business. Lame-O- File, by Data Dorks, promises to deliver the same but falls short in many key areas.

Let's start the analysis at the very beginning: launching the solution. The first thing I noticed when I tried to open Lame-O-File was that there were an awful lot of icons in its folder. I wasn't sure which one to click on, and the first few that I tried brought up some default FileMaker layouts with some data, but no navigation buttons, instructions, or anything intelligible. Finally, by chance, I double clicked on a file that brought up a layout containing some navigation aids, and I found a Main Menu button.

When I launched Wondersys, I discovered that it made no difference which icon I double clicked, the startup scripts caused the Main Menu to come to the foreground. Plus, there was a custom icon clearly labeled "Wondersys" which eliminated the guesswork.

Lame-O-File uses password protection on its files, and when the main file opens, it brings up FileMaker's default password entry dialog. The only problem with this dialog is that it provides no accompanying explanation or instructions. I had to rifle through the printed documentation to find a password that worked.

Wondersys also requires the user to log in with a password, since both solutions need to know who the user is in order to provide proper functionality to different groups of users. However, Wondersys is a little more user friendly about it: taking the user to a pleasant title screen, with a clearly explained global field for the user to input their password into. An Enter button runs a script which checks the password, and if it fails, it provides better options and navigation than FileMaker's default password dialog does.

Lame-O-File's layouts feature every known color, and even some that are unknown, on its buttons and fields. Perhaps Lame-O-File's designer decided that color-coding would bring clarity to the system. Instead, it brings an unprofessional circus-like discotheque of Karnival Konfusion. Wondersys is done in a discreet 3D grayscale interface, and has only a single highlight color that's used for the principal buttons, screen titles, and corporate logo.

That color scheme is not only consistent throughout Wondersys, the navigation bar is as well. The navigation bar has a row of consistent buttons which are available on every screen throughout the solution, allowing any untrained user to know exactly where he is, and making it easy to go anywhere. There's also a convenient Back button on every screen, in the top left just where people are used to seeing it in their web browser. Lame-O-File lacks consistent navigation; some screens have a Main Menu button, but it is often found in a different place and does not give the impression of nicely polished software.

Some of the calculation fields in Lame-O-File look just like the enterable, editable fields, and in fact are enterable. This is too bad; because trying to type something into them just throws an unearned error dialog at the user. Wondersys's developers have taken care to set all uneditable fields to be unenterable as well, and in fact they look different, so the user can tell not to click into them.

Whenever I test a FileMaker system, I always torture it as best as I can. I click where you shouldn't click, check for the availability of Delete All Records, type the wrong things into fields, cancel running scripts to see where I end up, and generally wreak as much havoc as possible.

Lame-O-File fell victim to most of my tests. However, the Wondersys developers seemed to know that I was coming, because they have anticipated every accidental or deliberate misuse of the system and trapped for it accordingly. Lame-O-File's developers didn't even cover their bases during normal usage. In numerous places throughout the solution, I received error dialogs, missing script warnings, or got stuck on layouts with no escape. Thorough debugging, which includes trapping for misuses, is of utmost importance to this reviewer.

Another annoying trait of Lame-O-File is that it seems to have been developed on a PC, and not tested on a Mac. Many of the fonts are illegible when viewed on a Mac, and the text fields are not quite tall enough the display full rows of text. Wondersys uses no fonts smaller than Arial 11, so it looks good on both platforms, and the developers took care to specify line height in pixels to insure cross-platform consistency.

When I click one of Lame-O-File's Find buttons on any of its screens, one of its most distressing flaws comes to light. Lame-O-File's response is dump the user into Find mode and pause the system, without onscreen instructions. Through trial and error, I discovered that finds producing no results bring up a dialog box with the unintuitive choices "Modify Find" and "Cancel." I found that if, while in Find mode, I put a value into an unindexable related field, some searches would take a great deal of time; and indeed, I had to force-quit on occasion. If I switched to another file, the first file would be left in Find mode and some of the rest of the system would then not work as expected&emdash;and when I switched back to that file later, it appeared that all my records had disappeared. Scary!

On the other hand, when I click Find in Wondersys, it takes me to a Find screen populated with global fields, each representing only the relevant fields I might wish to search on…and best of all, the system remains in Browse mode. When I clicked the clearly labeled "Perform Search" button on the layout, a script does all the work, including presenting me with better-worded dialogs in the event of an error.

Similarly distressing is Lame-O-File's use of the "preview and pause" technique when generating a print output. When I click a button to generate a report, Lame-O-File puts me in Preview mode with my report visible onscreen. The problem here is that there's no intuitive way to choose whether I want the report to print or not. There's also no intuitive way to go back and change my report parameters, or even to scan through the pages of the report (unless I happen to be proficient enough in FileMaker to know to use the unlabeled flipbook in the status area). Wondersys handles output a little bit better.

The report script takes a snapshot of the report (using Preview and Copy) and pastes it into a container field for me to view…and presents that container field to me in Browse Mode on a layout which has navigation buttons, including buttons to scroll through the multiple pages of the report, and to change the report parameters. Best of all, there's a Print button to use once the report looks the way I want it to, and a Done button to click once I'm finished viewing the report but don't need it printed.

Since Lame-O-File offers me only Continue and Cancel buttons in the status area, I can either Cancel (which leaves me on the same print layout with no way to get back into the system) or Continue. Continue brings up the Print dialog, and only here do I get a chance to cancel the job. However, Lame-O-File's developers have left me hanging again. Clicking the Cancel button in the Print dialog only brings up a FileMaker error dialog, which asks me if I want to Continue the script or not. Assuming I am conversant enough in FileMaker to know what this means, either way I'm left on some unexpected layout with the file left in whatever state the script happened to leave it in.

Wondersys's clever usage of Browse mode and navigation scripts avoids all of these problems and leaves the average database user much happier.

Lame-O-File is best described as a showcase of many weaknesses found in FileMaker solutions everywhere. Even amateur FileMaker users would do well to study the improved techniques in Wondersys, or other systems like it, and the ergonomics and intuitiveness of their systems will no doubt improve immeasurably.

Browse Mode
Jan 10 Solving Performance Emergencies with FileMaker Server
Aug 06 Top Ten Sessions Cut from the 2006 FileMaker Developer Conference
Jul 06 Who's Driving This Thing, Anyway? Or, How Marketing and Engineering Buried the Hatchet (Warning: Contains a Curse Word)
Nov 05 Shingle Grandiloquence
Oct 05 In Celebration of Geek Magnetism
Aug 05 A Rogues' Gallery of Devcon Attendees
Mar 05 Lies, Damned Lies, and Project Specifications
Feb 05 Pick the Right Tool for the Job
Oct 04 Home Media Server Requirements
Jul 04 Leveraging Your FileMaker Lingo
Apr 04 Technical Support Redux
Mar 04 Enforce Seats in FileMaker 7/8/9 Commercial Solutions
Feb 04 Reinventing the Wheel
Oct 03 WAP: The Technology That Wasn't
Aug 03 Brian Dunning's California Governor Election Platform
Jul 03 Sex and the Single Software Developer
May 03 XSLT: Creeping Out of the Closet?
Feb 03 A Consultant's Guide to Traveling
Nov 02 Adventures of Bat Magnum, FileMaker Consultant
Sep 02 FileMaker at Area 51
Aug 02 FileMaker Terminology
Feb 02 Computer Shunts
Dec 01 Aquabase Alpha & the Consultant's Challenge
Aug 01 It IS the Size That Counts
Jun 01 On the Trail of Sasquatch
May 01 Spring Cleaning
Feb 01 FileMaker Mobile Survivor Challenge
Jan 01 Letter from Nürburg
Dec 00 Performance Anxiety
Nov 00 Objection, Your Honor
Oct 00 Leveraging Convergence: Jargon for the 21st Century
Sep 00 Top Ten Things to Do at Devcon
Aug 00 Aesop's FileMaker Fables
Jul 00 Ten Commandments of FileMaker Pro
Jun 00 Explats Cross Examined
May 00 iMac, Therefore iServe
Mar 00 Valley of the Dollars
Jan 00 Are You Up for a Review?
Nov 99 Tales from the Script
Sep 99 Tech Support Revisited
Jul 99 Moderns vs. Classicals
Mar 99 Nashoba, We Hardly Knew Ye