Step-by-Step Guide to Building a JSON Object in FileMaker

JSON has now become a FileMaker developer’s standard method to store and manipulate data in memory. In other words, when you want to create a variable to store anything more complex than a simple string, number, or return-separated list, JSON is the way to do it. If you’re not using it already, you must learn how!

Read More


Data Separation and Account Security

FileMaker’s built-in security features for accounts and privilege sets are flexible and robust enough to meet almost any need. There are times, however, when a particular scripted process needs to override an individual’s security access in order to complete its task. In most cases, the option to ‘Grant Full Access Privileges’ to individual scripts has met this need. (Note: this option should still be used sparingly and only when absolutely necessary.) There is, however, an instance where this doesn’t work as expected, and that’s with data separated apps.

Read More


FileMaker 18 and Gmail Send Mail Bug

A new bug with FileMaker 18’s Send Mail script step has come up recently. This bug only occurs when sending email via SMTP server. It also only happens when using Gmail’s SMTP service. The bug is apparent when users attempting to Send Mail via SMTP encounter this pop-up:

Read More