Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FileMaker Magazine

A blog by FileMaker Magazine in Affiliate Blogs

  • Entries

    564

  • Comments

    6

  • Views

    80,077

Entries in this blog

Finding Scripting Errors

As any FileMaker solution grows, it's inevitable that errors will creep in as methods and scripts are updated with newer features. And with every new script you add, you're also introducing new opportunities for errors. For the longest time, we've relied on the Pause on Error checkbox to invoke the debugger when an error occurs. While useful, the constant pop-up of the debugger can quickly interrupt your development "flow" — and honestly, it gets a bit annoying. Starting with FileMaker 18, we

FileMaker 2025 (v22) - GetRecordIDsFromFoundSet()

One of the fundamental methods for loading a found set of records in FileMaker has traditionally been storing and using the key values of a selected set of records. With the powerful Go To Related Record script step, you can easily load any number of records. This can be achieved through either a global field relationship or a standard schema relationship. However, with the established method, if you want to store and reload a found set, you need a few additional elements: a Summary field (low

FileMaker 2025 (v22) - Grouping Enhancements

Aside from the welcome user interface refresh in FileMaker 2025, a valuable enhancement has been made to the existing grouping feature. This update encourages greater use of grouped layout objects and helps reduce the number of layout-based calculations, a point of frustration with the previous limitation. Prior to FileMaker 22, if you applied either a button action (now discouraged) or a hide calculation, you had to ungroup the object before adding anything new to the group. This often caused

Using GetLiveText()

Becoming familiar with all of FileMaker’s possible technology integrations can take many years. Often, the learning process happens as a side effect of solving a specific need. While you can use almost any other programming language alongside FileMaker, the built-in features can be a breath of fresh air, especially if you haven’t tried them before. In this video, I take a look at the GetLiveText feature, introduced in version 19.5, which is supported on both macOS and iOS. If you’re using FileM

Quick Native Charting

One of the greatest advantages of FileMaker's built-in charting tool is its immediate access to aggregated data. This is especially useful when you don't need highly customized charts. If you do require full visual control, using a Web Viewer with JavaScript typically offers much greater flexibility. The downside to that approach, however, is the development time required to extract the data from FileMaker and format it for use in JavaScript. Fortunately, with the help of AI, that process has be

Building Faster Solutions Using Open Quickly

One of the powerful new features in recent versions of FileMaker Pro is the Open Quickly feature. While it initially had issues with giving users too much access, those concerns have been resolved through updated privilege settings. In this short video, I focus on a few things you can do with the Open Quickly feature. From jumping to fields several tables away to managing multiple layouts while working on your design, adopting the Open Quickly feature can significantly speed up your development

Elegant Panel Wizard

Having a few pieces of code that can be easily replicated into any solution is one of the best ways to achieve efficiency in development. Yes, AI is revolutionizing how we build solutions, but it's still important to have a personal "treasure chest" of code you're familiar with and don’t need to re-learn. In this video and technique file, we take a look at just one of many ways to create a wizard-like, multi-step process. Using a slider is likely one of the simplest methods for collecting data

Better UI Settings

Longtime FileMaker developers have often used the database itself to store values for various user interface settings. This is valid, because, where else would you store them? A common approach is individual fields. However, there are a few problems with this. First, it adds "noise" to your data structure, making it harder to distinguish between actual data fields and those used for other purposes. For example, you might ask, "Is this an actual data field or is it used for something else?" Sec

FMIndent - FileMaker Code Formatting

FileMaker developers who use editors like VS Code, IntelliJ IDEA, BBEdit, or even VIM are very familiar with the modern conveniences expected from a code editor: linters, code completion, formatting, syntax highlighting, and more. In FileMaker, however, we've been stuck in the 90s for quite a while. One of my favorite tools is Typinator, which offers extensive text manipulation capabilities. Recently, a new tool for Mac developers was released that addresses the lack of a full-fledged editor. F

ForEach Function for Scripted Loops

When it comes to doing the same thing over and over again, you really can't beat a loop. It's the wet side of DRY (Don't Repeat Yourself), where the "Don't" turns into a very big "Please, yes, DO." The trick with loops, especially when you're processing a lot of data like JSON, is that you often have to manage multiple iterators, counts, and all the little bits and pieces needed for a successful outcome. One of the wonderful things about many other languages, like Python, PHP, JavaScript, and

Complex Conditional Formatting

Breaking down complex logic into manageable chunks of code is the smartest thing you can do when it comes to conditional formatting. Especially when it needs to account for an increasingly wider number of conditions. This week's video deals with what seems like a simple solution to solve, yet it comes with all kinds of complex little pieces to make the solution provide the end result desired. If you enjoy the type of video which is a bit of a solution walk-thru, where I discuss how things are

Effective Solution Settings

Every solution starts out like an infant. It knows very little and works hard to manage your solution's data as it becomes a productive citizen of your digital society. As it grows, your solution will need to offer a variety of options. User A prefers things one way, while User B another. Your job, as the developer, is to accommodate those whims and preferences, or settings as we’ll call them, in the most efficient way possible. As is somewhat typical, you may be halfway through development whe

Using Gateway Files

One of the greatest joys of working in technology is that you never really have to stop learning - although you certainly can. Everything also moves so fast that it often feels like you can’t keep up. The great thing about FileMaker is that you're not stuck in the '80s or '90s when the software first started - you get to explore as widely as you like. FileMaker can literally reach into almost all aspects of technology. You can learn about relational structure, SQL, REST, web APIs, and whatever

Critical Graphics Knowledge

Even to this day, after providing FileMaker-related technical education for many years, I still see solutions with less-than-optimal structure and storage. When it comes to graphics, “all things add up.” The cumulative cost of data or technical debt often comes back to bite you when you’re trying to refactor an old solution to meet modern standards. This video showcases what I know about storing and using graphics within your FileMaker layouts. If you’re unaware of how large images impact perfo

Re-Theming Existing Solutions

When tackling the task of updating a UI/UX look and feel, it can quickly become overwhelming — especially if you have hundreds of layouts and countless individual styles, some in use and others deprecated. While designing a new solution from scratch allows you to take advantage of modern best practices, many existing solutions have simply relied on the Default style and applied it across numerous layouts. The goal of this video is to demonstrate how you can achieve an updated look without disr

Execute Data API - Stateless CRUD

Continuing from a previous video that introduced the Execute FileMaker Data API script step, this video explores the remaining CRUD operations added in FileMaker 21+. With the create, update, duplicate, and delete actions, we can now leverage more stateless data operations thanks to direct write access to tables. This video walks through the new write capabilities of the Execute FileMaker Data API script step. Along the way, we’ll also share tips and tricks for writing Custom Functions and exp

Execute Data API To Custom API

The Execute FileMaker Data API script step has been around for quite a few years. It was introduced in FileMaker 19, around 2020. If you haven't used it, you may be manually creating JSON for your records when you don’t need to — FileMaker can do this for you. I covered this script step in a video in 2021, explaining how the REST/Data API functionality translates into internal use. While some features perform better than the Execute Data API step — ExecuteSQL() being one of them — it requires a

Collecting Related Data

Every development task involves both what you know and what you don’t. The key to achieving the desired outcome often lies in learning what you don’t yet understand. That’s exactly what we’ll explore in this video – how to collect data from related tables for use in various ways. If you haven’t used the GetNthRecord() function before, this video provides a perfect example of one of its applications. When combined with the While() function, you can build virtually any data structure to help you

Managing Layout State

One of the best feelings when developing is making new discoveries and finding solutions to common problems you didn’t know how to solve before. In this week’s video, I present an overarching solution for managing the layout state of any layout within your application. I also introduce a highly useful method for both managing and executing a universal sort on any field present in the layout. The combination of managing the layout state with the introduction of a universal sorting script will si

Ultimate JSON Part 2

The first and most common way you'll likely use JSON within your FileMaker solution - should you choose to adopt it for this purpose - is as your primary method for passing script parameters. If you haven’t done so yet, it is highly recommended that you use JSON for script parameters. Not only does this provide an opportunity to become thoroughly familiar with the format, but it also helps you understand the most common method of transmitting data when working with nearly any internet-based API

UI Tweaks & Maintenance

Designing layouts in FileMaker is one of my favorite aspects of the platform. The ability to simply drag and position elements exactly where you want them feels akin to being a painter, free to use any tools and materials you choose. FileMaker strikes a remarkable balance between the creative and technical sides of development. Like all things, achieving the desired results requires knowing a few tricks. Whether it's about stacking objects efficiently or minimizing their number, it's up to the

Learning Webhooks via Google Forms

Capturing external data directly into FileMaker has always been a bit of challenge due to the variety of technologies required to set everything up. In the past, XML and PHP were commonly used, taking advantage of direct integrations available in FileMaker Server. Even earlier, during the "wild west" days of FileMaker, some systems remarkably relied on AppleScript to facilitate data exchange. Claris, then operating as FileMaker, Inc., provided libraries and methods to enable these connections.

Coding Efficiency

One of the great things about being a developer is finding flow. It’s that feeling when you’re cranking out code, accomplishing one task after another, and time seems to fade into the background - you’re in the zone. However, a few things can really disrupt your flow, and one of the biggest culprits is your development environment. If your syntax highlighting doesn’t work, or your environment slows you down, productivity takes a hit. That’s why one of the best things any coder can do is optimiz

Using Color Effectively

When incorporating graphic design into your FileMaker solution, you might either be the sole designer or collaborate with someone to enhance the user experience. Regardless of your role, it's always beneficial to understand how to effectively use colors within your solution. You can, obviously, make straightforward choices, such as simple selections of colors from the built-in color picker. But, there are additional tips and techniques that can significantly enhance your ability to use colors s

Using Web Workers

Taking advantage of JavaScript within FileMaker is a crucial skill that can significantly enhance your solutions. Relying solely on native FileMaker capabilities can be limiting, as certain tasks are more effectively handled with JavaScript. Using a Web Viewer to execute JavaScript comes with nuances. For instance, when a JavaScript process takes longer than a few milliseconds, providing a visually appealing progress indicator can greatly improve the user experience. This is where the concept o

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.