This video is all about going outside of FileMaker in order to leverage a treasure trove of tech for parsing HTML and beyond. On the Windows side you’re a simple install away from having the same power. On the Macintosh, we find that we have access to a plethora of tools which can sift through data like nobody’s business. Right within FileMaker is the Web Viewer object with direct access to JavaScript and just a little beyond that are plug-ins which can access pretty much anything else you could ever want. The trick is this, you don’t necessarily need to go too far outside of FileMaker to accomplish some amazing things.

There are many times when it makes more sense, or will net bigger benefits, when you go outside of FileMaker. What this means, in the context of FileMaker, is that you can’t just stop with using FileMaker alone. Need to include Excel calculations, multiple worksheets, graphics and charts? Do the corporate leaders demand that you provide your report within Excel? Well, let's take a quick trip to Python land and we find all kinds of wonderful gems in our brand new toolset!Īs you’re probably aware, whenever a great craftsman has a project in front of themselves, they’re likely picking from not just one tool but many. In this video, I walk through the use of Python, in conjunction with FileMaker in order to export a multiple sheet Excel workbook. When you want to become a power developer, you have to become familiar with what's possible. Yes, FileMaker is nice and comfortable, but it has it's limits. Rest assured, however, you can certainly solve most any FileMaker problem as long as you're willing to take a little journey into the land of other tools.Īnd, it's probably not as scary as you think it is. Especially if you've not worked with other programming languages like Python.

When someone asks a simple question like 'How can I make FileMaker export a second worksheet in Excel?' The method you use to achieve this may not be immediately apparent.

Filemaker and python