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

CEO Update & DrSnip: Web App Success Stories

We all know that Claris has added significant new capabilities in the last several versions of FileMaker Pro for creating custom web applications, especially with the introduction of the FM Data API in FileMaker 16. With the recent successful production deployment of a new custom web app project, I thought it would be a good time to write a blog post about a couple of web applications we’ve done for clients utilizing FileMaker Pro as the back end database engine.

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