To Top

FileMaker Pro 19: How To Fix The License Certificate Not Installing

Is your FileMaker Pro 19 installation running as a trial license despite adding the license certificate?

In the process of setting up a machine for a client recently, we encountered an issue where FileMaker Pro 19 was installed, with the license certificate in the downloads folder as it should be, but we were asked for the license certificate each time the app was launched. And when it did launch, the app was in trial mode with an expiration date. But wait, we have a valid license...

Continue Reading

FileMaker Pro: Extracting Multiple JSON Formatted Script Parameters In One Step

It Might Take A "While" For Us To Achieve This

The JSON functions were introduced in FileMaker 16 and since then, as it's native functionality, we've used these functions for passing around data in script parameters and more. Often times, we'll be, say, clicking a button on a layout and passing multiple JSON formatted script parameters to the script being executed. But we began wondering if there was a quicker way of extracting the parameters into variables in the script, and it turns out there is…

Continue Reading

FileMaker Server On AWS: Expanding Volume Size

Adding Additional Disk Space To An Existing Volume

It’s not uncommon, as a FileMaker database begins to grow, that the volume originally set up on an AWS instance begins to run out of space. To tackle this, you could launch a new instance with a larger volume, but that seems like a bunch of work and there’s a much simpler way of solving this problem. Let’s find out how…

Continue Reading

FileMaker Server & macOS 10.15 Catalina: Backup Destination Not Writable

Warning 156 fms.myserver.com Schedule "HOURLY_BACKUP_USB" aborted; the destination "filemac:/BackUps/" is not writable.

If you upgrade your Mac server to macOS 10.15 Catalina, you might find that your backup schedules to external drives start failing with an error number 156. Although apparently fixed in FileMaker 18.0.4, it's rearing its head again, but there is a simple fix.

Continue Reading

Fixing Custom Default Fields In FileMaker 19

Changes In FileMaker 19 Have Broken Existing Custom Default Fields

Custom default fields were introduced in FileMaker 17 and proved to be immensely useful. The functionality allows for the automatic creation of fields when making a new table, ensuring consistency for fields like primary keys or creation/modification timestamps for example. If you had set this up in 17, when FileMaker 18 was released, they continued to work. But try it with FileMaker 19 and your custom default fields are gone. Don't panic, it's a pretty simple fix.

Continue Reading

Intro to Claris Connect Part 6: Making FileMaker Trigger A Flow

Triggering and sending data to a flow from FileMaker in Claris Connect

FileMaker can do literally almost anything, including interacting with APIs. For example, in our previous articles introducing Claris Connect, we've been adding a member to a Mailchimp list. But that process of communicating with the API may not always be so easy. If only there were a way to trigger a Claris Connect flow from within FileMaker. Oh. Wait. There is! Let's see how...

Continue Reading

Intro to Claris Connect Part 5: Sending Data To FileMaker

Integrating FileMaker into Claris Connect flows

In our previous articles introducing Claris Connect, we've been integrating cloud based services to handle a particular workflow. But we're FileMaker developers at heart. So how does our database fit into all this? 

Well, we're glad you asked, because the answer is pretty darn well! With FileMaker also being a Claris product, those clever folks over there made sure that FileMaker could be used within a flow of Claris Connect. So let's send some data from our flow to a hosted FileMaker database.

Continue Reading

Intro to Claris Connect Part 4: Handling Errors

Gracefully trap for and fix errors in Claris Connect

Even with the most careful of programming, things can go wrong. It's not necessarily the programmer's fault when an error occurs, but we need to try to predict what could go wrong and where. For this reason, we introduce error handling into our flows to check for errors and do something about them when they occur.

And yet again, Claris Connect, an IPaaS solution (Integration Platform as a Service), provides a simple and effective way to trap for errors and take action as a result. Let's investigate how we can error handle within our flow.

Continue Reading

Intro to Claris Connect Part 3: Requiring An Approval

Allowing human intervention before an action is executed

At times during an automated workflow, it may be necessary to have a human intervene and make a determination as to whether the next action should take place or not. There are plenty of examples of this, such as an employee vacation request or dispatching a tweet or email campaign. Once again Claris Connect, an IPaaS solution (Integration Platform as a Service), has you covered on this front. In this article, we'll show you how this works.

Continue Reading

Intro to Claris Connect Part 2: Creating A Conditional Flow

Using the power of conditional logic to create more complex flows

In part one of our introduction to Claris Connect, the new IPaaS solution (Integration Platform as a Service) from FileMaker parent company Claris, we took a look at creating projects and flows. Sometimes, though, business workflow and logic isn't as straightforward as the examples we used in that article. Many complex business rules require different outcomes based on certain conditions. Well, Claris Connect has you covered! Unlike some other IPaaS solutions, Claris Connect has the ability to create conditional logic and dictate the route of a flow as needed. Let's check it out.

Continue Reading

Intro to Claris Connect Part 1: Creating A Project & Flow

Taking the easy road with automated workflows using Claris Connect

Do you want to automate your workflows but find APIs daunting? Stepping into this arena is the all-new Claris Connect, an IPaaS solution (Integration Platform as a Service) that lets you easily create integrations, allowing you to work faster, with more accuracy and to focus on the business problem itself rather than the tool you're using to solve it. 

That said, we know that dipping your toe in the API economy can be scary, especially if you're not a "coder" or used to these kind of environments. Even the documentation is frequently written "by coders for coders" and can be hard to, uh, decode. Luckily, Claris Connect makes this type of automation much easier and more accessible. In this article, we explore Claris Connect and do a step-by-step walkthrough of how to set up an integration from Stripe to Office365 and Mailchimp!

Continue Reading

FileMaker Custom Function: Add To / Remove From Existing List

Simplify List Management With A Custom Function

Using lists in FileMaker is a common task and we do it a lot in the apps we design. Getting a list of records is relatively straight-forward, but it can get considerably more complicated when you want to manipulate that list by adding or removing values. In this tutorial, we'll use the code we developed for this purpose and turn it into a custom function you can reuse over and over again.

Continue Reading

FileMaker Server on Amazon Web Services: Automated Snapshots

Limit Downtime by Automatically Imaging Your FileMaker Server

For this post in our continuing series on using FileMaker Server (FMS) on Amazon Web Services (AWS), we're going to take a look at implementing automated snapshots. We've discussed in the past how important it is to back up your data files using FileMaker Server's built in back up scheduling feature. We've also explored setting up "offsite" backups in our post, FileMaker Server on Amazon Web Services (AWS): Backups. Both are insanely important, but they aren't the whole story...

Continue Reading

FileMaker Data API: A Beginner's Guide To Using PHP To Display Data On A Webpage

Extracting data from FileMaker for use on a webpage has been possible for years using various methods, including the PHP API. With the release of FileMaker 17, however, FileMaker introduced the Data API, allowing developers to interact with a database using industry standard REST methods. If you've never used the Data API before, you might be wondering how to get started. In this post, we're going to show you a very simple way of getting data from a FileMaker database, using the Data API and PHP.

Continue Reading

FileMaker Server & Zabbix: Setting Up a Server Part 1

Lesson in Brief: Monitor FileMaker Server Via Zabbix Utilizing a Windows 10 Machine

Setting up a FileMaker server and never looking at it again is a recipe for disaster. Are your backups running? Has the scripting engine crashed? Are you running out of memory or CPU? Are your integrations taxing your solution? If any of these things happen, or if you're not monitoring to ensure they don't, you're putting your data at risk.

Continue Reading

FileMaker WebDirect: URL Differences Between 15 And 16

Forwarding FileMaker WebDirect 15 URLs to WebDirect 16

When FileMaker 16 was released in May 2017, there was plenty of fanfare surrounding the many new features it introduced. WebDirect, however, did not get much attention or focus on any changes. But there were some, including an adjustment to the URL used to access a FileMaker solution.

For people that have bookmarked the FileMaker 15 WebDirect URL to your database, this presents a problem. Let’s see how we can fix it… 

Continue Reading