Filemakerhacks - filemakerhacks.com - FileMakerHacks
General Information:
Latest News:
Benford’s Law 12 Aug 2013 | 02:52 pm
A common exercise in freshman courses on statistics and probability is to divide the students into two groups, let’s call them A and B. Each student in group A is instructed to flip a coin 100 times a...
ForgetSummary() 29 Jul 2013 | 04:46 am
One of my favorite FileMaker functions is GetSummary; I use it frequently, and it had never occurred to me that there might be any alternative. Recently, however, Mikhail Edoshin pointed out on the FM...
PDF Catalog with Table of Contents 14 Jul 2013 | 08:16 am
Recently I was asked by a client whether we could produce a PDF catalog from his company’s database, with products grouped by manufacturer. Me: “Of course, this is FileMaker.” Him: “Can it have a tabl...
Running Total in Reverse 1 Jul 2013 | 11:26 am
I got a request the other day to show a running balance in reverse order in a portal, in other words, from oldest at the bottom to newest at the top. Surprisingly, FileMaker does not provide an obviou...
Weekly Sales Comparison Charts 24 Jun 2013 | 09:57 pm
If you are responsible for helping business decision makers analyze data, you are probably familiar with questions like: Are we on track to meet or exceed last year’s sales totals? How is our sales te...
Radical Separation, part 4 11 Jun 2013 | 11:17 am
Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. FYI: In March at the Portland PauseOnError u...
Fast Grid Displays on a WAN 28 May 2013 | 10:03 am
Last October I began a series on Outer Joins, which explored a number of different ways to display summarized information in a grid, and at the time I concluded that the “fastest” method was to levera...
Radical Separation, part 3 14 May 2013 | 08:31 am
Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. Today we’re going to delve further into the ...
Radical Separation, part 2 3 May 2013 | 11:35 pm
Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. In part 1 of this series, we defined radical...
Outer Joins in FileMaker 12, part 3 17 Apr 2013 | 11:38 pm
I’ve said before, and no doubt will say again, that one of my favorite things about this blog is how much I learn from your feedback and the demo files you send me. Recently I received a file from Otm...
