About Greg Lane

Greg Lane is a FileMaker Certified Developer at Skeleton Key in St. Louis, MO.

Entries by Greg Lane

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 data for your computer, mobile device, and web browser Improved data collection workflows with integrated […]

LEMONADE STAND, PART 5: EXAMPLE FILE

  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 […]

LEMONADE STAND, PART 4: MOVING AVERAGES AND WEIGHTED AVERAGES

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. What’s it mean? Moving averages and weighted averages are two common methods that can be used to smooth fluctuations in a […]

LEMONADE STAND, PART 3: SEASONAL FORECASTS

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 […]

LEMONADE STAND, PART 2: MORE FORECASTING AND TREND LINES

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. Let’s take a look at the final chart and then we’ll dig into the […]

LEMONADE STAND, PART 1: FORECASTING AND TREND LINES

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 […]

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. […]

Working with FileMaker container field data via JDBC

In a previous article, we shared some of the significant changes in ODBC and JDBC-related features in FileMaker 11. This article takes a closer look at how to work with container field data via JDBC. Inserting Image Files FileMaker 11 is the first version that provides a way to manipulate container field data via xDBC. […]

FileMaker Go Barcode Scanning with CNS Barcode

Last week, I shared an article and video about integrating FileMaker Go with the free app pic2shop. The pic2shop app allows an iPhone’s camera to be used as a barcode scanner to scan UPC and EAN barcodes. In this article, I’m going to take a look at the new CNS Barcode app from Comm-unity Networking […]