Category FileMaker Techniques

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


Dropdown Manage Security Menu

FMPA18 – Delegating User Management without Full Access

With the release of FileMaker Pro Advanced 18, full access users can delegate user management to any user. This tool reduces the administrative burden on database administrators, in addition to decreasing the response time when it comes to changes in user accounts. For example, the person(s) conducting employee onboarding/offboarding can now create, edit or delete users. Additionally, someone like an office manager would now be able to reset user passwords instead of sending a request to a database administrator.

Read More