Editable Picker List in FileMaker

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?

Continue reading “Editable Picker List in FileMaker”

Let’s Abstract a While() in FileMaker

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”

FileMaker 18 Adds Support for ESV (Finally!)

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!)”

We’ve been waiting for While()… for a while

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”

Imports without Tariffs. Natively, with FileMaker Server.

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.

Continue reading “Imports without Tariffs. Natively, with FileMaker Server.”

Using Siri with FileMaker, via iOS Shortcuts

“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.

Continue reading “Using Siri with FileMaker, via iOS Shortcuts”

iOS Shortcuts to the FileMaker Data API

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.

Continue reading “iOS Shortcuts to the FileMaker Data API”

Multi-Column Portals

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!”

Continue reading “Multi-Column Portals”

Apple Maps in FileMaker With MapKit JS

For awhile we’ve been asked: “Can you use Apple Maps inside FileMaker, rather than using Google Maps or MapQuest?” We decided to give it a shot, thanks to MapKit JS, the JavaScript implementation of the MapKit library widely used on macOS and iOS. Here is a technique our FileMaker and JavaScript development teams designed to enable Apple Maps inside a FileMaker solution.

Continue reading “Apple Maps in FileMaker With MapKit JS”

1 2 3 11