@FileMakerHacks profile picture
Kevin Frank @FileMakerHacks
Joined January 2013
  • Tweets 247
  • Following 118
  • Followers 828
11 Photos and videos
For those of us who toil in the virtual list vineyard, the Get(WindowUUID) function introduced in FM 26 is a game changer. filemakerhacks.com/2026/06/1…

FM 26: Virtual List with Window UUIDs

[Some of the text in today’s article has been recycled from earlier articles.] Demo file: virtual-list-with-window-uuids.zip (requires FM 26 or later) Introduction As the whole world — or the…

filemakerhacks.com
2
26
Because life's too short to manually change conditional formatting on 504 fields one field at a time. filemakerhacks.com/2026/05/3…

FM Clipboard Tool and FMXML

Demo file: 2026-may-multipurpose-demo.zip (in addition to the above) If you are in a hurry, or prefer video explanations, I presented this material using a pre-release version of FM Clipboard Tool …

filemakerhacks.com
4
54
filemakerhacks.com/2026/04/2…

Traversing Arrays with Mod() and Floor()

Demo file: traverse-arrays-with-mod-and-floor.zip Introduction Today I want to talk about a technique that can come in handy if you need to walk a block of contiguous cells within a 2-dimensional J…

filemakerhacks.com
42
Resources for and YouTube link to my recent "tips 'n' tricks" presentation on FM Training TV. filemakerhacks.com/2026/03/2…

March 2026 FM Training Livestream

Here are links to articles and resources related to today’s FM Training Livestream presentation. YouTube link Best of FileMaker Hacks Tips, Tricks & Traps (part 4) Demo Files 2026-Mar-Livestrea…

filemakerhacks.com
49
community.claris.com/en/s/gr…
1
57
Minor updates to the custom function in the demo files accompanying yesterday's article. filemakerhacks.com/2026/01/2…

JSON Object Destringification

Today we’re going to look at an issue that can crop up in FileMaker JSON processing, and explore some approaches one might take to address this issue. Typically the issue arises with preexist…

filemakerhacks.com
45
Ever wish there were a way in FM 22 to quickly destringify a bunch of stringified objects coming in from an API? There are various ways one might go about this, and we explore a number of them here. filemakerhacks.com/2026/01/2…

JSON Object Destringification

Today we’re going to look at an issue that can crop up in FileMaker JSON processing, and explore some approaches one might take to address this issue. Typically the issue arises with preexist…

filemakerhacks.com
2
52
Ever wish you could view a field index corresponding to a found set of records? filemakerhacks.com/2025/11/0…

FM 22: Pseudo Indexing

Demo file: FM-22-Pseudo-Indexing.zip (works w/ FM 16 or later) When I wrote about Sort Values and Unique Values back in 2017, I made passing reference to an article I’d written a couple years…

filemakerhacks.com
51
Just got home from an amazing [Full Access] (fullaccess.us/) conference. Thank you Jonn Howell, and everyone who made it possible. Demo files, etc., from my JSON and Virtual List presentations -- filemakerhacks.com/2025/10/1…

Full Access

FileMaker Developers Conference

fullaccess.us
34
JSONQuery 2.1 now available @filemaker devs -- if you work with JSON you should have this in your tool kit github.com/steve-ssh/FMP_JSO…

GitHub - steve-ssh/FMP_JSONQuery: JSONQuery is a FileMaker Pro custom function which performs JSON...

JSONQuery is a FileMaker Pro custom function which performs JSON filtering/harvesting tasks - steve-ssh/FMP_JSONQuery

github.com
1
59
Recently on FileMaker Hacks (3 of 3) Virtual List Even More Simplified filemakerhacks.com/2025/10/1…

Virtual List Even More Simplified

Demo file: virtual-list-even-more-simplified.zip  [expects, but does not require, FM 22 or later] Note 1: The example in today’s article/demo is intentionally very basic. Note 2: The demo is self-p…

filemakerhacks.com
38
Recently on FileMaker Hacks (2 of 3) FM Training Livestream: Tips 'n' Tricks, part 2 filemakerhacks.com/2025/10/0…

October 2025 FM Training Livestream

Here are links to articles and resources related to today’s FM Training Livestream presentation: Best of FileMaker Hacks Tips, Tricks and Traps, part 2 YouTube link Best of FileMaker Hacks Ti…

filemakerhacks.com
1
37
Recently on FileMaker Hacks (1 of 3) FM Training Livestream: Tips 'n' Tricks, part 1 filemakerhacks.com/2025/09/1…
28
Thank you Kentuckiana FileMaker Developers for inviting me to present on JSON custom functions and JSONQuery. Links to demonstration files and YouTube vids here. filemakerhacks.com/2025/08/2…

Kentuckiana FM Developers JSON Presentation

Here are links to articles and resources related to today’s KYFMP presentation on JSON custom functions and JSONQuery. YouTube links Jan 2025 FM Training Livestream: JSON Custom Functions Aug…

filemakerhacks.com
81
Was just playing around in the FileMaker data viewer and felt like sharing.
1
2
174
filemakerhacks.com/2025/08/0…

Another Tip for MBS “Check Variable Names”

This is a quick follow up to A Tip for MBS “Check Variable Names” from earlier this year. The other day I noticed variable name checking wasn’t working in one of my scripts. The culprit turne…

filemakerhacks.com
46
Why? Just because. filemakerhacks.com/2025/08/0…

Boxed Summary Groups for Reports

Demo file:  boxed-summary-groups.zip Recently I needed to produce a summary report with variable height rows and each group enclosed in a rectangular box. To make the challenge more interesting, th…

filemakerhacks.com
1
54
filemakerhacks.com/2025/07/2…

FileMaker Pro 22: Initial Impressions

Demo Files Minimum version to open the file shown in parentheses. GetRecordIDsFromFoundSet.zip  (FM 22) JSONParse Sandbox  (FM 22) JSON Array Virtual List Reporting  (FM 18) Josh Halpern’s Vi…

filemakerhacks.com
4
60
filemakerhacks.com/2025/06/0…
2
4
151
filemakerhacks.com/2025/05/1…
3
66
Load more