Category Archives: FileMaker 15

InspectorPro 6

InspectorPro 6 velocimeter

InspectorPro 6

Highlighting insight, performance and collaboration

Wow! InspectorPro 6 is finally here. Can’t even believe it. It was such a massive undertaking. Lots of great new things and many improvements. Really proud of this release. In the immortal words of the late Steve Jobs… “This is our best version ever”. The focus has been to deliver something that is truly useful. We hope this version helps you make informed decisions about your solutions.

Continue reading InspectorPro 6

Export Just What You Need in FileMaker

airplane maintenance layout including photo of a kid sitting ON the turbine engine
context means viewing things from a certain perspective; photo by antonio menanno

example file: Airplane_Maintenance.fmp12

The Lesson of Context

One of the first lessons I learned with FileMaker is that of context! Layouts, reports, calculations, scripts, and so on all act from the perspective of a single Table Occurrence (TO) — the “context” — pulling in data from related tables as needed. Generally, the record set being acted on is the set of records in that context table occurrence or a found subset thereof. There are a few exceptions to this, however, and today we’re going to explore one of those.

Continue reading Export Just What You Need in FileMaker

Fun with FileMaker Button Bars, Part 2: Expert Panel

customer info button tab selected with customer name occupation and employer fields
expert panel; image composite by lon cook

Fun with Button Bars, Part 2: Expert Panel

Have you ever had a FileMaker design conundrum for which you wished you could convene an Expert Panel to help guide you? If you’re thinking "panel of experts," I can’t help you, but if you’re looking for a more flexible and visually engaging alternative to FileMaker Tab Panels, this combination of a slide-panel control and a button bar just might be your "Expert Panel."

Here’s the Expert Panel.fmp12 example file. Use this to explore Expert Panel examples, scripts, and functions described below.

Continue reading Fun with FileMaker Button Bars, Part 2: Expert Panel

What’s this “Sign in to FileMaker Server” dialog?

If you’ve installed the FileMaker Pro client using a “For Teams” license, or as part of your FileMaker Cloud server usage, you may see a new dialog in FileMaker Pro.

Continue reading What’s this “Sign in to FileMaker Server” dialog?

FileMaker Cloud Live – SF Bay Area

road to FileMaker Cloud - Live with Beezwax
photo: stephane thomas

Join us in person, November 7th…

…for a live, hands-on presentation of FileMaker Cloud. You'll walk through the setup of a free trial with our guidance. Free credits for AWS will be provided, courtesy of FileMaker, Inc. Presented by Beezwax, hosted at 42 USA's facility in Fremont.

Continue reading FileMaker Cloud Live – SF Bay Area

FileMaker Collaboration, Performance & Insight with InspectorPro

FileMaker Collaboration Performance and Insight with InspectorPro

FileMaker Meetups: Seattle, Portland, Santa Clara & LA

Beezwax’s Vincenzo Menanno is hitting the road this week to visit our FileMaker colleagues across the West Coast, talking about “FileMaker Collaboration, Performance and Insight with InspectorPro”. Vince will be presenting our latest research, development and product offerings to FileMaker Developer Meetups in Seattle, Portland, Santa Clara and Los Angeles. If it weren’t a 4-day work week, who knows what other cities we’d be visiting!

Here’s a schedule of events, dates and times — and a Big Thanks to Meetup organizers for your help in hosting Vince’s presentations.

We have a number of surprises up our sleeves that we can’t wait to show. If you’re a FileMaker Developer in any of these metropolitan areas, we hope to see you there!

Continue reading FileMaker Collaboration, Performance & Insight with InspectorPro

Version 0.84 of bBox for FileMaker Now Available

Optimized for FileMaker 15, the new version of bBox includes 160 examples

We are pleased to release another update to bBox, v0.84 of our free utility plug-in to extend FileMaker solutions to other programs, code libraries, and OS X functions including Python, Ruby, AppleScript, Perl, Bash/sh, XPath, and SQLite.

bBox FileMaker Plug-in logo

This version has the following changes:

  • added function descriptions (FileMaker 15 only)
  • was returning wrong error code if problem reading output from POSIX commands (Bash, Curl, etc.)
  • new “no wait” option for Bash, Curl, and Sort to run processes asynchronously
  • new bBox_PythonEval for quick & easy calls with larger Python scripts or classes

Continue reading Version 0.84 of bBox for FileMaker Now Available

Freedom to Experiment – FileMaker 15’s Script Undo/Redo

exit…or entrance? you choose. photo by Lon Cook.
escape options; photo by Lon Cook.


FileMaker 15 introduces a major enhancement for the Script Workspace that is a real boon for developers: editing Undo and Redo. This functionality continues the efforts at making the Script Workspace more like a “text editor”. It’s a stress-reducing development enhancement that I think will improve our ability as FileMaker Developers to write scripts. Undo/Redo gives developers a lot more freedom to experiment with code, without having to carefully manage the editing to avoid trashing existing code. When a refactoring doesn’t work as expected you can simply undo the change and get back to where you were. This new feature will even help you avoid embarrassing situations.

That said, it is helpful to understand exactly how FileMaker has implemented the script Undo/Redo so that you understand the capabilities and limits of the feature. I suggest you fire up FileMaker 15 and explore each of these points, hands on, as you read. Please also take a look at FileMaker’s documentation regarding this new feature.

Continue reading Freedom to Experiment – FileMaker 15’s Script Undo/Redo

SSL Certificates with FileMaker 15: Part I

secure data pipes with SSL; photo by Lon Cook
lock down your data pipes with SSL; photo by Lon Cook
Intro: SSL Basics

SSL certificates are a very common way to secure client/server network connections, and the FileMaker platform has made use of them for many years. With version 15 however, FileMaker has made a number of security changes, in handling SSL and certificates, on both the server and the clients. But where do they come into play, and how might this affect your deployments?

Continue reading SSL Certificates with FileMaker 15: Part I

Performance Optimizations Make Compelling Case for FileMaker 15 Upgrade

rapid mass transit; photo by Lon Cook
rapid mass transit; photo by Lon Cook
Small Gains: Big Impact

In the transit-planning universe, planners and economists often get excited about 5 minutes shaved off of a 30-minute bus ride. The individual rider might shrug at a mere 50 minutes saved per week, but the planners and economists multiply that 50 minutes by the number of people who ride that route during a typical week and see something much bigger. There’s a compounding effect: it doesn’t take long before these small gains in efficiency add up to a huge economic impact overall.

What’s this have to do with FileMaker, you ask? Well, the new FileMaker 15 is now available, and the inevitable question comes up “should we upgrade?” Sometimes the best discoveries when a new version of FileMaker hits the shelves are the “sleeper” features and under-the-hood improvements. In the most extreme cases, these go entirely undocumented by FileMaker Inc.; such is the case with the improvements in portal performance that accompany the FileMaker 15 release.

Portals being a very important part of the FileMaker user interface, anything affecting their performance, good or bad, is going to have a major impact on the user’s experience. Users of a database application often spend large chunks of their workday in the application, so, like that 5 minutes shaved off the bus ride, small efficiencies add up through the same compounding effect. And, as you’ll see, this one is a “big” small efficiency!

No, I’m not talking here about the new, threaded portal rendering (aka “inline portal progress bar”) that is a key public feature point for FileMaker 15; I’m talking raw performance optimization. So impressive is this optimization, in fact, that I never even saw the new inline progress bar during my testing!

Continue reading Performance Optimizations Make Compelling Case for FileMaker 15 Upgrade