Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless

In this blog post, we will explore a solution for optimising a FileMaker app that handles large amounts of data. We will address the challenges of data storage, file corruption, and performance degradation when dealing with historical data.

By leveraging cloud storage and serverless computing, we can offload and query this data efficiently, ensuring better performance and scalability.

Continue reading “Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless”

FM-DiSC: Handling Historical Data with FileMaker, AWS Athena, S3, Serverless

Fabio Bosisio from Beezwax demonstrates handling historical data in a Claris® FileMaker® solution, utilizing a combination of AWS services including AWS Serverless, AWS S3, and Amazon Athena’s Interactive SQL. Use cases include archiving, data mining, and reporting.

Continue reading “FM-DiSC: Handling Historical Data with FileMaker, AWS Athena, S3, Serverless”

demystify FileMaker and JavaScript [FM-JS]

You’re invited to explore this demystify(FM-JS) blog post and download this demo file – as you embark on expanding your Claris® FileMaker® solutions into the vast and captivating realm of JavaScript.

Continue reading “demystify FileMaker and JavaScript [FM-JS]”

dotfmp: Python + Claris® FileMaker® | Historical Data & AWS Athena/SQS/S3 | UX & DX for Great Solutions

Christos Savva, Fabio Bosisio and Vince Menanno from Beezwax present at dotfmp Berlin, 2023.

This week we’re in Berlin… one of the stops on the Road to Claris Engage 2024 …gathering with the developer community, and highlighting innovation for the Claris FileMaker platform development. As conference speakers at dotfmp Berlin (June 1-3), Christos Savva, Fabio Bosisio and Vince Menanno from Beezwax present three sessions:

  • Enhancing FileMaker with Python
  • What do you do with all this historical data in your app? [AWS Athena Interactive SQL / Serverless / S3 with FileMaker]
  • Elements for Building Great Solutions [FileMaker UX & DX]
Continue reading “dotfmp: Python + Claris® FileMaker® | Historical Data & AWS Athena/SQS/S3 | UX & DX for Great Solutions”

Let’s make an audit log with Claris FileMaker 2023

Claris FileMaker 2023 puts powerful, native audit logging within reach of developers, with a greatly reduced code footprint compared to existing approaches. In this blog post we introduce the OnWindowTransaction script trigger, leveraging it along with native FileMaker script transactions to create an audit log that is efficient, scalable, flexible, performant, and convenient to implement.

Continue reading “Let’s make an audit log with Claris FileMaker 2023”

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

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”

Videos: Improving Your FileMaker Code with InspectorPro 7

Illustration of a man sitting on a sofa

Five Ways InspectorPro 7 Can Improve Your FileMaker Code

Want better collaboration, performance and insight for your FileMaker development teams? With InspectorPro you can leverage advanced diagnostics, perform in-depth analysis, and gain insights with new visualizations.

Check out these videos from InspectorPro creator & Beezwax Chief Innovation Officer, Vince Menanno.

 

 

Problem Reports Dashboard

Track your progress while reducing problem code, and reducing technical debt.

 Watch now 

 

 

 

Script Monitor

Create a visual and interactive representation of your script interactions, where you can monitor them and stay aware of their activities.

 Watch now 

 

 

 

Search with LOgiCATOR

Locate InspectorPro 7 data with logical precision, including constrained and unconstrained finds within your solution analysis.

 Watch now 

 

 

 

Security Perspective

Identify the privileges and security levels assigned to various user roles for each script.

 Watch now 

 

 

 

Advanced Information

Identifying indirection, scripts states and more.

 Watch now 

 

 

 

Special Offer

Book an InspectorPro consultation at a special rate.

 Book now 

 

 

Native HTML Email in Claris® FileMaker®

Claris FileMaker has built-in methods to send email in HTML format, using SMTP protocols. I’ll cover what this means, how to use this functionality, and use FileMaker to send basic HTML email.

Continue reading “Native HTML Email in Claris® FileMaker®”

The New Horizon: Script Transactions in Claris® FileMaker®

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 transactionallyall or nothing is the law of the data.

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

Transacting Transactions in Claris FileMaker

Vince Menanno from Beezwax presents at FMDiSC (FileMaker Developers in Southern California).

You may have read on Claris’s blog that “Developers are excited to use Claris FileMaker 19.6!” As Vince Menanno from Beezwax said in an interview for that blog post:

“This FileMaker release is significant. There’s a possibility to make solutions run faster if you’re leveraging transactions, and for code to be more concise.”

– Vincenzo Menanno, Beezwax

So, let’s talk about Claris® FileMaker® and script transactions in FileMaker 19.6!

Continue reading “Transacting Transactions in Claris FileMaker”

Data Visualization in FileMaker Web Viewer

Alec Gregory from Beezwax presents at the Claris FileMaker for Research User Group.

Let’s talk about Claris® FileMaker® and data visualization with FileMaker 19 web viewer, and developing with open source tools!

Continue reading “Data Visualization in FileMaker Web Viewer”

Finer Faster FileMaker Precision: Measuring How Long It Takes

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”

DIGFM December 2022 – Script Transactions in Claris FileMaker

Vince Menanno from Beezwax presents at DIGFM.

Let’s talk about Claris® FileMaker® and script transactions in FileMaker 19.6!

Continue reading “DIGFM December 2022 – Script Transactions in Claris FileMaker”

Beezwax Sponsors EngageU: The Biggest Claris® FileMaker® Developer Conference

Christos Savva and Vince Menanno Present Rapid Serverless Integrations and FileMaker Native Script Transactions

This week, Nov 13-15, we’re in Malmö, at EngageU. It’s the biggest Claris / FileMaker Developer community event worldwide in 2022. In fact, EngageU promises to be the largest in-person Claris Community event in Europe, ever!

Continue reading “Beezwax Sponsors EngageU: The Biggest Claris® FileMaker® Developer Conference”

Design Think Your Code

Have you ever opened an existing solution, took one look at the source code – and your eyes just glazed over – as if you were attempting to decipher the Matrix?

You’ve entered the world of DX, or “Developer Experience”.

Just as User Experience (UX) refers to the experience of users, Developer Experience (DX) focuses on the experience that Developers have within the code of your system. This applies whether that’s code you inherited, code you passed on to someone, or code you originally wrote — all situations which affect a person I would call ‘Developer Next’. This could certainly be your-good-self, in six months time.

Continue reading “Design Think Your Code”

Rome FileMaker® Week: Docker, Node-RED, Native Script Transactions and a Chatbot

Vincenzo Menanno and Fabio Bosisio from Beezwax present at Rome FileMaker Week.

This week we’re in Italy… formazione, condivisione e ancora divertimento [training, sharing and more fun] …with the focus on innovations in Claris® FileMaker platform development. As realtori [conference speakers] at Rome FileMaker Week (October 6-8), Vince Menanno and Fabio Bosisio from Beezwax present three sessions:

  • Local FileMaker Development with Docker and Node-RED
  • The New Horizon: Native Script Transactions in FileMaker
  • Chatbot
Continue reading “Rome FileMaker® Week: Docker, Node-RED, Native Script Transactions and a Chatbot”

CQDF Montreal 2022 – Claris FileMaker

La 7e Conférence québécoise des développeurs FileMaker (CQDF) 2022: les 15 et 16 Septembre 2022 à l’Auberge Saint-Gabriel, Montreal. Vincenzo Menanno, Beezwax, présente “Le nouvel horizon | Transactions de script natif” avec Claris (FileMaker) Pro.

Continue reading “CQDF Montreal 2022 – Claris FileMaker”

FileMaker + Tableau | Embedded Dashboards & Expanding Possibilities

Vince Menanno from Beezwax presents at AutoEnter Live.

Let’s talk about Claris® FileMaker® and Tableau®!

As a speaker at AutoEnter Live, Vince presents Tableau as a great way for FileMaker developers to build dashboards, improve reporting, create visualizations and enable users to better understand their data. New techniques for embedding Tableau dashboards in FileMaker and using a Tableau Connector enable high-performance user interaction.

Learn more about how FileMaker + Tableau is a “match made in data heaven“, opening new possibilities as the two platforms combine to work as one.

Continue reading “FileMaker + Tableau | Embedded Dashboards & Expanding Possibilities”

System for Success: Atomic Design for Google Display Ads

The process for creating Google Display ads, using a system to optimize collaboration between Design and Marketing teams.

Our design team wanted to implement a design system that could quickly generate different variations of Google Display ads in multiple sizes. This system had to balance creative freedom and brand adherence. We wanted a user to be able to change content, colors, backgrounds, buttons and other visual elements without further involvement from a designer. However, it was important to create a controlled environment so the ads would stay on brand and follow a conceptual and visual pattern.

Continue reading “System for Success: Atomic Design for Google Display Ads”

dotfmp.berlin Claris FileMaker Developers 2022

BERLIN, Germany – Our senior developer Christos Savva attended the dotfmp.berlin 2022 “Unconference” held in June in Berlin. The conference was the first in-person opportunity in over two years for leading Claris FileMaker developers across Europe to meet, share their work, and explore what’s happening in the developer community.

At dotfmp.berlin 2022, more than 70 developers from eighteen countries talked through tools and techniques from their Claris playgrounds. Adding to that excitement was participation by Claris’s engineering and product management teams.

Continue reading “dotfmp.berlin Claris FileMaker Developers 2022”
1 2 3 6