• entries
    20
  • comments
    2
  • views
    505

Entries in this blog

John Mark Osborne

I was asked to write an article about my experiences, troubles, pitfalls and recommendations to those starting out with FileMaker. I find many times, and this applies to any industry, when experts help beginners, the experts forget what it was like to be a beginner. While the expert is generous with his or her advice, although perfectly accurate, it sails over the beginners head. The beginner just doesn’t have the experience and tools to digest and disseminate the advice offered. On many of the FileMaker help forums, I see many people who get a copy of FileMaker, jump right in to making their first database and quickly run into trouble and frustration. I know their pain, because I made some of the same errors. Hopefully some of the tips, based on my experience will help the beginners avoid my errors.


View the full article

John Mark Osborne

The new release schedule, designed to get fresh versions of FileMaker to the public faster, is in full swing with the release of FileMaker 16. It took the FileMaker 16 development team just one year to program a fully featured upgrade with changes to Pro, Go, Server and WebDirect. A truly amazing feat. While FileMaker 15 was a platform upgrade, with few visible changes to Pro or Advanced, FileMaker 16 focuses back on the desktop application we all love to program. Everything begins at the desktop so it really should be the center of attention in every FileMaker release IMHO! I think this version will leave experienced developers very satisfied.


View the full article

John Mark Osborne

FileMaker is an incredibly versatile and scalable platform, but it is genuinely unique in the way it allows you to solve real world problems quickly, efficiently and super cost effectively. I work for a company that manufactures water softeners (the best ones actually) and I was asked to solve a particular problem we were having in diagnosing rare cases of abnormal operation in the field. In this case study, FileMaker was a perfect fit!


View the full article

John Mark Osborne

One of the most common FileMaker fallacies is a web browser client will save money. I hear it almost weekly from the people who contact me directly. I get it. Everyone wants to save money. But, just because a web browser is free doesn't mean it saves you money. This article will consider specific points about why a FileMaker client provides a better experience for the user than a web browser at the same price.


View the full article

John Mark Osborne

What is FileMaker Pro scripting? It can be defined as automation, a macro and even a programming language. FileMaker Pro scripting has elements of all these definitions. The original purpose of scripting was to automate the mundane task of printing a report. Since it repeats most of the items under the menus, it can also be considered a macro language. Yet, it is so much more! With logical branching, it can even be considered a programming language. The FileMaker Pro Script Workspace is a beautifully designed environment that enables you to create a solution as good as any commercial product on the market. This scripting primer well tell you everything you need to know before you write your first script.


View the full article

John Mark Osborne

In the last few years, I've subscribed to the KISS methodology (Keep It Simple Stupid). Call it wisdom or humility, I'm not sure which. All I know is, after over two decades in the FileMaker market, I've discovered the simplest solution is most often best for my clients. It costs less and performs better, in most cases. I know all the tricks, having practically wrote the book on the subject, but there is a time and a place for complex methods. What I'm here to convince you is, choose complicated techniques carefully.


View the full article

John Mark Osborne

When I first started teaching FileMaker scripting, I went through the entire list of script steps and provided a simple example of each one. By the end of the third day, we had covered every script step but with no depth. More questions remained than were answered. That’s when I decided to focus on the most important steps. Instead of spending valuable time teaching scripts steps most people would never use in real life scenarios, I decided to concentrate on steps that are used over and over and have tons of depth. That’s how I developed my "Ultimate Find" script. It’s a great way to start your journey into advanced scripting, demonstrating important concepts and sophisticated techniques with key script steps, all in one little script. Besides, every good solution needs a well designed find script.


View the full article

John Mark Osborne

Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection are not treated properly they will raise all sorts of problems. In this article we will discuss good practices regarding indirection that will help you build a dynamic and robust FileMaker system.


View the full article

John Mark Osborne

This is part 2 of the phone filtering solution. If you haven't read then it's a good idea to start there. Even if you are familiar with filtering phone numbers already and just want to read about the recursive version, it's still best to read part 1 to familiarize yourself with the approach. And, you never know, you might find a nugget of truth!


View the full article

John Mark Osborne

Phone formatting is one of my favorite techniques because it teaches so many important concepts. The interaction between a complex formula, auto-entry and validation is fascinating to me. There are so many possibilities, as well as potential hazards, when combining different components. When you get the hang of it, there is nothing like the feeling of weaving a new ability through the union of multiple features.


View the full article

John Mark Osborne

Phone formatting is one of my favorite techniques because it teaches so many important concepts. The interaction between a complex formula, auto-entry and validation is fascinating to me. There are so many possibilities, as well as potential hazards, when combining different components. When you get the hang of it, there is nothing like the feeling of weaving a new ability through the union of multiple features.


View the full article

John Mark Osborne

Professional developers pay attention to the number of files in their FileMaker solutions because it’s a crucial factor in good database design. Most developers utilize the standard single file structure because it makes development easier. On larger multifaceted projects, a developer might use several files for separate areas of the company. A smaller set of developers like to use the separation model to avoid issues with updates to their solutions and other benefits that will be explored. It’s very important to choose the file structure the best suits your style as well as the project at hand.


View the full article