San Diego FileMaker

San Diego FileMaker Meetup at our New Office

Geist Interactive’s Custom Software Development team has moved into our new San Deigo, CA. office. We are very excited to have our new hub but, it’s more than just an office to us. It’s also an opportunity for us to help support the San Diego FileMaker community, by using our facility has a location for the local user FileMaker user group and other meetups. We’d like to invite you to come by for a little celebration and San Diego FileMaker User’s Group meeting.

Read more

Generator – Connect FileMaker To The Web

Geist Interactive announces first-ever, open source FileMaker developer utility for connecting with web and JSON APIs.

Generator™ makes connecting FileMaker solutions to any other API-supported website or service faster and easier than ever before.

NEWBURY PARK, Calif. – March 17, 2017 – For FileMaker developers wanting a better way to integrate FileMaker custom apps to data from other websites and services, Geist Interactive today announced the availability, Generator™.

What is Generator?

Generator™ is the first ever, open source FileMaker developer utility for integrating with web APIs and JSON elements. It makes it faster and easier to connect your FileMaker solutions to other API-supported websites or services.

“Never before has there been anything like this to help FileMaker developer this way,” said Todd Geist, CEO of Geist Interactive. “Generator will drastically speed development for experienced users while quickly teaching beginning FileMaker developer modern techniques for working with web and JSON APIs. Plus, it’s completely free so anyone can download it right now.”

How does Generator work?

By creating ready-to-use scripts that are pre-integrated with web and JSON APIs, you can quickly and easily connect FileMaker solutions to any supported website or service in 3 simple steps.

  1. Generator analyzes your open database and helps you create a field map between the fields in your database and the data elements in the website or service that you want to connect with.
  2. Once the fields are mapped, you click a button and the ready-to-use FileMaker scripts are generated and added to your clipboard.
  3. Copy and paste the pre-integrated scripts into your FileMaker solution to complete the connection.

Pricing and Availability

For more information on Geist Interactive, please contact:

Todd Geist
(805) 941-0435

FileMaker Top Call Stats Analysis With FMPerception

If you turn on the Filemaker Top Call Stats log, FileMaker Server will log the longest running operations, during a log interval.  It saves up to 25 calls per logging interval. This is a great resource to help find those areas of your database that might not be performing well. But it is difficult to read.  First, there is a lot of data. You’ll need to import it into a FileMaker Database or a spreadsheet to be able to do any kind of sorting or filtering. Second, FileMaker Server doesn’t use the names of elements when it saves them in the log. It uses the internal IDs. This is good for security but it makes it difficult to tell what’s going on.  FMPerception has a new feature that can help you make sense of your log. Read more

fmQBO is Mob of Microservices

What the?  Yeah I know, weird huh?  But it is kind of true.  Okay so maybe not a “mob”. It’s more of a “collection”. Our FileMaker to QuickBook Connection tool, fmQBO is a collection of micro-services that work together to form a larger set of features. The only reason this matters is that it lets us innovate and iterate super fast. Watch the video to see what we mean.

Read more

Happy Holidays & Best of 2016


On behalf of all of us at Geist Interactive including Bella, my American Bulldog, I would like to wish you a happy holiday season – and thank you for all your incredible support in 2016! Woof!

It has been a great year for Geist Interactive, and I’m grateful to have worked with such great clients, talented partners, the staff at FileMaker and developers all around the world.  A few highlights include:

  • The wonderful reception to our “Custom Software is a Right” movement.
    • We believe that people should not be stuck with software that doesn’t do what they need it to.  And that they can, and deserve, a system that is tailor-fit to their business. FileMaker and the development community are delivering on this concept in a huge way, and we are proud to be changing the lives of business owners every day.
  • Participation in the FileMaker Business Alliance Partner Council.
    • The FBA council is made up of nine FBA members from around the world. We meet several times throughout the year to help the team at FileMaker with strategy and product direction. I look forward to many great things in 2017 – stay tuned!
  • Hiring Dave Graham to head up Professional Services.
    • We now have a full-time person responsible for our custom development team!
    • Learn more here ->
  • Launching three new products: FMPerception, fmQBO and Barcode Creator
    • In addition to our custom software development services, we also make add-ons and developer utilities for the FileMaker platform. We finished two new versions this year, and invite you to download free trials if you havent’t already.
      • FMPerception v1.0 the fastest, most-accurate database utility for searching, analyzing and maintaining FileMaker custom apps.
      • fmQBO v2.0 – the easiest, most-reliable method for keeping FileMaker in sync with QuickBooks Online.
      • Barcode Creator v1.5 – The easiest way to generate Barcodes with just Filemaker.
  • Thousands of views of our “JavaScript is Eating the World” video.

A personal highlight is the work that we do in our community. Thank you to everyone who is part of the non-profit education center that my wife and I founded called One Spark Academy.  We’re so thankful to everyone who has contributed to the success of this organization that has helped more than 150 children.  Learn more or donate to our year-end fund drive here:

I wish all the best to you and your families in 2017, and I look forward to connecting with you again in the New Year.

Warm regards,
~ Todd

Todd Geist
Geist Interactive

Geist Interactive announces new version of FMPerception database analysis utility for searching, analyzing and maintaining FileMaker custom apps.

Designed to help FileMaker developers create the highest-quality custom apps – faster and easier than ever before.

NEWBURY PARK, Calif. – December 6, 2016 – For FileMaker developers dealing with perceiving the detailed structure of their custom apps, Geist Interactive today announced the availability of a new version of FMPerception™ database analysis tool.

“Until now, database analysis tools have operated so slowly that they disrupt a developer’s workflow and mindset which is why they don’t get used often enough,” said Todd Geist, CEO of Geist Interactive, one of the leading FileMaker Certified Developers and FileMaker Business Alliance Member.

“FMPerception is by far the fastest FileMaker database analysis utility available, which is why FileMaker developers might literally use it every few minutes – which ultimately helps them create better, higher-quality solutions faster than they ever have before. I believe that any FileMaker developer who tries FMPerception for a single day will wonder how they ever survived without it.”

“FMPerception instantly became one of my ‘can’t develop without’ tools – for its speed of analysis, and ability to query deep into every part of a solution,” said John Renfrew, FileMaker developer at Attitude in the UK.

“Thanks a lot for the new Report Card feature. That’s really fantastic and extremely helpful. For me, FMPerception is the best FileMaker developer tool ever,” said Jörg Köster, FileMaker developer and owner at JK Solutions in Germany.

About FMPerception

FMPerception™ is the fastest, most-accurate database utility for searching, analyzing and maintaining FileMaker custom apps. It helps developers create the highest-quality FileMaker custom apps – faster and easier than they ever have before. Because it uses a powerful progressive analysis technique, it quickly gives developers current and accurate information about their FileMaker application’s structure – so they can get the answers they need to stay in the flow and keep programming.

 What’s New:

  • NEW! Database Report Card – Gives a high level overview of a FileMaker system. It’s designed to give an indication of the complexity and potential problems in a FileMaker application, which is indispensable for a project that has been inherited.
  • NEW! Call Chain Visualization – It literally adds another dimension to the perception of how a solution’s scripts work together. Developers can follow the flow of their scripts from top to bottom with this two-dimensional flow chart of scripts.

Plus, FMPerception does all this and more:

  • Displays every detail of a FileMaker database’s structure in seconds by simply opening the FileMaker Pro Advanced Database Design Report (DDR) with FMPerception.
  • Generates a complete view of a multi-file solution so developers can see everything in one place.
  • Identifies security concerns like accounts with missing passwords and scripts that run with full access privilege.
  • Detects layout objects that may be bogging down a solution, such as objects that have local CSS or portals that require lots of relationships to resolve.
  • Finds broken references and unreferenced objects so they can be fixed or removed.
  • Shows where specific scripts, global variables, layouts, fields and custom functions are used.
  • Includes a free form text search to find virtually any string used in a FileMaker custom app.
  • Documents the differences between two versions of a solution using the DiffViewer.
  • Displays details in a modern, customizable interface to meet each individual’s specific needs.
  • Makes it easy to copy snippets of code and paste into another FileMaker database.
  • Eliminates disruptions to the development workflow and coding mindset to help developers operate at maximum productivity throughout the day.
  • Works with FileMaker Pro Advanced 12, 13, 14 and 15.
  • Runs on Macs and Windows PCs.

Pricing and Availability

FMPerception is available to try free for 14 days on Mac or PC via download from the Geist Interactive website:

After the trial, pricing starts at just US$499

FileMaker Accounting Integration Webinar

FileMaker is a great platform for building custom data driven applications. But should you use it to build your own custom Accounting solution? Probably not. In this FileMaker Accounting Integration webinar hosted by FileMaker Inc, we cover the benefits of building custom business applications with FileMaker and integrating them with Quickbooks Online.

Read more

FileMaker Script Call Chain Visualization – FMPerception

We are very excited to release the prettiest new feature to hit FMPerception, since it’s initial release. It’s called the Call Chain Diagram.  You can use the diagram to easily visualize all the scripts that call or are called by a given FileMaker Script in an interactive 2D chart.

Read more

JavaScript is Eating the FileMaker World Video

My presentation, “JavaScript is Eating the World” was released last week along with the rest of the Web Track presentations.

Read more

windows filemaker analysis

FMPerception for Windows Now Available

FMPerception is now available for Windows PCs, making FMPerception the fastest Windows FileMaker Analysis tool available. Get up-to-date and detailed information about your database without waiting for a lengthy import and analysis step. Whether you use a Mac or a Windows PC or both you can get the answers you need to stay in your flow and keep getting your work done.

Windows FileMaker Analysis

Staying in the flow is important while you are working on FileMaker system. If you have to wait for too long to get an accurate answer to a question, you risk losing your place. You may forget important details about what you were doing, or why you were doing it. At the very least you are going to waste time having to reload all the information about what you were doing into your brain so you can get back to work.

Detailed Accurate Useful Information

FMPerception parses the FileMaker Advanced Database Design Report quickly to give you detailed information that can help you find the answers to the questions you need to build and maintain awesome FileMaker Solutions. Here are just a few of the things you can do with FMPerception for Windows and Mac.

  • Locate broken and unreferenced and potentially unused elements, like custom functions, scripts, and fields.
  • Find every place you used a $$variable or a field or a script.
  • Get a list of potentially slow layout objects.
  • Quickly find the differences between two versions of the same solution.
  • Use freeform text search to find anything in your FileMaker system.
  • Build your own tools on top of FMPerception.
  • and much much more


FMPerception is available starting at $499 for a single user license. You can activate that license on up to two computers of your choosing. It can be two Macs, two Windows PCs, or one of each. It’s up to you. Multiple user discounts are available on our Team licenses. If you already own a license but haven’t used both activations for it yet, then you can use the second activation on a Windows PC.


If you need to upgrade from a single user license to one of the team licenses, email to request an upgrade.