Event.log

Debugging Scripts by Writing to Event.log

October 17, 2011

This is a fresh story of me spending hours trying to fix a technical issue and accidentally revealing a gold nugget. A few days ago one of my nightly server-side scripts stopped working without any apparent reason. But when I tried to run the script in FileMaker Pro it worked just fine. I really needed [...]

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 →
Custom Function Optimized

Custom Function Optimized to Evaluate Hundreds Times Faster

September 14, 2011

Two weeks ago I wrote an article about a FileMaker custom function I needed to preprocess some data imported from the web. I used this custom function in an auto-enter calculation to immediately preprocess the data while being imported. I created a server-side script that does the import every morning. But when I discovered that [...]

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 →
Thumbnail image for 5 reasons for not attending FileMaker DevCon

5 reasons for not attending FileMaker DevCon

July 18, 2011

To attend or not to attend? That’s the question I am asking myself every year since 2002 when I attended my first FileMaker DevCon. I have attended 8 DevCons so far, and skipped one. I have identified the following 5 possible reasons for not attending:

Read more →
Thumbnail image for Mac OS X 10.7 Lion – Upgrade or Wait?

Mac OS X 10.7 Lion – Upgrade or Wait?

July 13, 2011

Everyone is excited about Lion. Even though many new features on Mac OS  X 10.7 are giving us improvements we kept asking for since 10.1, Apple has again succeeded in giving all the new features the strong essence of innovation that makes us unable to hesitate to install and try Lion out as soon as [...]

Read more →
Thumbnail image for PHP Debugging & FileMaker Custom Functions Do Exist

PHP Debugging & FileMaker Custom Functions Do Exist

May 25, 2011

I have just read Anders Monsen’s post A Simple Debug Function for PHP at the Mightydata’s blog. My first thought was this is similar to what I have been doing since I learned PHP a few years ago. But then I discovered something very bad about myself…

Read more →
Thumbnail image for Blog Moved

Blog Moved

April 27, 2011

I have just finished switching my blog from Posterous to a self-hosted WordPress.org based site. You may have noticed I mentioned this idea on Twitter some time ago. I had mainly three reasons for this change: Posterous did not let me insert JavaScript based widgets, such as live-updating Twitter stream WordPress has a really nice [...]

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 →

FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds

March 17, 2011

Sometimes, not often, I accidentally achieve results that look too marvelous to be real. But they are. Just like in this case. Last week I assigned Petr, our internal system developer, the task to optimize one server-side script. The script recently started taking over 8 hours to run and reaching the expiration limit we have [...]

Read more →