Jump to content

FileMaker Hacks

Membres
  • Content Count

    65
  • Joined

  • Last visited

    Never

1 Follower

About FileMaker Hacks

  • Rank
    50

Profile Information

  • Gender
    Non précisé

FileMaker Profile

  • Certification
    FileMaker 15 Certified Developer

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  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
  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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. Disclaimer: the technique shown in this article is an attempt to work around an annoyance that can crop up when using FileMaker’s native JSONSetElement function. Use with appropriate caution and at your own risk. Acknowledgement: I owe a debt of gratitude to Paul Jansen for many illuminating JSON-related discussions over the last year or so.… Continue reading FM18: JSON.UpdateArrayElement Afficher la totalité du billet
  14. Recently I was working in FM 17 and ran into an unexpected bug. My use case was more complex than this, but the following bare bones demo illustrates the problem. Demo file: List+GetNthRecordBug.zip Given two tables joined via a standard primary-key-to-foreign-key equijoin relationship… This works as expected. You might think you could get rid of… Continue reading Fixed in 18: List + GetNthRecord Bug Afficher la totalité du billet
  15. Today we’re going to dig a little deeper into the new-in-18 While function, and to avoid repetition, will assume readers are familiar with last month’s article on SetRecursion and While. We’ll examine some new examples ranging from basic to advanced, talk about the circumstances under which While can use variables previously declared via Let, and […] Afficher la totalité du billet
×
×
  • Create New...