Example

Marvelous #4

Marvelous Optimization #4 – Optimized Again

January 26, 2012

Last September I wrote an article about a custom function that I optimized to evaluate hundreds times faster. At the end of the article, I challenged my readers and myself by claiming that the already optimized custom function can be optimized even further. Do you remember? Later on I actually really optimized it again, and [...]

Read more →
Marvelous #3

Marvelous Optimization #3 – Faster Imports

December 11, 2011

This example demonstrates that even a single-step script can be optimized. You just have to think a little bit out of the box… I was showing this as a surprise in my session Marvelous Optimizations at Pause On Error [x] London 2011. I used a sample file with 25 fields and 5,000 records and imported these records [...]

Read more →
Marvelous #2

Marvelous Optimization #2

November 10, 2011

The second example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011 was the script for selecting Random Set of Records. I found this example in the FileMaker Knowledge Base and optimized it to run at least 158 times faster when selecting 10 random records out of 50,000. This version of [...]

Read more →
Marvelous #1

Marvelous Optimization #1

November 7, 2011

This is the first example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011. I already wrote about this optimization some time ago. It’s the one that led me to unveil the Marvelous Optimization Formula. You can find the original article here: FileMaker Script Execution Time Cut From 5 [...]

Read more →
Dice

Random Set of Records (optimized)

September 29, 2011

I noticed that one of the articles updated in the official FileMaker Knowledge Base on September 23, 2011 was explaining how to select a random set of records in a FileMaker database. I was wondering how fast the currently recommended technique is and whether I can make it faster with the help of FM Bench. I tried [...]

Read more →
HTML Entities

FileMaker Custom Function for HTML Entities

August 29, 2011

Just today I needed to decode HTML encoded text in FileMaker. I thought this must have been done many times before, so I tried to search for a suitable custom function at BrianDunning.com and FMFunctions.com. After checking few functions I found one that seemed pretty good.

Read more →

Infinite Hierarchy

March 29, 2011

Last week Hal Gumbert mentioned on Twitter that he was “working on a FileMaker quote to display and edit a BOM ( Build of Materials ) that can go 9 levels deep.” Probably the most efficient and user friendly way to implement this is using a tree view with collapsible/expandable items. This is nothing new [...]

Read more →