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”
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 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”
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”
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”
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”
Continue reading “FMAjax and FileMaker Web Viewers”
Continue reading “Enable WebKit debugger in FileMaker Web Viewer”
If you need to scrounge through the web server’s logs in the file system, the way FileMaker Server stores these on Mac OS can be a bit annoying. You end up with a bunch of files named like this:
FileMaker Pro 14 includes a new feature to add placeholder text to fields on a layout. What is placeholder text? Simply put, it is a way to put text inside a field when it is empty. This feature is useful for mobile, web and desktop users alike.
Continue reading “FileMaker 14: Field Placeholder Text”
As a FileMaker developer you probably spend a big chunk of your time writing scripts. The new Script Workspace in FileMaker 14 is going to help you in a big way. It’s a breath of fresh air and at first glance it might seem trivial in that we now have colors and we actually can have white space, but there are many other productivity improvements that lurk beneath the surface.
Continue reading “A brand new Workspace!”
The new Button Bar layout object provides developers with an improved method to manage a cluster of buttons that have functional and/or cosmetic similarities.
Continue reading “FileMaker 14 – Button Bars”
FileMaker 14 introduces new controls available in the mobile FileMaker Go app that help to bring the media player experience in FM Go more in alignment with iOS. These changes, compatible only with FileMaker Go 14, include 3 new script steps, 3 new script triggers and 1 new calculation function. In addition, the script step Insert Quicktime has been removed (developers should use the Insert Audio/Video script step, which we have had since FileMaker 12).
Continue reading “FileMaker 14: Audio/Video Control Script Steps and Functions”
For the longest time I thought field labels were something special and there was some sort of connection between the label and the field. So if you have ever created a new field and put that field on the layout with the label to the left of it. Then 10 seconds later you change your mind and decide to rename the field. Presto your label has also been renamed.
Continue reading “The Force “FIELD””
Recently we’ve been thinking about how we can better monitor the collection of systems that we manage. These can be client servers with very diverse configurations, access, or functions. Additionally, we have our own array of systems, almost as diverse as our clients’.
Continue reading “Facter Reporting for FileMaker Server”
To describe this next technique I came up with my own acronym, and I call it "NoSSR", which stands for Not Only Sub-Summary Reports. The goal of this blog post is to show you a way to build and deliver similar results but in a statically defined way. Another way to put it is to architect for performance, so let’s see what can be possible. This post also assumes you know how to build a FileMaker sub-summary report layout already.
Continue reading “NoSSR ( Not Only Sub-Summary Reports )”
There are a number of ways of working with JSON data in FileMaker. At least two typical ones are:
- Custom Functions based parsing & encoding
Continue reading “Working with JSON data in FileMaker”
Various times I’ve needed to do some quick summaries of how a given server and its databases were being used. When using Mac OS X, I may use shell commands to get a quick summary of what’s happening on a particular server.
Continue reading “Summarizing FileMaker Server Access.log data”