Jump to content
  • entries
    105
  • comments
    0
  • views
    5612

Entries in this blog

Claris Studio (part 3) – Spreadsheet: Details, please!

About the author: Beverly Voth has been in the Claris FileMaker community many years. In addition to FileMaker Pro and its integrated products, she is a Full Stack Web developer & SQL database administrator. The only recipient of the FileMaker Excellence Award for Outstanding Contribution to the FileMaker Web Publishing Community (DevCon 2003), she’s been… Continue reading Claris Studio (part 3) – Spreadsheet: Details, please!Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Claris Studio (part 2) – Integration with Claris Pro

About the author: Beverly Voth has been in the Claris FileMaker community many years. In addition to FileMaker Pro & its integrated products, she is a Full Stack Web developer & SQL database administrator. The only recipient of the FileMaker Excellence Award for Outstanding Contribution to the FileMaker Web Publishing Community (DevCon 2003), she’s been… Continue reading Claris Studio (part 2) – Integration with Claris ProAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Claris Studio, Tell Me More!

About the author: Beverly Voth has been in the Claris FileMaker community many years. In addition to FileMaker Pro & its integrated products, she is a Full Stack Web developer & SQL database administrator. The only recipient of the FileMaker Excellence Award for Outstanding Contribution to the FileMaker Web Publishing Community (DevCon 2003), she’s been… Continue reading Claris Studio, Tell Me More!Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

JSON Custom Functions for FM 19.5, part 2

Demo Files JSON Custom Functions for FM 19.5, part 2 JSON Insert and Update for FM 19.5 Note: some of the CFs have been revised and/or renamed since part 1, so if you plan to use these CFs, make sure to download today’s “part 2” file. Introduction Welcome back to JSON Custom Functions for FM… Continue reading JSON Custom Functions for FM 19.5, part 2Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

JSON Custom Functions for FM 19.5, part 1

Demo File JSON Custom Functions for FM 19.5 Introduction Today we have some custom functions (CFs) that can help you accomplish various JSON-related tasks in FileMaker. Back in 2018 I had this to say about JSON custom functions… My inclination is to really understand something before I use a custom function to simplify things, but… Continue reading JSON Custom Functions for FM 19.5, part 1Afficher la totalité du billet

Sometimes Less Is More Reliable

Recently I noticed some code that had worked flawlessly for years was suddenly returning “?” instead of valid values. What it came down to was that I had renamed my file from “JSON Custom Functions” to “JSON Custom Functions for FM 19.5” Well you know those functions like ValueListItems… ValueListItems ( fileName ; valueListName )… Continue reading Sometimes Less Is More ReliableAfficher la totalité du billet

Thinking About JSON, part 4

This article is part of a series. See also… • Thinking About JSON, part 1    • Thinking About JSON, part 3 • Thinking About JSON, part 2 Demo Files Make sure to download the correct version for your locale: json.getvaluetype – decimal dot, v1 (decimal separator is a dot; thousands separator is a comma)… Continue reading Thinking About JSON, part 4Afficher la totalité du billet

Button Bar Segment Fun, part 2

This is a quick follow up to Tuesday’s article, and to avoid unnecessary repetition I will assume the user is familiar with that material. button bar segment fun, v3  (from part 1) button bar segment fun, v4  (WeTransfer link) There were some things in v3 I wasn’t completely happy about, and I realized this morning… Continue reading Button Bar Segment Fun, part 2Afficher la totalité du billet

Button Bar Segment Fun

Demo Files button bar segment fun, v1 button bar segment fun, v2 button bar segment fun, v3 Today we’re going to look at some ways single-segment button bars (SSBBs) can help produce dynamic column headings for list views and/or reports, with a goal of concentrating logic into the segment calculation and reducing schema dependencies elsewhere. This… Continue reading Button Bar Segment FunAfficher la totalité du billet

Exploring Wordlespace with SQL and While

Recently we’ve discussed optimizing SQL queries in FileMaker, and had some fun with various SQL experiments. Today we’re going to explore some ways FileMaker can use ExecuteSQL and the While function to perform letter frequency and text pattern analysis on candidate words for the popular Wordle game. The list of words comes from https://github.com/tabatkins/wordle-list and… Continue reading Exploring Wordlespace with SQL and WhileAfficher la totalité du billet

SQL Multi-Table & Miscellaneous Experimentation

INTRO Today we’re going to pick up where we left off last month, and today’s article will assume the reader is familiar with the material we covered last time (in SQL Multi-Table Query Optimization). This time we’re going to dig a little deeper into multi-table SQL queries, conduct some SQL experiments, and look at a… Continue reading SQL Multi-Table & Miscellaneous ExperimentationAfficher la totalité du billet

SQL Multi-Table Query Optimization

Demo file:  sql-multi-table-query-optimization.zip Recently a colleague requested help w/ a SQL query that was performing slowly. I wrote back: Make sure there are no records open locally, i.e., on your machine, in the tables you are querying (for more information see this article by Wim Decorte: ExecuteSQL – The Good, The Bad & The Ugly)… Continue reading SQL Multi-Table Query OptimizationAfficher la totalité du billet

JSONQuery at FM-DiSC

JSONQuery @ FM-DiSC On Friday, January 14, Steve Senft-Herrera and I will be discussing and demoing JSONQuery at FM-DiSC (FileMaker Developers in Southern California). Useful Links Current version of JSONQuery:  CF_JSONQuery_20211130_0120_PUBLIC.fmp12.zip Our recent two part in-depth interview series JSONQuery, part 1 JSONQuery, part 2 Coming soon: Steve Senft-Herrera’s demo file from the presentation Coming soon:… Continue reading JSONQuery at FM-DiSCAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Connecting Portals to JSON Arrays

Have you ever wished you could connect a portal to a JSON array? Portals and JSON arrays seem like they should be a natural fit, but FileMaker doesn’t offer us an obvious way to connect one to the other. (An example of where this might come in handy would be selection criteria for a report,… Continue reading Connecting Portals to JSON ArraysAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

JSONQuery, part 2

Continuation of interview with Steve Senft-Herrera [Editor’s note: the demo file and custom function have been significantly updated since part 1.] Demo file:  CF_JSONQuery_20211130_0120_PUBLIC.fmp12.zip  (WeTransfer link) KF: Welcome back Steve for part 2 of our JSONQuery conversation. SSH: Thank you, Kevin. KF: One thing we didn’t mention last time, because they were late-breaking additions, were the… Continue reading JSONQuery, part 2Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

JSONQuery, part 1

Interview with Steve Senft-Herrera [Editor’s note: the demo file has evolved a bit since this interview took place, and, as a consequence, screen shots shown here may deviate slightly from what you will find in the demo.] Demo file: CF_JSONQuery_20211029_1200_PUBLIC.fmp12.zip KF: Good afternoon, Steve. You’ve been developing JSONQuery over the last few years, and today… Continue reading JSONQuery, part 1Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Virtual List Reporting, part 4

Introduction Back in 2017 I wrote about a technique to enable users to a) produce multiple on-screen reports, and b) interact with those reports in browse mode. The article was called Virtual List Reporting, part 3, and while the approach it advocated works well enough under most circumstances, today I’d like to share some fresh… Continue reading Virtual List Reporting, part 4Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Set Variable By Name Re-Revisited

Demo files: set-var-by-name-v4 and set-var-by-name-md5 Background This is a quick follow up to last December’s Set Variable By Name Revisited, and to avoid repetition will assume the reader is familiar with the material that was presented in that article. But to briefly recap: 1. FileMaker does not provide an obvious way to programatically name a… Continue reading Set Variable By Name Re-RevisitedAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

PSOS – Run Script in File not open Locally

Update: See Jason Wood’s suggestion in the comments section for making this technique more secure. INTRODUCTION Today I want to take a look at a certain Perform Script On Server (PSOS) behavior, and for those who find this behavior to be inconvenient, propose a work around. Here’s the behavior, or misconception, actually: a server side… Continue reading PSOS – Run Script in File not open LocallyAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

FileMaker 19 + JSONata

Introduction Recently I had the pleasure of speaking with Jeremy Brown on The Context Podcast about an open-source project called JSONata that enables you to query and transform JSON. The JSONata site is packed with useful information, including this short video… …as well as… Extensive documentation A link to the Stack Overflow forum, where you… Continue reading FileMaker 19 + JSONataAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Bypassing Scientific Notation

Earlier today I needed 1 billion to render in the calc engine as 1000000000, but FM helpfully converts numbers to scientific notation if they A) are >= 1 billion, and B) contain nothing but zeros following the initial digits. Example where “A” and “B” are both true: Example where “A” is true but “B” is… Continue reading Bypassing Scientific Notation Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

FRAP-Map: A Flexible, Robust, Accessible and Portable Data Mapping Technique

Editor’s note: today we have a guest article by long-time FileMaker developer, Peter Doern, who has come up with an elegant, outside-the-box methodology for managing imports. This is one of the coolest techniques I’ve seen in a long time. Enjoy. FileMaker includes a powerful and fast method for importing data from a source table to… Continue reading FRAP-Map: A Flexible, Robust, Accessible and Portable Data Mapping Technique Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

When 2 is greater than 10

Today we’re going to take a quick look at a potential “gotcha” that can crop up when doing numeric comparisons. Jason DeLooze and I discussed the general behavior back in 2011 (Space Is The Place), but this time around I want to focus on one particular set of circumstances where the problem can arise. At… Continue reading When 2 is greater than 10 Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Fun with SQL Joins and Currency Formatting

Demo file: sql-join-fun-etc.zip requires FM 18 or later. Recently I was asked to create a mini-report combining data from a pair of related tables via ExecuteSQL. This provided an opportunity to think about SQL joins, and also to come up with a way to apply currency formatting to dollar amounts in the SQL query result,… Continue reading Fun with SQL Joins and Currency Formatting Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

File IDs, Table IDs and Field-Level Schema

Demo file:  file ids, table ids and field-level schema.zip (requires FM 18 or later) INTRODUCTION Recently I was asked to help document a FileMaker solution by creating and populating a “schema” table as per the above screen shot. One of the requirements was to programmatically determine internal ID numbers for the file and for the… Continue reading File IDs, Table IDs and Field-Level Schema Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

×
×
  • Create New...