Here are links to articles and resources related to presentations/discussions I will be participating in at the [Full Access] un-conference Oct 20-23, 2025.
JSON Demo Files
- oct-2025-json-demo-files-rev3.zip [19Mb compressed]
JSON Articles
- Thinking About JSON, part 1
- Thinking About JSON, part 2
- Thinking About JSON, part 3
- Thinking About JSON, part 4
- JSON.GetValueType
- JSON Custom Functions for FM 19.5, part 1
- JSON Custom Functions for FM 19.5, part 2
- JSON Custom Functions for FM, part 3
- Ordering Elements within JSON Objects
- OnWindowTransaction JSON
- Fast Summaries to JSON part 1 and part 2
- Jan 2025 – YouTube presentation: JSON Custom Functions
JSONQuery
- https://github.com/steve-ssh/FMP_JSONQuery
- JSONQuery, part 1
- JSONQuery, part 2
- Jan 2022 – FMDiSC YouTube presentation (Steve & Kevin)
- Feb 2022 – FMDiSC YouTube presentation (Steve goes under the hood)
- JSONQuery v2 Conversation with Steve Senft-Herrera, part 1
- JSONQuery v2 Conversation with Steve Senft-Herrera, part 2
- Jul 2024 – DIGFM YouTube presentation (Kevin w/ Steve)
- Sep 2024 – FMDiSC YouTube presentation (Kevin w/ Steve)
- JSONQuery Odds and Ends
Virtual List Demo Files
- oct-2025-virtual-list-files.zip [300+ Mb compressed]
Virtual List Articles
- Virtual List Simplified (for FM 21 and earlier)
- Virtual List Even More Simplified (for FM 22 and later)
- Long Documents in FileMaker 11
- Conditional Subsummary Report in Browse Mode
- Faux Subsummaries via JSON + Virtual List
- Fast Summaries Revisited and Re-revisited
- Virtual Portal part 1 and part 2
- Connecting Portals to JSON Arrays
- PDF Trickery (the “custom paper size” trick)
- Sorting on a Field Rep > 1
- Virtual List on Steroids – part 1 & part 2
- Virtual List Reporting, part 4
SQL Articles
- FM 12 ExecuteSQL, part 1
- ExecuteSQL: Dynamic Parameters, part 1 & part 2
- ExecuteSQL: Robust Coding, part 1 & part 2
- The Missing FM 12 ExecuteSQL Reference
- PDF version of FM 12 ExecuteSQL Reference
- FM 14: Separation Model Data Mining
- ExecuteSQL: Using IN with Faux Dynamic Variables
- GetFieldName Revisited
- Fun with SQL Joins and Currency Formatting
- SQL Multi-Table Query Optimization
- SQL Multi-Table & Miscellaneous Experimentation
- Exploring Wordlespace with SQL and While
- Databuzz: Using ExecuteSQL to Query the Virtual Schema/System Tables
- Databuzz: Changes to Querying the FileMaker System Tables