The Support Group Blog

Every year, usually during the summer, FileMaker hosts a massive global conference for their developers. Like most customer/user conferences, the goal is to experience the product in different ways and explore new product features, in a supportive and fun environment. But leave it to technology to create a common developer dilemma – to go or not to go to DevCon. FileMaker, Inc. will eventually share most, if not all, of the session materials – including videos – within the FileMaker Community. So why not save the registration and travel expenses and wait until the materials become public?

Well, The Support Group has participated in DevCon in different capacities since the very first event in 1996. Yes, it's been that long and we can certainly tell you that it's worth it every year! We even share some of our own DevCon experiences during and after the conference; check out our FileMaker Developer Conference 2018 in review artcle. I cannot adequately capture the essence of why we go to DevCon, but I will try to capture a few of the main benefits.

The FileMaker Platform gives you plenty of options for exporting data out of your app. You can export files as text or even a separate FileMaker file but in our experience, the most common export format is Excel. It's pretty easy to export data out of FileMaker into Excel; the tricky part is customizing the headers of the exported data.

Why would you want to customize the headers? You may want to customize headers so that they're easy for the user to understand or to make them consistent with field names in other systems. For example, some of our developers like to group the "name" fields in a contact database by having them all start with the text "name" – nameFirst and nameLast instead of First Name and Last Name. So when we export that data natively from FileMaker, the column header will be nameFirst, not First Name. I won't get into why we do that here; that's a whole other blog post about field FileMaker naming conventions.

Keyes North Atlantic (KNA) provides design and installation service and maintenance for electrical, heating, cooling, alarm and automation systems. They've been serving clients in Greater Boston and the surrounding areas since 1952. From gas-powered generators and high-efficiency heating solutions to thermal solar and variable refrigerant flow systems, they do it all including designing and engineering the projects. They offer a wide range of services while demonstrating the highest level of professionalism and excellence with every customer and project. They're able to maintain workflow efficiency and exceed customer expectations with the help of a workplace innovation platform – FileMaker.

There are different factors that contribute to a successful custom application. Of course, function is important, but even if the app does exactly what users need it to do, users may not necessarily like it if it's difficult to use due to poor legibility, navigability, responsiveness, etc.

FileMaker, the Workplace Innovation Platform, helps to speed up custom app development, right down to the smallest detail, including design styles. The user interface has a huge impact on user experience. A well-designed interface generally equates to a positive experience. Developers must ensure that they use appropriate and consistent fonts, sizes, colors, images, layouts, and so forth within their applications. They can simply accomplish this by creating custom styles for the apps they design.

The West Side Montessori School (WSMS) has been offering a Montessori program for early learners since 1963. The school has grown from fifteen students to over one hundred and they also offer a teacher education program (WSMS-TEP) for adult learners training to become Montessori teachers. Based on the Upper West Side of New York City, they also have locations in New Jersey and Beijing China. In 2015, they renovated part of the children’s gymnasium into an adult learning space for their WSMS-TEP students. Needless to say, growth and development are important to the founders, faculty and students, both young and young at heart. And so we knew a Workplace Innovation Platform, like FileMaker, would facilitate that growth.

We develop custom business software solutions. Our job is to turn a customer’s business needs into functional, organized and attractive software solutions that improve their business operations. At the end of the day, our job is to make our clients look good inside their organizations.

At the heart of every software product is change. Once projects start to take form, our clients begin to see different possibilities and their minds fill with creative enhancements that will make their software even more valuable. We like when clients get excited about new possibilities, but it can also be difficult in terms of managing expectations.

It occurred to me that the process developers go through when faced with very difficult development challenges is much like the well-known stages of grief that psychologists describe. So here we go on the mental journey of almost every technical person faced with almost insurmountable client challenges.

One of the reasons FileMaker is a superior Workplace Innovation Platform is because of its integration capabilities. When our clients/prospective clients ask us if FileMaker can connect with other applications, my immediate answer is yes! But I think the better question to ask is: "how easily can the FileMaker Platform connect with other applications?" FileMaker offers many ways to integrate with other technologies. I myself have found very few limitations in terms of connecting a FileMaker application with other applications. As FileMaker, Inc. (FMI) releases new versions of the product, the integration capabilities expand. We've been able to connect FileMaker applications with other applications via ODBC/JDBC, live external data sources, PHP/XML APIs and flexible import/export options for many years. And now we have other integration functions like Data API (REST), cURL options in Insert from URL, native JSON functions as well as many JSON specific custom functions and a FileMaker and Tableau integration via a Tableau connector.

Since this time of year is associated with giving, we thought that we would share a FileMaker iOS gift. We created a retirement app using the FileMaker SDK. Some of us may find this app useful sooner than others, but we hope you benefit either way.  The free app is available on iPad only on the Apple App Store. 

Fun fact: the term debug was coined by Admiral Grace Hopper while working on the Mark II computer in the 1940's. A moth became stuck inside the computer and Grace commented that they were debugging the computer as they literally worked to remove the bug. The moth was eventually freed and then the term stuck. You can now find that moth at the Smithsonian Museum. 

Back when I was introduced to JavaScript, I used alert dialogs to debug my javascript code. If you're chuckling reading this then you're probably a pro! If not, you should watch my demo where I show you a few different ways to invoke a JavaScript debugger to help you find a bug or resolve a semantic issue in your code.

Let’s Play Cards!

The Card Window was introduced in FileMaker 16. We learned some pretty cool development techniques and use cases for Card Windows during a FileMaker Developer Conference 2018 session.

TRANSACTIONS

Card Windows can be a great tool for transactional programming. You can easily arrange for transactional events to either pass or fail, meaning all edits/adds/deletes that happen during the transaction are either committed or not. Cards can be leveraged to guide the user through a process, storing the data via global fields, variables or JSON arrays along the way. Ultimately, the data will only be committed if the user completes all of the steps. Incidentally, you can also use slide panels to create this user experience.