Blog Archives

Using barcodes with FileMaker Go

FileMaker Go 13′s new built-in barcode scanning feature makes it easier than ever to incorporate barcodes into your users’ workflows. Barcodes are a fantastic way to make data entry and retrieval both faster and more accurate. In this article, we’ll take a look at some details of various barcode formats and provide an overview of various ways to generate barcodes from within FileMaker.

Insert from Device dialog

Exploring the new Perform Script on Server script step

FileMaker 13′s new Perform Script on Server script step provides new opportunities for optimizing performance and it enables access to features that were previously unavailable to remote FileMaker Go clients. Our FMRPC product and other techniques have allowed this type of functionality with FileMaker 12, but having this capability built into the FileMaker 13 platform means we can leverage it much more broadly. Performing a script remotely allows us to build solutions that:

  • Dramatically improve remote performance for data-intensive tasks
  • Access plug-in features and complex web services from FileMaker Go
  • Perform scripts asynchronously
  • Seamlessly leverage FileMaker’s security model

FileMaker 13 Resources

FileMaker Pro 13 Advanced     On December 3rd, FileMaker, Inc. introduced the new FileMaker 13 Platform, which adds more than 50 new features. These new features allow us to create even better solutions with: Richer, more intuitive interfaces to your

Quickly Navigating to a Specific Record Within a Found Set

Recently I needed to have a FileMaker Pro 12 script navigate to a particular record within the found set after performing some action. There are several situations where this could occur, such as a scripted Extend Found Set or Constrain Found Set or perhaps when looping through the found set and either omitting, deleting, or duplicating certain records.

My first thought was to simply capture the ID of the current record at the beginning of the script and then loop through the found set at the end of the script and exit the loop on the correct record. What I discovered was that this was unacceptably slow with larger record sets. So here’s a better method. (By the way, thanks to Jeremy Bante and Jesse Barnum who both reminded me that this technique is called a binary search.)


In the previous four parts of our Lemonade Stand series, we shared techniques for charting trend lines, seasonal forecasts, and moving and weighted averages in FileMaker. Lots of readers have been asking about the example file we promised. We’ve finally wrapped up the first version with working examples of all of the techniques we’ve been discussing.


In Part 3 of our Lemonade Stand series, we demonstrated a technique for creating seasonal forecasts with FileMaker 12. In this part, we’re going to look at how to create moving and weighted averages.


In Part 1 and Part 2 of our Lemonade Stand series, we demonstrated how to add a trend line to a chart in FileMaker 12. In this part, we’re going to look at how to create a seasonal index from a set of historical data and then use that index to create a forecast based on both the trend and seasonality.


In Part 1 of our Lemonade Stand series, we demonstrated how to add a trend line to a chart in FileMaker 12. In this part, we’ll look at extending that technique to use a date field rather than a number field.


Sometimes as software developers we get caught up in the details of collecting, storing, and displaying data. To our clients, this is rarely the ultimate goal. Our clients want to use data to make better decisions that will increase profits, utilize resources more efficiently, and improve lives.

This is part one of a series of articles exploring techniques for getting more out of your data. In this series, we’ll show you how to implement a variety of practical forecasting models in FileMaker Pro. A few of the topics we have planned include:

  • Moving averages
  • Weighted averages
  • Exponential smoothing
  • Trend projections
  • Seasonal trend projections

ExecuteSQL Function – FileMaker 12 Web Series Follow Up Q&A

I was overwhelmed by the positive response to my 12 Days of FileMaker 12 – ExecuteSQL webinar. We received a lot of great questions during the session. I’ve included answers below for all of the questions we weren’t able to address during the webinar. If you still have a question, feel free to contact us.

Thanks to everyone who participated live or via the recording. If you missed it, you can still catch the recording at FM Academy or download the example file.