The Gearbox Blog

We write so you can learn from us and we can learn from you.

Apr 22 2020

How I got into FileMaker

by Michael Layne

How did I get into FileMaker? 1993 I was living in Vancouver, BC in 1993 working for a small bar code manufacturing company based in the US and was responsible for the P&L for Western Canada. We had a Macintosh Classic II with a handful of applications to run the...
Mar 20 2020

COVID-19 Doesn't Stop Gearbox Founder

by Michael Layne

The Background On March 13, 2020, our founder and leader, Marty Thomasson was supposed to board a flight destined for Auckland New Zealand on his way to Papua New Guinea. As some of you may recall, Marty has spent some time with the doctors and volunteers of YWAM serving on a medical...
Jul 03 2019

A Simple FileMaker While() Example

by Michael Layne

Thanks for the While() FileMaker 18 has provided a new function that can transform what we can do within the calculation engine. There are several articles that explain the function such as these from Geist Interactive, AppWorks, Skeleton Key, and more. Not Hello World I get the Hello World thing when...
May 07 2019

Transactions + MVC + Party Model in FileMaker.

by Michael Layne

We've been busy working on one of the largest solutions we've ever developed here at Gearbox. Thank goodness for this platform and the community around it. We're still learning new techniques all the time. Over the past several months, a large new project forced us to challenge ourselves and ask...
Dec 14 2018

Remembering tabs or panels across FileMaker layouts

by Michael Layne

In a recent discussion with another FileMaker developer, we were singing the praises of the popular Browser Navigation module from Paul Jansen. We've been using it for a few years now and I see it more all the time. It's also used in Geist Interactive's open framework, Karbon (Github). How...
Sep 12 2018

Passing Parameters with FileMaker + JSON - Still Evolving

by Michael Layne

In the Beginning... A long time ago, we didn't have the ability to pass values around like we do now. At least some of us remember those days... I was among the masses that took Geoff Coffey's lead and started using custom functions to pass multiple parameters over a decade a...
Jul 31 2016

A FileMaker DevCon to Remember

by Michael Layne

2016 is a special year for Gearbox. Andy LeCates, Director of Sales and Solutions Consulting at FileMaker, Inc. demos a mobile app designed and developed by Gearbox for a medical ship in the South Pacific. The story began in June of 2015 when Gearbox founder and CEO Marty Thomasson spent two weeks...
Nov 12 2015

A Smart Way to Export Field Contents - Part 2

by Michael Layne

We love Selector ConnectorSince the initial news of this new technique from Todd Geist and Jason Young's smashing session at DevCon this year, we've been incorporating it into most of our solutions. If you haven't seen Part 1 discussing how we improved the ability to download files from container fields with...
Nov 11 2015

A Smart Way to Export Field Contents - Part 1

by Michael Layne

A little collaboration is always a good thing (and it's nice to work with smart people)... The ProblemAs a FileMaker developer (citizen or otherwise), have you ever had a need to export from multiple container fields within a system? We wanted to be able to export files from disparate container...
Jul 30 2015

Column Selection in FileMaker 14

by Michael Layne

First off, kudos to FileMaker for releasing one the best updates to the platform I can recall. The Script Workspace is practically in the present in terms of some features. I spend most of my time in Sublime, so I know what a modern editor looks like. While updating some...
Jan 15 2013

Evolution of a FileMaker Layout

by Michael Layne

Here's a quick view of the progress over the years of a solution that has been around since FileMaker 4. I didn't get introduced to it until the Spring of 2006, but the relationship still continues. Under the Hood We've tried to maintain a balance between UI updates and improvements in the...

We use Teamwork for project management. If you are a client and have on ongoing project, login here.