Author: Vincenzo Menanno

Records, Go Get ‘Em in Claris FileMaker 2025

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker 2025, Performance, Techniques

As a FileMaker developer, I have powerful tools. But I have long wished for a highly-efficient mechanism for representing and reproducing any arbitrary set of records. Now, it’s here, with FileMaker 2025:

• GetRecordIDsFromFoundSet – function
• Go To List of Records – script step

This is fantastic. Something I have wished – for a long, long time!

Now let’s cover these new methods, with an example file (which you can also download – see below).

Continue reading “Records, Go Get ‘Em in Claris FileMaker 2025” →

FileMaker Perform Script on Server: Episode IX – Endless PSoS Abilities

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 2024, FileMaker Server, Techniques

If you go looking for a FileMaker script step called Perform Script on Server on Server, you are not going to find it. Because this isn’t a new script step, but rather the same Perform Script on Server (PSoS) that we have always had, except that now it is FileMaker Server-compatible.

This capability allows FileMaker to fire off other Perform Script on Server scripts (from an existing script that is running on server), and either wait for those to complete or not. I have been thinking that with this feature one could build a main controller script and a set of worker scripts. That is just one idea, of many, I am sure.

Continue reading “FileMaker Perform Script on Server: Episode IX – Endless PSoS Abilities” →

AI with FM – Amazing Intelligence with FileMaker 2024

by Vincenzo Menanno
Posted in AI, AI with FM, All, Claris Development, FileMaker, FileMaker 2024, FileMaker Server, InspectorPro, Integration, Techniques, Tools & Add-ons

Vince reacts with details, and his share of amazement, to the experience of pair programming with ChatGPT as co-pilot, searching for deeper meaning in FileMaker scripts using semantic search (using InspectorPro 8), and the overall experience using AI with FileMaker 2024.

Continue reading “AI with FM – Amazing Intelligence with FileMaker 2024” →

EngageU 2023 – Most Inspiring Claris FileMaker Development Conference

by Vincenzo Menanno
Posted in Beezwax News, Business, Claris Connect, Claris Development, Community, Events, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Data API, FileMaker Server, InspectorPro, Integration, News, Performance, Security, Tools & Add-ons

I collected some thoughts and observations from EngageU 2023, the European Claris / FileMaker Developer Conference held Nov 12-14 in Antwerp. Beezwax was proud to be a sponsor. There were plenty of technical discussions, a few described here, and even moreso, plenty of things that should make us all inspired heading toward 2024. If last year’s conference were the “Biggest Claris FileMaker Conference of 2022“, this year’s EngageU was the Most Inspiring, as well as the Biggest of 2023.

Continue reading “EngageU 2023 – Most Inspiring Claris FileMaker Development Conference” →

FileMaker 2023 Perform Script on Server with Callback – Episode IV: Call Ya Later

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 2023, FileMaker Server, Performance, Techniques

FileMaker 2023 introduces Perform Script on Server with Callback, a new asynchronous method to execute scripts with FileMaker Server. Now we have a way for FileMaker Server to execute another script, a “Callback” script, when one script is done processing via Perform Script on Server. It’s like calling your virtual assistant and instead of waiting on the phone for 5 minutes for info, they basically call you back when they are ready with an answer.

The end result is improved performance, better management of complex script workflow, enhanced user experience, and new possibilities for handling integration with APIs, email and services like Claris Connect.

Continue reading “FileMaker 2023 Perform Script on Server with Callback – Episode IV: Call Ya Later” →

The New Horizon: Script Transactions in Claris® FileMaker®

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Server, Performance, Software Design, Techniques

Script transactions in Claris FileMaker are finally here, but wait! Haven’t we done “transactions” in FileMaker for a long time? Yes and Yes. But script transactions are different and the main advantages, that I see, are the possibilities of simplifying code and improving solution performance. I’ll elaborate on these in this post. And, of course, there is also the inherent benefit of doing things transactionally … all or nothing is the law of the data.

Continue reading “The New Horizon: Script Transactions in Claris® FileMaker®” →

Finer Faster FileMaker Precision: Measuring How Long It Takes

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Server, Logging, Monitoring, Performance, Techniques, Testing

I often like to measure performance, because I am curious if some small change can lead to subtle, or maybe not so subtle, improvements. For the longest time my Swiss Army knife for measuring Claris® FileMaker® performance has been:

Get ( CurrentTimeUTCMilliseconds )

Continue reading “Finer Faster FileMaker Precision: Measuring How Long It Takes” →

The Metadata-verse: FileMaker Server Save as XML

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 19, InspectorPro, Integration, Performance, Tools & Add-ons

As Claris gets further into an Agile groove, there are product releases more often, always with new features and improvements. Claris FileMaker 19.5 is no exception. It includes many new features, expanded extensibility, performance enhancements, and reliability improvements. I want to bring attention to one simple thing that promises to change the world for many of us in the FileMaker developer community: Save a Copy as XML…and the performance improvements running this on FileMaker Server.

Continue reading “The Metadata-verse: FileMaker Server Save as XML” →

A fast, flexible Tableau Connector for FileMaker

by Vincenzo Menanno
Posted in All, Claris Development, Data Analytics, FileMaker, FileMaker 18, FileMaker 19, FileMaker Data API, FileMaker Server, Integration, Performance, Tableau, Tableau FM, Techniques, Tools & Add-ons

Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector.

For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK (provided by Tableau) to connect to datasources on FileMaker Server. The TACO method uses JDBC rather than the FileMaker Data API for the connection between FileMaker and Tableau, and in our testing the performance of data extracts was up to 10 times faster.

Continue reading “A fast, flexible Tableau Connector for FileMaker” →

FileMaker Performance on Apple silicon | Astounding!

by Vincenzo Menanno
Posted in Claris Development, FileMaker, FileMaker 19, FileMaker Server, News, Performance, Server Administration, Tableau FM, Testing

When the Apple silicon Macs with M1 chips came out, I read and watched many of the reviews. Most of them had great things to say about the promise of Apple’s new M1 chip…I was impressed. When I finally received my Apple M1 MacBook Pro, and started to use it…I was amazed.

Back in 2020, FileMaker Pro wasn’t optimized yet for Apple silicon processors, but ran fine under Rosetta emulation. On my M1 MacBook Pro, it already felt much faster than running FileMaker “natively” on an Intel-based MacBook…I was astonished.

I started running the just-released Claris FileMaker® 19.3, with native support for Apple’s M1 chip, on a new MacBook Pro. In a word: Astounding!

Continue reading “FileMaker Performance on Apple silicon | Astounding!” →

InspectorPro 7.2 for FileMaker – Faster on M1!

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 19, FileMaker Cloud, FileMaker Server, InspectorPro, Performance, Tools & Add-ons

Everything about the M1 Apple silicon leaves you simply delighted and surprised. It’s like the first time you drive a super-charged Tesla and feel the rush of powerful acceleration OR I imagine it’s like when Han Solo first blasts the Falcon into light speed: it must be experienced to be believed.

Continue reading “InspectorPro 7.2 for FileMaker – Faster on M1!” →

Claris Connect in action

by Vincenzo Menanno
Posted in All, Claris Connect, Claris Development, FileMaker, FileMaker 19, Integration, Tools & Add-ons

Doing the simple is hard. Someone recently reminded me of this when discussing business workflow. Tasks like scheduling, calendaring, communicating and sending notifications are individually manageable, in a world where tools for these tasks exist online. Calendars, email, databases, Slack, and a collection of other apps and services make this possible.

Continue reading “Claris Connect in action” →

Imports without Tariffs. Natively, with FileMaker Server.

by Vincenzo Menanno
Posted in FileMaker 18, FileMaker Server, Performance, Techniques

Combining functions, features, or steps in creative new ways can deliver productive results. I was thrilled to discover in FileMaker 18 that the new file-based script steps give us the ability to perform imports natively on FileMaker Server, with no configuration or changes needed.

Continue reading “Imports without Tariffs. Natively, with FileMaker Server.” →

Tableau to FileMaker | Scheduled Extracts

by Vincenzo Menanno
Posted in Data Analytics, FileMaker, FileMaker 17, Tableau FM

Once you have crafted a Tableau dashboard, pulling data from your FileMaker solution, then your next goal might be to make sure the dashboard data gets refreshed at regular intervals, and in an efficient manner. And that is what we’ll do in this blog post.

Continue reading “Tableau to FileMaker | Scheduled Extracts” →

FileMaker to Tableau | The Learning Journey

by Vincenzo Menanno
Posted in Data Analytics, FileMaker, FileMaker 17, FileMaker Server, Integration, Tableau FM, Tools & Add-ons

Now that the FileMaker Data API has been officially released (with FileMaker 17), it is time to share an update on Tableau-to-FileMaker integration. I originally wrote about integrating Tableau and FileMaker to create a match made in data heaven. I’ll also be speaking on “FileMaker + Tableau” at FileMaker DevCon 2018.

Continue reading “FileMaker to Tableau | The Learning Journey” →

How Transactional is the FileMaker Data API?

by Vincenzo Menanno
Posted in FileMaker, FileMaker 16, FileMaker 17, FileMaker Data API, FileMaker Server, Integration, Performance, Techniques

I’m always excited each time the FileMaker Platform gets new capabilities. It isn’t just the new features on their own that make things interesting, but what happens to the platform as a whole which provides for some interesting and inspiring innovations. In this case, it is a new way to do transactional record editing in FileMaker. This is the first in a multi-part series on this topic.
Continue reading “How Transactional is the FileMaker Data API?” →

FileMaker Data Migration Tool – New Ways To Code In Complex Environments

by Vincenzo Menanno
Posted in FileMaker, FileMaker 17, Techniques, Tools & Add-ons

One of the most exciting new features of FileMaker 17 isn’t part of the product, technically: it’s a command line function called the Data Migration Tool. You invoke it from the terminal, but don’t let that fool you. This is a uniquely powerful tool, one that honors the pitfalls of developing in a hosted, high-trafficked app — finally.

The Data Migration Tool allows you to merge two files, so you can develop in an offline copy and then migrate the live system into your improved app. Migration includes user accounts, value lists, serial numbers and of course data, all at once.
Continue reading “FileMaker Data Migration Tool – New Ways To Code In Complex Environments” →

Logging PSoS Activity: Episode III – Return of the JSON

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, JSON, Logging, Performance, Security

In looking back at our initial approach to logging FileMaker PSoS (Perform Script on Server) activity, I reflect back on a number of times where this has been extremely helpful. If you have come to rely on the benefits of PSoS then you also know some of its challenges — one of the biggest is debugging and monitoring how long sessions take.

Since FileMaker 16 introduced JSON, in new systems we’ve switched over to using JSON as the main way of exchanging data for parameters. Because we also use PSoS in new systems, we updated our method for PSoS Logging and this blog entry talks about the changes we made there and also restates the usefulness of this log.
Continue reading “Logging PSoS Activity: Episode III – Return of the JSON” →

FileMaker & Tableau | A Match Made in Data Heaven!

by Vincenzo Menanno
Posted in All, Beezwax News, Data Analytics, FileMaker, FileMaker 16, FileMaker 17, Integration, Tableau FM

Last year when I wrote this blog post we were talking about FileMaker 16 and the Data API being in beta. Now that FileMaker 17 has officially been released and along with it the Data API is out of beta and is a version 1.0.

Continue reading “FileMaker & Tableau | A Match Made in Data Heaven!” →

FileMaker & Tableau | Building Dashboards with Interactivity

by Vincenzo Menanno
Posted in All, Beezwax News, Community, Data Analytics, FileMaker, FileMaker 15, InspectorPro, Tableau, Tableau FM

If you’ve been working with FileMaker, then I don’t have to sell you on the fact that it’s a great solution to help you manage your data. Whether you’re an in-house developer, a consultant, or just starting to explore what is possible with this powerful platform, you will at some point come across the need to build in some kind of dashboard. Maybe your group needs to see sales trends for the last year or perhaps you have a system that tracks projects and want to see the daily average of tasks completed. In either case, dashboards are a great way to synthesize large amounts of information and provide you with insight in a simple and informative visual design.

Continue reading “FileMaker & Tableau | Building Dashboards with Interactivity” →

1 2