Developer’s have been able to run SQL queries against their FileMaker data for many years. In the early days it required a 3rd party plugin, but since version 12 we’ve been able to run SQL Select statements against our FileMaker data with the native Execute SQL function. RazorSQL can be a big help.
FileMaker 17’s new ‘Master Detail’ interface object allows the user to see and interact with a portal of the current found set and the detail of a single record at the same time. It can be very helpful in allowing the user to work with their data in a detail view, while staying in the context of a list of records. It’s easy to implement and even easier for users to navigate. Though the portal is handy when it’s being used, it’s often taking up valuable real estate when not in use. So, we’ve developed a helpful enhancement on the basic Master Detail implementation that utilizes the slide-control panel to show and hide the Master Detail portal when not in use, while still allowing quick access when it’s needed.
When working with multi-file solutions in FileMaker, sharing variables can be a stumbling block. In this blog, I will explain the process we chose when we built the Button Bar Sort Headers solution. It is one of my favorite techniques for sharing variables when they are needed for field calculations.
Aggregate Functions are the lifeblood of data analysis. However, aggregate functions can often be a little confusing. Things like variable field references, single constant values, or calculating empty values can all cause confusion if you are not familiar with the nuances of aggregate functions.
The FileMaker community’s big conference every year is the annual Devcon sponsored by FileMaker Inc (this year in Orlando) and our main unconference is Pause on Error, a new edition of which was recently announced for Tulum Mexico in early April.