FileMaker and IT, Computer News
Ultimate FileMaker Course – 02 – Settings & Prefs
Ultimate FileMaker Course – 01 – Environment
Critical Values Functions
Working with simple lists of values is one of the most fundamental aspects of building software. FileMaker, like any other development environment, often requires working with lists of values, whether it's a global field used as a relationship key or multiple...
Finding Scripting Errors
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...
FileMaker 2025 (v22) – Grouping Enhancements
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...
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...
Building Faster Solutions Using Open Quickly
Elegant Panel Wizard
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,...
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...
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...
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...
Effective Solution Settings
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...
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...
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...