ISO FileMaker Magazine

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. Especially if you've not worked with other programming languages like Python. 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.

And, it's probably not as scary as you think it is. Yes, FileMaker is nice and comfortable, but it has it's limits. When you want to become a power developer, you have to become familiar with what's possible.

In this video, I walk through the use of Python, in conjunction with FileMaker in order to export a multiple sheet Excel workbook. 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!

As 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. What this means, in the context of FileMaker, is that you can’t just stop with using FileMaker alone. There are many times when it makes more sense, or will net bigger benefits, when you go outside of FileMaker.

The trick is this, you don’t necessarily need to go too far outside of FileMaker to accomplish some amazing things. 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.

On the Macintosh, we find that we have access to a plethora of tools which can sift through data like nobody’s business. On the Windows side you’re a simple install away from having the same power.

This video is all about going outside of FileMaker in order to leverage a treasure trove of tech for parsing HTML and beyond. Watch this video if parsing anything you could ever want out of a web page is something which appeals to you.