Insights from Gearbox

"Anyone who stops learning is old." Henry Ford

Nov 23 2020

AWS S3 + FileMaker Integration

by Michael Layne

We expect... Attaching files, sharing documents, uploading images... it all sounds pretty straight forward. The reality... It's often difficult to accomplish from a development perspective, and even harder to make easy for users. We've been sharing some successful integrations we've recently done for some of our...

Oct 20 2020

The Benefits Of Using REST Instead Of SMTP In Your App

by Michael Layne

Email can be hard. Keep it simple by using standards and services specifically designed to easily send email from Claris FileMaker or anywhere else. We've been sending email for a long time. You may be surprised to know that the first email was...

Sep 22 2020

Ariba + FileMaker Integration

by Michael Layne

In this video, Michael Layne and Marty Thomasson of Gearbox talk about the experience they had integrating SAP Ariba with a custom workgroup solution. As you'll hear, the client had some real world constraints that prevented a direct API integration. Gearbox worked with the...

Sep 03 2020

CargoWise + FileMaker Integration

by Michael Layne

We have a client in the Logistics space with a focus on moving fine art all over the world. Let's say you have a $7 million (or $70 million) Monet you would like to loan to the Petit Palais in Paris for 6 months for...

Aug 19 2020

NEMSIS Integration with FileMaker

by Michael Layne

Here's a not-too-deep dive into an integration success story. We have a client in the Emergency Medical Services industry operating 200 ambulances across much of their state. The Problem In this industry, as you might expect, local, state, and federal government regulations exist and must...

Aug 17 2020

A Snackbar Widget for FileMaker

by Michael Layne

I spend a lot of time doing straight web development  and sometimes FileMaker isn't even part of the picture. I also spend a lot of time developing on the Claris FileMaker platform and when I do, I often want to implement features and behaviors that are were simply more...

Jul 28 2020

ShipStation Integration with FileMaker

by Michael Layne

Here's a not-too-deep dive into an integration success story for a client. They are in the apparel and promotions industry with a concentration on fulfillment and distribution. The Problem Like many companies, they have several disparate systems they have to manage in order to run their...

Apr 22 2020

How I got into FileMaker

by Michael Layne

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 business. The accounting software was fine...

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...

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...

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...

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...

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...

Nov 12 2015

A Smart Way to Export Field Contents - Part 2

by Michael Layne

We love sometimes like Selector Connector Since 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...

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 Problem As 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...

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...

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