Recently I was tasked with implementing a picker list whereby the user could assign people to a project, and indicate each person’s hourly allocation to that project as that assignment was made. How can data be associated with names in a picker list, before those names have actually been stamped onto their own records?
Introducing JSON Filter, Map, Reduce.Now that FileMaker has given us a practical and more simplified way to loop in a calculation with the While() function, the doors have opened to other ways to look at looping. Continue reading “Let’s Abstract a While() in FileMaker”
Here at the Beezwax, we have been performing research on FileMaker 18 import changes, specifically new support for ESV: Emoji Separated Values.
Continue reading “FileMaker 18 Adds Support for ESV (Finally!)”
FileMaker has been missing a looping control structure in its function set for…well…a while. So, the introduction of FileMaker 18’s While() function is less a fancy new feature than it is a fix for a long standing limitation in FileMaker’s function set.
Continue reading “We’ve been waiting for While()… for a while”
Combining functions, features, or steps in creative new ways can deliver productive results. I was thrilled to discover in FileMaker 18 that the new file-based script steps give us the ability to perform imports natively on FileMaker Server, with no configuration or changes needed.
“Hey Siri…Ask FileMaker…”
This story started when we explored iOS Shortcuts to the FileMaker Data API. As we continue to automate tasks by mixing together iOS apps, content on mobile devices and web APIs plus FileMaker, let’s add to our workflow using one of the most powerful functions available to iPhone and iPad users: Siri.
Shortcuts, on iOS, are a new way to automate tasks by mixing together apps, content on your iOS device and web APIs into custom workflows. Now, via the FileMaker Data API, you can use shortcuts as a way to interact with your FileMaker solutions.
Here’s an example of automatically uploading a photo from your iPhone into a FileMaker container field, via iOS shortcuts to the FileMaker Data API.
A colleague recently posed this challenge: is it possible to show two columns in a portal, such that the first row displays records 1 and 2, the second row displays records 3 and 4, etc.? With FileMaker, the answer is usually “Yes!”
I’m always excited each time the FileMaker Platform gets new capabilities. It isn’t just the new features on their own that make things interesting, but what happens to the platform as a whole which provides for some interesting and inspiring innovations. In this case, it is a new way to do transactional record editing in FileMaker. This is the first in a multi-part series on this topic.
Continue reading “How Transactional is the FileMaker Data API?”
Way back when FileMaker 14 was released, as developers we were treated to the new-and-improved script workspace, adding all kinds of features from line breaks to auto-complete/type-ahead coding. To any of us who spend most of our day working in FileMaker, the response was sheer joy.
For all of its speed, flexibility, and ease-of-use, sometimes our favorite platform is missing some of those “standard”, quality-of-life features you would expect. For a long time, Layout mode has been lacking a few key features you would normally expect to see in a modern design application. With FileMaker 17, we get much closer to bridging that gap, receiving a whole bunch of handy, time-saving features along the way. Let’s dive in and take a look.
Continue reading “Lost in Layout Space: Getting to Know FileMaker 17’s Layout Mode”
One of the most exciting new features of FileMaker 17 isn’t part of the product, technically: it’s a command line function called the Data Migration Tool. You invoke it from the terminal, but don’t let that fool you. This is a uniquely powerful tool, one that honors the pitfalls of developing in a hosted, high-trafficked app — finally.
The Data Migration Tool allows you to merge two files, so you can develop in an offline copy and then migrate the live system into your improved app. Migration includes user accounts, value lists, serial numbers and of course data, all at once.
Continue reading “FileMaker Data Migration Tool – New Ways To Code In Complex Environments”
We have better tools than ever in FileMaker to create reusable modules. In this video of Mark Scott’s presentation at a Bay Area FileMaker developer meetup, he explores why the combination of card windows and JSON reigns supreme for modular FileMaker architecture. Included is an in-depth look at how modules can open, close, and communicate.
We recently built an application that included PDF document management. While it might seem as simple as a quick FileMaker container field, we wanted to impress our client with an integrated solution on par with a content management system (CMS). Here’s how we built a powerful PDF viewer directly into FileMaker.
Continue reading “Full-Featured PDF Viewer Embedded in FileMaker”
We’re thrilled to announce the official, “integration-ready” version of LOgiCATOR. LOgiCATOR is a modular search interface for FileMaker that can be easily integrated into new or existing solutions. It’s designed to help users locate data with logical precision, via a powerful yet intuitive interface for searching across FileMaker tables. This article includes a download link for the module and demo file, describes what’s changed since the preview version (a lot), and explains how to integrate LOgiCATOR into your FileMaker solutions.