Why It’s Always Good to Test Things with the Current Version of Software (When Writing a Blog Post)

While working on the third installment of Fun with FileMaker Button Bars, I was served a reminder of why it’s good to test the stuff you write about using the latest software updates (even if they just arrived that very morning).
Continue reading “Why It’s Always Good to Test Things with the Current Version of Software (When Writing a Blog Post)”

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

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.

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

InspectorPro 6

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”.

Continue reading “InspectorPro 6”

Export Just What You Need in FileMaker

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

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”.

Continue reading “Recycle Your Data | Save Space and Money”

Fun with FileMaker Button Bars, Part 2: Expert Panel

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.”

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

FileMaker Collaboration, Performance & 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.

Continue reading “FileMaker Collaboration, Performance & Insight with InspectorPro”

Building Native Mobile Apps with FileMaker Data

Ever wonder how you might be able to create a mobile app with data you already have in your FileMaker solution? I have, too! As it turns out, it’s not too outlandish of an idea thanks to the FileMaker Custom Web Publishing with XML API.

Continue reading “Building Native Mobile Apps with FileMaker Data”

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

Introduction

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.

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

SSL Certificates with FileMaker

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. Starting with version 15 however, FileMaker introduced 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”

Performance Optimizations Make Compelling Case for FileMaker 15 Upgrade

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.

Continue reading “Performance Optimizations Make Compelling Case for FileMaker 15 Upgrade”

iBeacons – Improve the Ranging Experience

FileMaker gave us the ability to integrate iBeacon technology with the release of FileMaker 15 last month. This is a great way to enhance existing apps with microlocation features as well as build entirely new apps to solve problems we couldn’t solve before.

Some potential app ideas that have been floating around in my head include:

Continue reading “iBeacons – Improve the Ranging Experience”

Speeding FileMaker Performance with Truncate Table

Managing Data You Use and Throw Out

We develop FileMaker applications because we want a place to store information for the long term. We track events, tasks, contacts, finances—FileMaker can track almost anything. To update information, the application might ingest a spreadsheet.

Continue reading “Speeding FileMaker Performance with Truncate Table”

Mask Data with Concealed Edit Boxes in FileMaker 15

Solving an Old Problem

When you consider how to keep information safe, you might first imagine a team of hackers in a dank basement typing and clicking their way into your bank account.

Continue reading “Mask Data with Concealed Edit Boxes in FileMaker 15”

Fun with FileMaker Button Bars: Check Please

Fun with Button Bars, The Series

In recent years, design, has become such an important aspect of what we do; luckily FileMaker has responded with a much improved design surface. With themes and styles, conditional visibility, SVG icon support, and new layout objects, we can now use design and color to communicate with users in ways not previously possible (see, for example, the “Priorities” example in the accompanying demo file).

Continue reading “Fun with FileMaker Button Bars: Check Please”

Excel formatting and charts from FileMaker using XlsxWriter

If you’ve developed solutions with FileMaker for any length of time, you’ve almost certainly created files using FileMaker’s native Excel exports. Although quite useful, this feature gives almost no control over the formatting, and definitely no way to set formulas, charts, or even text formatting.

Continue reading “Excel formatting and charts from FileMaker using XlsxWriter”

JavaScript-driven PDF Reports in FileMaker using AngularJS

Introduction – Extending FileMaker with JavaScript

Using a combination of AngularJS, HTML5, CSS, WKHTMLTOPDF, PDFtk, bBox and FileMaker scripting, we can create PDF reports from a FileMaker solution, taking advantage of the design and development flexibility afforded by using JavaScript and web tools to accomplish the task.

Continue reading “JavaScript-driven PDF Reports in FileMaker using AngularJS”

Installing xhtml2pdf on OS X

Xhtml2pdf is a cross-platform Python module that allows easy conversion of HTML or XML to PDF files. Its dependencies, ReportLab & Pisa, also have a host of very useful functions, including programmatically creating or modifying PDF content & creating barcodes.

Continue reading “Installing xhtml2pdf on OS X”

FileMaker Log Files: Episode VII – PSoS Awakens

Now more than ever we’re relying on Perform Script on Server (PSoS) to maximize FileMaker performance, so naturally a need arose for a way to proactively monitor how many concurrent scripts are being triggered. This type of logging helps us see if we’re reaching our maximum limit, or have a rogue script eating up processing power.

Continue reading “FileMaker Log Files: Episode VII – PSoS Awakens”

FMAjax and FileMaker Web Viewers

With everything that we’ve learned with our last post, Communicating with a Web Viewer in FileMaker, it makes sense to wrap up the functionality into a FileMaker module and JavaScript library.

Continue reading “FMAjax and FileMaker Web Viewers”

1 2 3 4 5 6