ISO FileMaker Magazine

Unlike other programming languages, where the database is often separate from the language used to code solution logic, FileMaker includes everything, all wrapped up into one potentially giant mess of spaghetti.

In order to avoid the often inevitable pitfalls of being overly complex, you must code your FileMaker solution with efficiency and simplification in mind. FileMaker has many places where logic can exist in. It can be on an object, in a parameter, within a script, within conditional formatting, in an auto-enter setting, and obviously within the graph and data structure.

Your primary goal of keeping things simple means you need to be aware of how a FileMaker solution can grow and your field count is one of those areas. If you can reduce the number of fields, then your solution will be easier to understand. Choosing from three items is always faster and easier than choosing from fifty. With good segmentation, clean organization and a focus on limiting the number of "things to manage", you can create a very powerful FileMaker solution which doesn't suffer from object overwhelm. That's what this video is all about.

FileMaker does data, and it does it well - and easily. What FileMaker doesn't do "as" well is data visualization. This isn't because it couldn't. It's because they just haven't been able to focus on it as much. Sure, you can format portals, use repeating fields and use conditional formatting for all kinds of display magic, but you won't realize the same results as you could with a tool or language built specifically for data visualization.

In my humble opinion, they shouldn't work too hard on this either. This is because we have access to technology which provides far more than FileMaker ever can. FileMaker took ages before it had an integrated charting feature. Before that, you had to use a plugin and eventually you could use a remote API through a web viewer.

FileMaker has made a lot of progress with regards to the usability of its charting tool too. It's a great tool for basic data display.

However, when you need to go beyond the constraints of FileMaker's charting tool, the place you'll end up is within the web viewer. Granted, you'll need to shrug off any fear of learning HTML/CSS/JavaScript, but the benefits are well worth the journey.

In this video, I showcase how easy it is to integrate the very powerful JavaScript library D3. It's a power-user's tool which takes full advantage of everything that HTML/CSS/SVG has to offer. Within a world where data visualization is becoming a common form of data communication, this one video provides the first step of many towards taking advantage of some very powerful tools!

Perform Script on Server is the one step which will change how you develop FileMaker solutions FOREVER. Yes, I said that with all caps! This is exciting!

There's so much power in how it can be used, that it truly is a game changer. This is fundamentally why the web is so popular. It works like this.

Your client, a web browser, makes a request to some beefy server and it wrangles the data and then reports back with the compiled results. This is essentially what this new script step does, but with all the power of what FileMaker can do.

Until you start using it, it "seems" like it's just "another feature". Changing the way you think about FileMaker development, using PSoS for short, is inevitable. If your solutions are stuck in versions prior to 13, then you might want to beg, borrow or steal (ok, not steal) to start using this feature.

With PSoS, you can import hundreds of thousands of records in mere seconds. You can send hundreds of thousands of emails without ever seeing a spinning waiting indicator. You can update hundreds of thousands of records with lightning speed or generate a hundred page report as a PDF within minutes instead of hours.

This video provides all the critical know-how in order to start working with PSoS and it will get you going fast!

Simply creating a single FileMaker file to store your data is a perfectly fine way to start your solution. However, the first few times any number of users start complaining about the workflow taking too long, is when you may need to evaluate your architecture.

For sure, FileMaker Pro is a very capable platform. Like any thing else in the world of tech, there are less efficient implementations and highly optimized solutions. A knowledgable developer will known how to squeeze every bit of performance out of the environment they've chosen to develop within. The same holds true for FileMaker as for any other programming language.

In this video, I walk though some of the most common and also some of the more exotic deployment models you can use with FileMaker. Essentially, it all boils down to this. Knowing that FileMaker does not care where the data is. If you can point to it, and FileMaker can see it, then it's up to you as to how you structure things. We're not just using computers now, we're using smartphones, tablets and who knows what else will be coming. Touch sensitive wallpaper within our homes of the future? Watch this video for a sense of how it's possible to vary the deployment of your FileMaker solutions.

FileMaker 13 introduced a number of new features. While the feature list seemed a bit short, at least to the feature greedy developer, the new mobile specific features of Gesture taps, Popovers and Sliders will provide a wide variety of new functionality for months to come.

In the case of mobile design, the number of UI patterns which can be emulated now within FileMaker has grown significantly. Beyond straight-forward popovers, you can combine both older and newer functionality to accomplish some really cool stuff.

In this video, I showcase a UI pattern which provides a hidden menu. This is done with a new Slider control and is a very common pattern within the mobile space.

Beyond the simple slider/menu implementation, I also showcase the use of the Gesture controls and how you can determine if a tap is within a predefined area. This level of UI control allows you to decide when a script should fire or not. Very empowering stuff!

You can Watch the HD version on YouTube

FileMaker 13 was released on December 3rd 2013 and this release is a very worthy upgrade! Many of the features are specific to mobile centric solutions but many other valuable new features were added as well.

Whether you need access to your FileMaker data via the new WebDirect functionality or you've been waiting years (like I have) for some features to be completed, like calculation based tab names and dialog buttons, there's sure to be something within FileMaker 13 which you'll appreciate.

This video provides an high level overview of all the major new features and updates to FileMaker 13.

You can Watch the HD version on YouTube