Rick Aguirre Presents PiVOT

Tonight, Rick Aguirre from Beezwas is presenting a really cool framework used internally at Beezwax for new project. It’s called PiVOT, and relies on the DoSQL plug-in from My FM Butler.

Google-like searches in FileMaker

Matt Navarre describes a technique for scripting searches across multiple tables in the same solution, and presenting your users with an intuitive list of the results.

Nice job, Matt!

FileMaker 10 a crowd pleaser

We weren’t able to “live blog” last night’s meeting, so here’s a recap:

We had 43 people sign the guest list, and there may have been a few who didn’t sign. It was standing room only!

Alexei Folger, Sr. Systems Engineer from FileMaker gave an overview of FileMaker 10’s new features, including:

• New Interface
• Script triggers
• Subsummaries in Browse mode
• Saved Finds
• Send Mail via SMTP
• Advanced Recover

Alexei spent some time discussing the new advanced Recover options, which gives you a more detailed log about the recovery process, and lets you control more of what happens in that process. One useful item is a checkbox to rebuild your indexes (Now or Later). If you use the Save as compressed option combined with rebuild index later, you could safely save a nice compact copy of your file for archiving. Alexei will be doing a session on the new Recover features at DevCon this year, should be a good one.

Looking at the new status toolbar, keep in mind that it is tied to the application, not the file. I.e. you cannot customize the toolbar and then distribute a file with those customizations. It’s quite handy though to have one-click access to data viewer and debugger, as well as all the Manage… menu items.

Note that if you use custom menus to rename a menu item, that name will be reflected in the toolbar button. Buttons that a user’s privileges have blocked will be dimmed. Hiding/locking the status toolbar via script behaves just as the old status area did.

On to the big one, Script Triggers: Alexei said there were two and a half ways to trigger a script. First there are field/object triggers (OnObjectEnter, OnObjectModify etc); and then there are layout triggers (OnRecordLoad, OnLayoutLoad etc). She showed some examples: typing shift-arrow up or down to increment a date field; keyboard shortcuts to emulate spreadsheet behavior in a portal, (go to the same field in the next row, or fill down); and adding notes to a text field for an activity log.

Another very welcome new feature is that you can now work with Sub-summarized records in Browse mode. The sort order is maintained and updated as you edit. E.g., if you’ve sorted by state, and you change a record from AL to AK, that record will jump to its correct summary group.

This can work well in conjunction with script triggers, e.g. you can click a radio button field to trigger a script that re-sorts based on your selection. Or, a simple script to go to next record makes it a snap to assign records to different groups – kind of have to see this one in action.

Alexei recommended that FileMaker Technet members download the recent white paper on script triggers.

Oh, and the “half” trigger she mentioned is the new “Install OnTimer Script” script step. This starts an “egg timer” that will run the specified script after the specified interval. Lots of potential there!

[For more on script triggers, I highly recommend the recent FileMaker 10 posts at SFR.]

Still reading?

A couple of new features clearly target end user rather than developers: saved Finds and table view editing. Saved Finds, be aware, are tied to accounts. They can’t be exported/imported to another file. One quirk: Finds that are saved while the file is not hosted will be available to all accounts when the file becomes hosted.

Table view has a new option: the user can add a column (field) to the table, even when that field is not on the layout! This cause a minor stir in the audience, which prompted Alexei to demonstrate that when access to a field is restricted via account privileges, not only would the field not be visible in table view, but it won’t even appear in the list of available fields the user can insert. So don’t panic.

The new SMTP mail feature is just what it says: you can send mail directly from FileMaker, no mail application required. [See: Zawinski's Law] You’ll still need a plugin to send multiple attachments, HTML and that sort of thing.

There are more features that will have to be saved for future meetings (e.g. new functions, and set field by name).

Server 10 was just briefly touched on. Server can now import/export and email. It has some better scheduling for multiple backups, and better log viewing.

The door prize for this meeting was a copy of FileMaker Pro 10 ADVANCED. Congratulations to winner James Robbins!

A big thank you to Alexei Folger for a fantastic presentation! Thanks to Phil Smith/FileMaker, Inc. for the pizza and door prize. Thanks to Fiddlehead Software for the beverages. Thanks to MacForce for the top-notch facility. Thanks for coming, everyone!

FileMaker presents FileMaker 10

RSVP For This Meeting

FileMaker Pro 10 is shipping! In this meeting, Phil Smith and Alexei Folger from FileMaker will be here showing the new product line. In addition to demonstration of the new features, we’ll be discussing some of the implications, and the directions this will allow developer to take solutions. Here are some of the new features:

• Script triggers • New Interface • Send Mail via SMTP • Saved finds • Server import/export features • Server SMTP mail • Server log viewing


Have a question for Alexei, something you’d like to see covered? Leave a comment below and we’ll ask it during the meeting…


Welcome to the Portland Blog