Geist Interactive is a sponsor of the CIO/CTO Focus event series in Ventura County California.  The next event will be Feb 19, 2019, and will feature a discussion with leading Chief Information & Chief Technology Officers (CIO & CTOs) from the area. Todd Geist, CEO of Geist Interactive will be moderating the event. If you are CIO or CTO in the area and would like to come, please register using the link below.

Featured Executives

Moderated by Todd Geist, CEO, Geist Interactive


The CIO/CTO Focus event series is intended to bring together local executives for an ongoing discussion about the challenges and opportunities facing technology executives today, especially those who are helping to lead companies with significant business operations in the Ventura County area.  The event will be held 4 times a year at a private home in the Thousand Oaks, CA area.

Register and RSVP

You can register at

Download Flyer – CIO_CTO Focus Invitation

We at Geist Interactive, Barbara, Dave, Lance, Jeremy and Todd (and the ghosts) wish everyone a happy holiday. No matter your celebration plans this season, we wish it to be full of warmth and love and joy.

Thank you for coming along with us as we continue to push what is possible in FileMaker and encourage developers to try out something new.

As a special treat, we are offering an End of Year sale, where every product and package in our store is 20% off.

Use this code: HOLIDAY2018  (colors not necessary) on any purchase and the 20% savings will be applied! It is available now through January 4, 2019, so act fast!

Get yourself or another FileMaker developer one of our products or tools. May we suggest:

  • FMPerception A must have for all FileMaker developers. Its realtime-developer intelligence is unmatched and is extremely useful in your day-to-day development.
  • Implementation packages: Pick up a 3- or 6- or 20-hour package and spend time with one of us to help you through some sticky parts of your solution. We’d be happy to write a few scripts for you as well.
  • Otto. We can’t imagine developing without this tool. Otto is the best tool for migrating files from Development to Production or Development to Staging to Production. It uses the data migration tool.
  • LedgerLink. LedgerLink (formerly fmQBO) is the easiest and most powerful method for keeping FileMaker in sync with QuickBooks Online.

The 2018 year was full of JSON and Karbon and JavaScript and FileMaker for us and for the community in general. Here’s a list of what has happened here and in the FileMaker community.

  • Lance, Todd, and Jeremy spoke at FileMaker DevCon 2018. We also were a diamond sponsor of the event.
  • We released Karbon, our ambitious framework for developing custom apps
  • We defined what we consider to be native FileMaker, and caused quite a discussion about it.
  • FileMaker 17 came out, and with it, features that continue to expand the platform’s limitless possibilities
  • The Workplace Innovation Platform was introduced (our favorite video is “Yoga Balls“).
  • We released a lot of blog posts about FileMaker: Like a Boss, JavaScript, and FileMaker 17.
  • Todd and Jeremy toured the west coast speaking about FileMaker Professional Tools.
  • We released new products: GoDraw3, Editor, Kanban, and have refreshed established ones: LedgerLink and GoZync.

Since we’re in the holiday season, check out Advent of Code 2018. This little event is a great way to refresh your FileMaker development experience. Solve puzzles outside of the normal grind.

And one more thing. Please take a moment to read about One Spark Academy and consider helping this organization.

Here’s wishing you and yours a great holiday season and a prosperous new year. We’re excited about 2019: FileMaker DevCon, FileMaker 18, and more blog posts and techniques, and more pushing what is possible.



In years past many of you FileMaker people have supported our non-profit learning center, One Spark Academy, with an end of the year tax-deductible donation. We are very grateful. This year, due to some terrible tragedies, we need your help more than ever.

Our community of Thousand Oaks was hit hard by two catastrophes in a single day. Families were devastated, lives were lost, and homes destroyed. The community has rallied to do what we can. It has been both deeply sad and wonderful to see our community pull together.  People have opened their homes, their wallets and given freely of their time to try to help.

Memorial for Thousand Oaks, Ca shooting victims.

It has also directly affected One Spark. Luckily, no one in our community lost loved ones or had their house burn down. But the school was used as a command post during the shooting and evacuation center during the fire. It was closed for more than a week. Two of our students’ families were forced to move away because of the devastation in their neighborhoods. Just when kids needed us more than ever we had to keep our doors closed.

We are also finding it very hard to ask for money. How can we ask our community to give more at a time like this? Yet we rely on this fundraiser every year to close the gap between what we charge for the school and what it costs to run it. We still need the money! We have to find it somewhere!

Please consider a tax deductible gift

So I am asking our global FileMaker community for help. If you have been following our school since its founding 8 years ago,  if you just appreciate what we do, or if you want to help our community recover from devastation, please help.  Our kids really need it.

Please visit our campaign page to make your donation.

Thank you!


Todd Geist
CEO Geist Interactive
President Of the Board, One Spark Academy.

Once a year, software developers all over world gather online to compete in the Advent of Code. During the festive and joyous time of the year, geeks race against the clock to solve coding challenges using their platform of choice, to be one of the first to solve it in as little time as possible. It’s a stressful and panicked time, this end of year tradition. Happy holidays.

Over 41,000 people started the journey last year, December 1, 2017. Among those were FileMaker developers.

That’s right. Besides being innovators, we are also software developers and problem solvers. Our platform does all that any other platform such as JavaScript or Python or .Net can do. So when I stumbled on this last year and wrote a discussion post about it on the forums, I figured we can be a part of the fun.

Here’s the quick rundown:

  • The site is Register on the site.. Take a look around.
  • Each day of December, two puzzles are released, one after the other. The goal is to read the problem and use any platform (even and especially FileMaker) to solve it.
  • Once problem one is solved, and the answer is submitted to the site, problem two is released. Usually this one builds off of or branches from problem one.
  • There is a leaderboard, and the leaders on the board are determined by the elapsed time it takes to solve the problem.
  • There are example solutions to the problem, given a different starting point. These are used to test.

It was a little exciting

There was a pretty good response from FileMaker developers to this challenge last year. I think because:

  • The puzzles are a nice ‘brain break’ from we work on each day. Advent of Code doesn’t have us building card windows for new records or have us determine the fiscal year. I daresay the puzzles in the game have nothing to do with real life, and for some, that is great. The challenges exercise a different set of skills for us.
  • The small group of folks who participated shared their ideas. We supported each other without judgement.

A Puzzle from Last Year

Unfortunately the method I chose to talk about this wasn’t useful. Scattered among the main questions and discussions in the community were posts for each day of the challenge. Those got lost, and there was no good way to really talk about it.

Do it better

So this year, we’re going to try something a bit different. I’ve been thinking of this for awhile, and, it turns out, so has Mr.Watson-gbs. (Great minds, and all that). Here’s what we have for this year:

  • A separate community place (coming soon) that you can be a part of (or not) and follow (or not). Thank you Rosemary for this separate space.
  • Mr. Watcon-gbs has a template file that we can use (though there’s no requirement. Use your own if you wish).
  • For each day of puzzles, a document containing the text and translation of the text will be posted. Likewise, a discussion for each day will be posted.
  • On the discussion you can post your own solution to the problems. You can ask for help, talk with each other about their solutions, etc.

We’ll basically work together to solve these puzzles.

Additional thoughts

  • Register to the Advent of Code site and post your answers, track your progress, and view your place on the leaderboard, as much as you wish.
  • There will be no official leaderboard in the community for a few reasons:
    • 1. I don’t have any mechanisms to test each answer and get the timestamp, and
    • 2. this competition is not found in the FileMaker forums. There’s nothing at stake here. There’s no reward save for the utter enjoyment of solving puzzles with your fellow FM developers
  • Ask for help about a puzzle, get feedback on your method of the solution, and critique others’ solutions. But that’s as far as we’ll go. There will be no judgement.
  • Again: ask for help. Though many FileMaker developers will post their answers, ask for help if you’re struggling. Don’t just open someone’s solution and copy it. Try to reason through it and ask for guidance in that process.
  • This space will be around (as well as the puzzles ) for a long time, so feel free to come back to a day and try them out well after the festive month has ended. Feel free to bump the topic and revive the conversation.
  • Feel free to try out the puzzles of 2017. They’ll give you some idea about what to expect.
  • Use any programming language you want; FileMaker is not required. In fact, I strongly encourage the use of other languages; I’d love to see how these are solved in Java, for example. If you could help the rest of us out and make it so we can see the code and run the code, that would be great.

I encourage you to join the group as we talk Advent of Code puzzles. What I’m excited about, what dawned on me about a year ago, is that we can do these puzzles in FileMaker. We can, along side Java, C++, JavaScript, Basic, and Fortran programmers, find solutions to fun problems. I really don’t think it takes an expert FileMaker developer to do these. Anyone can participate.

Let’s talk about the puzzles together, let’s critique and discuss. I think this is a way to make us better in our craft: take on some challenging puzzle and attempt to solve it in our language.

I’m committing to working on each puzzle every day, though I probably wont get up the second each day’s puzzle is released to be the first so solve it. I’ll use FileMaker, and, if time, JavaScript (I love JavaScript).

You have a month to prepare, to test out some puzzles from last year, and to get yourself ready.
See in Advent of Code 2018!

TODAY  – 10/22/2018  – 6:30 PM Pacfic!

Next Monday ( October 22 ) Geist Interactive will be hosting the San Diego FileMaker User Group at our office in San Diego, if you don’t live in the area and still want to attend, you can join us via Facebook Live on our Facebook page.

We are going to attempt something interesting.  This is not just a webinar, or Go To Meeting. This a multi-camera Live Streamed event. We’ll have a  “director”, who will be able to switch between multiple camera angles and the presenter’s screen to provide the best view of what’s happening at the event. If everything goes well it’ll be like a TV show with a Live Studio Audience.  We’ll also take questions from the online crowd via Facebook Live.

Last Of the West Coast Tour

This is the final leg of our 2018 West Coast Tour, where we have been talking about Power Tools for The FileMaker Workplace Innovation Platform.  Here are some of the topics we have covered in the earlier shows.

  • JavaScript Intro and mini-workshop
  • Karbon – our free Ambitious App Starter.
  • Otto –  Fully automated data migrations
  • LedgerLink – Connect to Quickbooks from FileMaker

Watch the Live Stream

The Live Stream will start at 6:30 PM Pacific Standard Time. October 22nd, 2018. Join us on our Facebook page.

Attend in Person

If you are in the area please come in and be part of our studio audience. We gather for food and drink starting 5:30 PM at our office in San Diego.  The presentations will begin at 6:30 PM


Geist Interactive
1855 1st Ave Suite 103,
San Diego, CA 92101

I’m sitting here at the Denver International Airport, heading to Seattle for what begins the Geist Interactive West Coast tour of FileMaker user groups. I’m thinking of innovation, specifically innovative power tools and techniques that we have access to as FileMaker developers. Already an innovation platform, FileMaker continually expands, opening the door to more. I can’t wait to talk about the FileMaker power tools in  which I’ve invested my time.

Workplace Innovation Power Tools

Todd Geist and I (Jeremy Brown) are traveling north to south along the coast to talk Innovation power tools and frameworks and techniques:

WorkPlace Innovation Platforms, like FileMaker grow along with you. The more you learn the more powerful they become, allowing you to build more and more powerful systems. Eventually you may find yourself with a custom application that provides significant value to your company or organization. Maybe you didn’t start out wanting to be a professional application developer, but if your application has value, guess what? You are a Professional.

Todd Geist and Jeremy Brown of Geist Interactive are coming to Seattle to talk about Professional Development tools, practices and techniques. Todd will demo Geist Interactive’s latest pro tool, Otto. Otto provides fully automated File and Data migration. He’ll show how easy it is to migrate a complex solution from Development to production environments. Jeremy will review the current state of JavaScript in our FileMaker development and lead us in a workshop to implement a JavaScript library quickly in a custom app.

Sounds exciting, huh?


It really is exciting. As FileMaker developers we have access to power tools within the Workplace Innovation Platform. We can build frameworks, and use those frameworks our custom apps. And we can utilize new techniques to keep our custom apps modern and connected to the world.

I’m excited to share about JavaScript, which, as you know, I enjoy playing with and promoting. By the end of our discussion, you’ll be hooked on JavaScript and look for ways to innovate with it in your custom apps.

The Stops

We will make a tour of the West Coast user groups starting north.


If you’re on the West Coast and within traveling distance of these user groups, and if you want a review of Workplace Innovation power tools, frameworks, and techniques, then please join us for one of these. Feel free to join us at all of the meetings. We’ll take the train from Seattle to Portland, and then fly the other legs.  Come on. Join us for a great week of the awesome Workplace Innovation Platform called FileMaker and some Power Tools, Techniques, and Frameworks.


Download these links for access to the demo files we’ll show tonight:


Web Viewer Integrations.fmp12


The team here at Geist Interactive is hard at work, adding new features to LedgerLink. They recently added support for online payment processing using Quickbooks Online’s processing APIs. Barbara Cooney walks us through that feature here.

Key Points

  • LedgerLink never records or stores credit card or bank account information during the authorization process. Sensitive financial information is sent directly to Intuit’s servers. It never makes it to the FileMaker Server, nor is it written to disk anywhere. This relieves you from ever having to be responsible for properly storing credit card or bank account data.
  • Rates for the online processing are very reasonable. Quickbooks Online has that information.
  • Quickbooks Online’s documentation explains how to set up your account to use online payments.
  • In LedgerLink’s setup, the “Allow Payments” box needs to be checked.

You can read more about how to use online payments in LedgerLink and Quickbooks Online here. Download the demo and give it a try.


Last Thursday, we held our first-ever webinar that focused on Karbon, our Framework for Ambitious FileMaker Custom Apps. We briefly touched on Karbon’s purpose and position, Karbon’s data model, and Karbon’s API integration. We also spoke about our tool Generator that helps us generate 95% of the code needed for Karbon. Finally we looked at testing in Karbon and one specific integration with LedgerLink and Quickbooks Online.


The webinar was about 1 hour and 20 minutes. Here’s a breakdown of the main points:

  • 0:00:00–Welcome and introduction to Karbon.
  • 0:06:49–Getting started in Karbon
  • 0:09:45–Separation of concerns in Karbon
  • 0:14:45–Karbon’s data model
  • 0:22:12–Example API integrations
  • 0:28:50–Karbon  API scripts
  • 0:37:25–Karbon transaction logging
  • 0:39:31–Karbon Generator
  • 0:48:48–Karbon testing
  • 1:01:00–Karbon and LedgerLink
  • 1:05:29–How to participate
  • 1:07:16–Q & A

You can participate

As Todd mentioned in the webinar, you have the opportunity to participate. We’ve got three ways that you can get involved:

  1. Provide feedback and features.  We want to create an ecosystem of discussion around this framework to discuss ideas and features about Karbon. There’s great thoughts out there in the community, and we want to know those.
  2. Pay us to add features.
  3. Become a Patron. Support us through Patreon so that we can hire someone to work exclusively on Karbon.


We are excited about Karbon. It is ambitious for complex custom apps, and we think it is sorely needed in the community. We all need a framework from which to start. Karbon is it.

Stay tuned to Karbon’s main page for more information, more videos, and more excitement about Karbon.


Our QuickBooks Online connector product fmQBO is now called LedgerLink. It has lots of new features and security enhancements. Because of changes that are coming in 2019 and beyond we will need everyone to migrate to this version sometime in the next 6 to 12 months. Even though most people have a year to make this transition, we recognize that this might be inconvenient, so we are offering a package deal that includes a free year off LedgerLink and having us do the migration for you.

Whats New With LedgerLink

No More Plugin

First, there is no more need for the Base Elements plugin, and there is no locked code of any kind. Everything is open and available for you to see and learn from. Everything in LedgerLink is native FileMaker code.

More Built in Syncing Tables

We have built in sync support for many more Quickbooks Tables then before.  The list of QBO tables that LedgerLink works with now includes: Items, Customers, Invoices, Terms, Tax Codes, Company Info, Tax Rates, Accounts, Preferences, Payment Methods, Payments, Classes, Departments, Bills, Estimates, Journal Entries, Purchase Orders, Vendors, SalesReceipts, and  Attachments.

Credit Card Payments and ACH Withdrawals

LedgerLink has built in support for processing Credit Cards and making Bank withdrawals with Quickbooks Online Payment processing. Charging a Bank Account is free.  Thats right zero processing fees. You just need to have Quickbooks Online Payments already enabled in your QuickBooks Online Account.

Developer Incentives

If you are a FileMaker Developer, it is now easy to purchase multiple LedgerLink connections that you can use with some or all of your customers. You get the ability to manage and control their access to LedgerLink features. Easily add value to all your custom FileMaker Applications

New Authentication

LedgerLink is is built using the latest QuickBooks authentication scheme based on OAuth. The older scheme used by fmQBO v1 and v2 will be phased out over time.

End of Life

fmQBO v1 will reach it’s end of life on Mar 31st, 2019. fmQBOv2 within 9 months after that. Both Intuit and FileMaker are pushing forward with new and important changes to their respective platforms, and we are trying to be as proactive as possible to help people prepare for whats coming. We recognize that this might present some difficulties for some people people. This is why we are giving such a long lead time and providing a service to perform the migrations for you. We hope that this helps everyone make the transition.

Can I Do the Migration Myself?

Yes, but there will be some manual work to do.  If you have a working fmQBO integration most of the hard stuff has already been thought out.  You will simply need to follow our integration instructions. If you were able to do it the first time, you should have no problem doing it this time. We’ll apply any unused time on your subscription to the new LedgerLink purchase.

If you would like us to do the migration for you see the next section.

Migration Offer: $2000 Off!

If you have Items, Customer, and Invoices in your system we will convert your system to the the new LedgerLink and give you a free year off the connection fee for LedgerLink for $3499. AND If you act before October 31 we’ll give you additional $1000 off bringing the cost down to just $2499.

Normally this work would require a 20 hour implementation package plus the license bringing the total regular price to $4500. If you act by October 31, 2018 you will get a $2000 savings.

If you act after the October 31st deadline you’ll still get a $1000 savings. You only need to put down a $500 dollar deposit to hold your special pricing. You do not need to have everything done by October 1st.


This offer is only good for customers with existing fmQBO integrations and only includes integrating Invoices, Customers and Items. If you have have other QuickBook entities we can provide an estimate for the cost of those additional entities. If you are new to LedgerLink/fmQBO we’ll be happy to provide you with custom integration services implementation package.

How To Get Your Special Offer.

Simply email us at and ask for the “LedgerLink Migration Package”. We’ll get you started from there.

For more information on LedgerLink, please visit the LedgerLink page.

Please email with any questions.

It is always good to know how to get started with any product. And in this video, Barbara Cooney takes us through how to do just that with LedgerLink.

Follow along with Barbara as she helps you get started using LedgerLink:

Key Points

  • Obviously, you need to have a LedgerLink license. We have a demo license to test it out, or you can test it out.
  • You need to enter a  Master Admin account when logging into Quickbooks Online in order to connect LedgerLink.
  • After logging in, you’ll be given a list of your companies. After selecting one of them, that company information is brought into Ledger Link.

Common Mistakes Include

  • Trying to connect to Quickbooks Online with an account that doesn’t have Master Admin privileges.
  • Use Sandbox option. The sandbox comes from Quickbooks Online, and it’s used to test. You might not have a sandbox account, so be sure to uncheck this.

After the initial connection

There are two options for using LedgerLink:

  1. Use LedgerLink to store data as a starter file.
  2. Use LedgerLink to act as a bridge between Quickbooks Online and your custom app. Basically, use LedgerLink for its sync engine.

LedgerLink Configuration

Head to the “Sync Config Log” screen. This is the place to mark what you want to send-to and receive-from Quickbooks Online. All of the entities in LedgerLink can be either sent or gotten or both. Review this section to see which entities apply to your needs and uncheck those that don’t.

Read more information about LedgerLink here. Download the demo and give it a try.