BLOG

Advantages of ExecuteSQL + Get Clear Error Messages with ExecuteSQLe

FileMaker’s ExecuteSQL function has been available for quite some time and is a powerful tool in your developer's tool kit. While FileMaker’s native relational model is simple and intuitive, the ExecuteSQL function introduces an additional level of flexibility, enabling developers to access data across tables without creating extra table occurrences or relationships. The recent release of FileMaker 21.1 represents a significant enhancement to SQL functionality with the new ExecuteSQLe function. One of the biggest limitations has been addressed - error reporting. Unlike ExecuteSQL, ExecuteSQLe provides the return of clear error messages, enabling developers to troubleshoot queries much more effectively. If you’ve been frustrated with ExecuteSQL’s cryptic “?” symbol, ExecuteSQLe’s feedback is a welcome change. Read more
Read More

Our Recent Experience Building a FileMaker Web Application with FileMaker Cloud

Colorful graphic depicting computer connected to a large cloud with icons representing a multitude of integrations available.
Our latest venture involved building a web application for students to submit data through a form, pushing this data to a FileMaker solution for storage and analysis. This blog post chronicles our journey from the initial hosting strategy to navigating the unforeseen challenges presented by FileMaker Cloud: in particular, Multi-Factor Authentication (MFA) and Data API authentication, and shares the valuable insights we gained.This blog post chronicles our journey from the initial hosting strategy to navigating the unforeseen challenges presented by FileMaker Cloud: in particular, Multi-Factor Authentication (MFA) and Data API authentication, and shares the valuable insights we gained. Read more
Read More

Taking Over From Another Developer

Taking over a new solution from another developer is no simple undertaking and many developers lose their bearings trying to spend time restructuring and enhancing areas that don’t need it. What do we need to fix and what can we still use?

Read more
Read More

Creating MySQL Tables from FileMaker

How to use FileMaker to generate MySQL syntax and easily create matching tables in MySQL.

Read more
Read More