The Support Group Blog

After graduating with a Bachelors of Technology in Application Software Development from Morrisville State College, I responded to a job posting for a Database Manager position and the job description mentioned SQL Server and a word I never heard before, FileMaker. I always rise to the occasion so I figured I could learn another database programming language relatively easily. During the interview, I repeatedly referred to FileMaker as “FilmMaker.” Fortunately, Sessions College of Professional Design took a chance on me and within a week I was introduced to their multi-file spider web of a system! Unlike traditional database programs, I found FileMaker Pro easy to use and I loved how quickly I could develop solutions.

I enjoy teamwork – the thrill of brainstorming new/different ideas with my peers and working on different projects together. In an effort to pursue that, I joined The Support Group as a Developer and worked my up to Systems Engineer from there.

The thought of actually building your own custom business application might sound impossible. We get it, it's an investment, not just from a financial perspective, but it also involves a good deal of your attention and time. However, most of the easily automated tasks that you do regularly can save you time and money when you perform those workflows with a custom app.

These are some of the signs that a custom business application might improve your business productivity and profitability.

The introduction of the new FileMaker 17 Platform brings many new and productive improvements to the software. We have the ability to attach multiple files to email messages, copy custom menus, create directories on the fly and more. Those are all very exciting features but I would say one of the life-changing enhancements is the new FileMaker data migration tool. The data migration tool isn’t strictly a version 17 feature. It's really a stand-alone command line app that you can download with a FileMaker Developer Subscription, just like the iOS SDK.

I've finally jumped on the bandwagon; I've upgraded to the FileMaker 17 Platform. I know, I’m a developer and I should have done it as soon as it released, right?! I have no good excuses, but better late than never. So here's how I navigated the upgrade process.

NORTH

I downloaded the installer file and installed it, so far so good. I opened the file for the first time and immediately noticed the new My Apps window. This new window provides easy access to My Apps and Recent files as well as a button to Create a file. The new UI is very modern and intuitive.

One of the great things about the FileMaker Platform is how fast you can create a custom app that is valuable to you and your coworkers. The ability to whip up something in virtually no time is obviously an attractive feature, but so too is the platform’s unparalleled flexibility to continuously adapt to your needs as they change. They say nothing's perfect and I guess one of the few gripes I had with the program was the minor requirement to ungroup objects in order to make substantive changes to them. 

I have run several businesses over the last 25 years, including a trust company and a mutual fund administration company. In all of my ventures, I used the FileMaker platform to automate data management, workflows and reporting. At one point I decided to take an early retirement but very quickly realized I was bored. So after asking myself what I liked most about the work I did in the past, the answer was easy - I loved building data systems!

I have an innate ability to analyze businesses and identify weaknesses within the organization and work processes. It serves me well that I have the complementary ability to recommend and design changes to workflows that greatly increase productivity.

FileMaker Server 17 ushers in a new age of server administration. Since the release of FileMaker Server 13, we've relied on proprietary Java framework, which was a little heavy for the simple task of administering a server. Now, FileMaker Server has moved to a standards-based, web-only administration interface that is as dynamic and responsive as any modern website. This isn’t our first glimpse of this directional change as many of us have been using a slimmed-down version of this interface with much success in FileMaker Cloud for over a year now. It's elegant, fast and intuitive. Having said all that, creating a whole new tool that allows you to perform all the tasks required to administer and deploy a database/application server is quite a Herculean task. In order to accomplish this without disruption to the user base, FileMaker, Inc. has decided to move in a more evolutionary direction rather than a revolutionary one .

If you've been kicking around the FileMaker neighborhood for any amount of time, you've probably run into a need to show multiple records in a list format as well as provide a detail view of the current record. Up until now you basically had two options.

The first and probably most popular method is to create one list view layout and another form view layout. The user typically performs a find and if there's more than one record found, you send them to an optimized list view layout. And then with the click of a button, they can see the related details of each record in a form view layout or even in a popover.

If you're like me and you do your work on a laptop in the office and at home, you will welcome the new self-organizing and predictable controls that FileMaker, Inc. has introduced in the new FileMaker 17 Platform. At work, I connect my laptop to an external monitor, which expands my viewable space and allows me to spread my work out. However, at home, I rely on my 13" laptop screen to do my development work. Prior to the release of FileMaker 17, every time I switched between the monitor and my 13" laptop screen, I had to find all my control pallets (Object Viewer, Inspector and Field Picker) and then rearrange them to work within the confines of my screen. This was a pain because I had to shift my focus from improving workflows and adding value to trying to find and grab my pallets. It was like being at the carnival midway playing whack-a-mole. This has all changed with version 17. Now all three of these important tools are always accessible where and when I need them. Like most modern integrated development environments, the new Layout Mode configuration docks these important tools right to your Layout window, so that you don’t have to think about where they are when you transition from desk to couch.

Here's the situation: you're showing your new custom app to a client, boss or colleague and you're proud of the way it can send an email directly from the app. This allows users to leverage all the data stored within it - pretty powerful! But then they ask if they can email more than one attachment because the weekly sales progress report includes three PDF files. Deflated, you hang your head and explain that FileMaker Pro only supports one attachment per email. That used to take the wind right out of your sails until the new FileMaker 17 Platform came along and offered the option to attach multiple files to an email message...