Jump to content
  • entries
    78
  • comments
    0
  • views
    3348

Entries in this blog

A Simpler Backup Script

Demo file: backup-simplified.zip Like many developers I go back and forth between developing locally and in a hosted environment, and many years ago, I posted a couple articles featuring a simple backup script to create on-the-fly backups when working on local files. Recently a colleague pointed out that this backup routine, which I last wrote… Continue reading A Simpler Backup Script Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Render Found Set as JSON Object

Demo file: found-set-to-json-object.zip (40MB; requires FM 18 or later) [Author’s note: the demo file is a work in progress. Modify it as you see fit.] Today we’re going to compare various methods one might consider employing to render an arbitrary found set as a JSON object. The demo consists of a table of US customers… Continue reading Render Found Set as JSON Object Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Render Found Set as JSON Object

Demo file: found-set-to-json-object.zip (40MB; requires FM 18 or later) [Author’s note: the demo file is a work in progress. Modify it as you see fit.] Today we’re going to compare various methods one might consider employing to render an arbitrary found set as a JSON object. The demo consists of a table of US customers… Continue reading Render Found Set as JSON Object Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates Afficher la totalité du billet

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates Afficher la totalité du billet

A JSON Miscellany

Today we’re going to look at a bug fix in FM 19, and a free web service that returns useful information in JSON format. Fixed in 19: JSON validation bug In FM 18 (but not in 16 or 17) JSONFormatElements and other JSON functions can mask mangled JSON errors, making them harder to detect and… Continue reading A JSON Miscellany Afficher la totalité du billet

A JSON Miscellany, part 1

In this 2-part series, we’re going to take a look at various JSON-related topics, including a bug fix in FM 19, two free web services that return useful information in JSON format, and several ways to parse a found set into a JSON object. Fixed in 19: JSON validation bug In FM 18 (but not… Continue reading A JSON Miscellany, part 1 Afficher la totalité du billet

FilterValues, part 2

Sometimes it happens that the real value of a blog posting emerges in the comments section. Such was the case last time, when Paul Jansen posted an elegant little workaround to remedy a performance issue with the FilterValues function. Paul’s workaround is deserving of its own demo, and that’s what we’re going to look at… Continue reading FilterValues, part 2 Afficher la totalité du billet

FilterValues, part 2

Sometimes it happens that the real value of a blog posting emerges in the comments section. Such was the case last time, when Paul Jansen posted an elegant little workaround to remedy a performance issue with the FilterValues function. Paul’s workaround is deserving of its own demo, and that’s what we’re going to look at… Continue reading FilterValues, part 2 Afficher la totalité du billet

FilterValues

Today we’re going to do some experiments with the FilterValues function, which takes two return delimited lists for input… FilterValues ( textToFilter ; filterValues ) …and produces the intersection of the two lists as output. With the above in mind, when the function was first introduced back in 2004, I assumed that these two statements… Continue reading FilterValues Afficher la totalité du billet

FilterValues

Today we’re going to do some experiments with the FilterValues function, which takes two return delimited lists for input… FilterValues ( textToFilter ; filterValues ) …and produces the intersection of the two lists as output. With the above in mind, when the function was first introduced back in 2004, I assumed that these two statements… Continue reading FilterValues Afficher la totalité du billet

Ordering Elements within JSON Objects

Introduction If you’ve generated JSON objects via FileMaker, you’re likely aware of the disparity between the order in which you specify the elements, and the order in which they subsequently appear (i.e., alphabetized by key name). As I wrote two years ago (in Thinking About JSON, Part 2)… Both JSONSetElement and JSONFormatElements will automatically alphabetize… Continue reading Ordering Elements within JSON Objects Afficher la totalité du billet

Ordering Elements within JSON Objects

Introduction If you’ve generated JSON objects via FileMaker, you’re likely aware of the disparity between the order in which you specify the elements, and the order in which they subsequently appear (i.e., alphabetized by key name). As I wrote two years ago (in Thinking About JSON, Part 2)… Both JSONSetElement and JSONFormatElements will automatically alphabetize… Continue reading Ordering Elements within JSON Objects Afficher la totalité du billet

GetFieldName Revisited

Long time readers of this blog will be familiar with the following scenario — An ExecuteSQL expression is given, e.g., ExecuteSQL ( " SELECT SUM ( net_amount ) FROM cc_transactions WHERE batch_date = ? AND batch_region = ? AND card_type = ? " ; "" ; "" ; $theDate ; $theRegion ; $theCard ) …followed… Continue reading GetFieldName Revisited Afficher la totalité du billet

GetFieldName Revisited

Long time readers of this blog will be familiar with the following scenario — An ExecuteSQL code example is given, e.g., ExecuteSQL ( " SELECT SUM ( net_amount ) FROM cc_transactions WHERE batch_date = ? AND batch_region = ? AND card_type = ? " ; "" ; "" ; $theDate ; $theRegion ; $theCard )… Continue reading GetFieldName Revisited Afficher la totalité du billet

Virtual Portal, part 2

[Note: several hours after posting this article I realized the “Hide Object” calc could be streamlined. Screen shot and demo have been updated to reflect this.] Demo file: virtual-portal-v2b.zip (requires FM 18 or later) This is a quick follow up to the Virtual Portal article I posted the other day. As you may recall, the… Continue reading Virtual Portal, part 2 Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Virtual Portal, part 2

Demo file: virtual-portal-v2.zip (requires FM 18 or later) This is a quick follow up to the Virtual Portal article I posted the other day. As you may recall, the objective was to use virtual list to display disparate entities in a portal… …via an array like this… …which was auto-generated via a Hide Object calculation… Continue reading Virtual Portal, part 2 Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Virtual Portal

Demo file: virtual-portal-v1b.zip This is a follow-up to last month’s article on virtual list, and this time we’re going to explore a way to use virtual list in a portal. Imagine you have built a system where a Company can be a parent of a Mill, Refinery, Estate, or another Company. Each of these entities… Continue reading Virtual Portal Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Virtual Portal

Demo file: virtual-portal.zip This is a follow-up to last month’s article on virtual list, and this time we’re going to explore a way to use virtual list in a portal. Imagine you have built a system where a Company can be a parent of a Mill, Refinery, Estate, or another Company. Each of these entities… Continue reading Virtual Portal Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Virtual List Simplified

Demo file: virtual-list-simplified.zip Note 1: The example in today’s article/demo is intentionally very basic. Note 2: The demo is self-populating to keep the data current, so the values you see in the screen shots will not exactly match those you encounter in the demo. Recently I had the pleasure of discussing virtual list with Paul… Continue reading Virtual List Simplified Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Virtual List Simplified

Demo file: virtual-list-simplified.zip Note 1: The example in today’s article and demo file is intentionally very basic. Note 2: The demo is self-populating to keep the data current, so the values you see in the screen shots will not exactly match those you encounter in the demo. Recently I had the pleasure of discussing virtual… Continue reading Virtual List Simplified Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Table Of Contents for FileMaker Hacks

As 2019 draws to a close, I am mildly astonished to note that FileMaker Hacks is now nine years old. As promised in my recent conversation with Jeremy Brown, and in response to a number of  reader requests, here, for the first time, is a comprehensive table of contents (as of December 2019). While some… Continue reading Table Of Contents for FileMaker Hacks Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

2-Column Magic Value Lists, part 2

Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Introduction This is a quick follow-up to last month’s article on 2-Column Magic Value Lists, and, to avoid repetition, will assume the reader is familiar with that material. A colleague pointed out that… Continue reading 2-Column Magic Value Lists, part 2 Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

2-Column Magic Value Lists

Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Acknowledgements: today’s article would not have been written without the inspiration provided by Bruce Robertson, John Ahn (FM 12 ExecuteSQL Unconference Session), Andries Heylen (Magic Value Lists), Marcel Pinyero (How to Extend FileMaker… Continue reading 2-Column Magic Value Lists Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

FM18: JSON.InsertArrayElement

Disclaimer: the technique shown in this article is provided on an as-is basis. Use with appropriate caution and at your own risk. Demo file: JSON-Array-Custom-Functions.zip (requires FM 18 or later) Have you ever noticed that FileMaker does not provide a JSON function to insert a new element into an existing array? For example, given this… Continue reading FM18: JSON.InsertArrayElement Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

×
×
  • Create New...