Category Archives: FileMaker

Fun with FileMaker Button Bars, Part 3: Tips for Designing Great Icons

Fun with Button Bars header image - detail of magnifying glass

In Part 1 (“Check Please,”) and Part 2 (“Expert Panel,”) of this series, we had some fun doing things with button bars that showed off some of their unique usefulness within the FileMaker design-layer toolbox. Often as not, your button bars are going to include icon labels, with or without a supporting text label, and you want those icons to look great.

In button bars, you want a consistent visual weight across all the segments, and in both button bars and standalone buttons, you want icons that look crisp on both high-resolution (“Retina”) and standard-resolution displays. This article will help you achieve both of these goals.

Continue reading Fun with FileMaker Button Bars, Part 3: Tips for Designing Great Icons

Debug Apache on a FileMaker Server

Since FileMaker Server version 13, FMS has used its own Apache configuration files on macOS instead of just adding includes to the OS configuration files. Because of this, the technique I mentioned here no longer works for newer systems. This new arrangement has reduced issues for FileMaker Server’s web connectivity. But updates or other changes can still cause the httpd process to fail to start up, and all you’ll see is something like this in the system log:

Jan 18 13:13:14 myservername com.apple.xpc.launchd[1] (com.filemaker.httpd.start[574]): Service exited with abnormal code: 1

Continue reading Debug Apache on a FileMaker Server

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

Recycle Your Data | Save Space and Money

small girl on large rock climbing wall
climb (smaller) mountains of data ; photo by vincenzo menanno

A few years ago, I worked on a FileMaker project where the client told us that every week they need to import about 7,000 rows of data that represent some information that this company uses. And every week there might be some modified records, some records that don’t show up any longer, and some new records that hadn’t already existed. For this example, let’s just call it this data “Products”.

Over the years that weekly information grew to about 12,000 records per week. This PRODUCT table itself had 35 fields of data. So, without a way to manage the duplicates, every week lots of redundant data would need to be imported.

Continue reading Recycle Your Data | Save Space and Money

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

FileMaker Client installers with FileMaker Cloud

If you purchased your FileMaker Cloud server with user connection licenses,  you may well wonder “Where do I get the client software to connect to my server?”.

Continue reading FileMaker Client installers with FileMaker Cloud

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?

Using an AWS Reserved Instance with FileMaker Cloud

We’ll discuss how you can use a one or three year reserved instance for your FileMaker Cloud instance. This can shave 30% or more off your AWS instance charges.

Continue reading Using an AWS Reserved Instance with FileMaker Cloud