Show me external vs. embedded containers in FileMaker

Dear InspectorPro: Can you show me a report on the container fields used in my FileMaker solution, with a list of all externally-referenced vs. internally-stored (“embedded”) fields? Sincerely, Thanks in Advance-d.

Continue reading “Show me external vs. embedded containers in FileMaker”

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”

Installing the Zabbix 4.2 Monitoring Agent

On our FileMaker Cloud for AWS servers, which are currently CentOS 7.6 based, we are typically installing the Zabbix monitoring agent. With one exception, installing the Zabbix agent is a relatively quick and easy procedure.

Although not required, installing the agent allows gathering more data on your servers than a Zabbix server alone.

Continue reading “Installing the Zabbix 4.2 Monitoring Agent”

Restoring Backup Files on FileMaker Cloud for AWS

Recently, we had a client who required restoration of FileMaker backup files for their FileMaker Cloud for AWS 1.17–hosted solution. This seemed a simple enough request—we would download their backup files using the FileMaker Cloud for AWS Admin Console and then re-upload them to the server. However, things did not go smoothly as there was seven gigabytes of data to download and the process was too slow for their fast-paced production environment…like half-a-day too slow.
Continue reading “Restoring Backup Files on FileMaker Cloud for AWS”

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”

Native HTML Email in FileMaker 18

Email is one of the simplest tools used to communicate and send information. Just open a mail client, write a message and press a button to virtually send a letter or message to a recipient.

Sometimes, in addition to simple text, we want to enrich our emails with graphical contents and attachments, making it more pleasant for those who receive it or giving a more cohesive image to our brand. This requires HTML, and it’s not as simple to build and send emails this way.
Continue reading “Native HTML Email in FileMaker 18”

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 REST and cURL with FileMaker Server 18’s Data API

Well, here we are again! With the release of FileMaker 18 we get the third version of the FileMaker Data API. This version brings an iterative advancement in features while maintaining the core functionality that was introduced with V1 of the API in FileMaker Server 17.

I’m following suit with an iterative advancement of my previous blog posts about the Data API (here and here).
Continue reading “Using REST and cURL with FileMaker Server 18’s Data API”

Importing, Made Easy by FileMaker 18

Out With the Old…

Anyone who has used FileMaker will be familiar with the powerful import abilities the platform has. Being able to quickly and easily ingest comma- or tab-delimited data and Excel files makes merging multiple data sources into a single cohesive application pretty convenient. However, the import UI that has existed for the platform over the last decade (maybe longer) is cumbersome and often downright frustrating. This is especially the case when trying to import many columns and match them to fields with different names than the source.

Continue reading “Importing, Made Easy by FileMaker 18”

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”

Introducing Admin FM – the FileMaker Admin API for Zapier

Introducing Admin FM – the Zapier integration for accessing the FileMaker ® Admin API in an easy, customizable way. Built using Node.js, this version of Admin FM is currently a beta version, but it allows you to access most of the functionality that the FileMaker Admin API allows.

Continue reading “Introducing Admin FM – the FileMaker Admin API for Zapier”

1 2 3 4 5 14