Category FileMaker Techniques

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

Google has a chart API that can be integrated easily with FileMaker Pro using just the WebViewer. This simple approach can be accomplished in minutes and has few moving parts.

Read More

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

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

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