Jump to content
  • entries
    138
  • comment
    1
  • views
    53,398

Entries in this blog

 

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 View the full article

Kevin Frank

Kevin Frank

 

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 View the full article

Kevin Frank

Kevin Frank

 

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 View the full article

Kevin Frank

Kevin Frank

 

FM18: JSON.UpdateArrayElement

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 View the full article

Kevin Frank

Kevin Frank

 

Fixed in 18: List + GetNthRecord Bug

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 View the full article
 

New in FM 18: While, part 2

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 […] View the full article
 

New in FM 18: SetRecursion and While

Author’s note: Inevitable comparisons will be drawn between the new While function and the venerable CustomList custom function, which I wrote about at length several years ago. Preliminary testing indicates that CustomList is faster under certain circumstances and While is faster under others. In my opinion, both of them belong in your developer tool kit. […] View the full article
 

Magic Portals

Today we’re going to look at a design pattern I’ve recently been using to accommodate a client requirement: to be able to view and edit a parent, all related children, and all related grandchildren via a single “flattened” interface. Demo file: magic-portals.zip (requires FM 16 or later) Some Background Information Invoices received from vendors are […] View the full article

Kevin Frank

Kevin Frank

 

Bill of Materials

Editor’s note: Geoff Gerhard of Creative Solutions is one of those “quiet” developers who has been helpfully sharing his knowledge in online FileMaker forums for more than 20 years. I personally have benefited enormously from his expertise, and am pleased to feature his first appearance as a guest author here on FileMaker Hacks. Demo file: […] View the full article

Kevin Frank

Kevin Frank

 

Disabling New Window

Today I want to talk about a potential problem lurking in a small percentage of FileMaker solutions, and discuss various options for mitigating it. As you may know, there are three ways to display a new window… Via the New Window script step Via the Go To Related Record script step Manually via Window > […] View the full article

Kevin Frank

Kevin Frank

 

Creating and Using Invisible Window IDs

Editor’s note: I first became aware of Paul Jansen when I licensed his FMTools in the late 1990s, and I finally had the pleasure of meeting him last June at dotFMP after 20 years of online and voice communication. It’s an honor and a privilege to welcome him to FileMaker Hacks as a guest author. […] View the full article

Kevin Frank

Kevin Frank

 

Tips ’n’ Tricks, part 3

It’s been a few years since we last had a tips ‘n’ tricks article here at FileMaker Hacks… long enough for some new items to accumulate in the old developer bag of tricks. (If you like this sort of thing, you may also want to check out part 1 and part 2.) Some of these […] View the full article

Kevin Frank

Kevin Frank

 

Faux Subsummaries with Variable Height Rows

Recently we’ve looked at two methods to generate a “faux” subsummary to address a shortcoming of FileMaker native subsummaries… namely that in a multipage report you can have orphaned entries at the top of a given page with no indication of what parent entity they belong to. The methods were documented here: Conditional Summary Report […] View the full article

Kevin Frank

Kevin Frank

 

Faux Subsummaries via JSON + Virtual List

Today we’re going to take another look at a challenge we discussed last time (in Conditional Summary Report Header)… namely how to cajole FileMaker into displaying a subsummary, or a reasonable facsimile thereof, at the top of a report page when items in the group begin on an earlier page. Demo file: Faux Subsummaries via […] View the full article

Kevin Frank

Kevin Frank

 

Conditional Summary Report Header

Recently I received an email wondering… When printing a multipage report sorted by a sub-summary, is there a way to display the sub-summary heading on the following page when it breaks across two or more pages? There are various approaches one might take, and I actually buried one of those approaches inside an article + […] View the full article

Kevin Frank

Kevin Frank

 

Thinking About JSON, part 3

This a quick followup to last month’s part 2, because today I want to to dig a little deeper into JSONSetElement and take a closer look at the first argument: As I wrote last time… Part of what makes JSONSetElement so powerful is that it can be used both to create new entries, and to […] View the full article

Kevin Frank

Kevin Frank

 

Thinking About JSON, Part 2

This is a follow up to Thinking About JSON, Part 1. Last time we were primarily concerned with learning about JSON paths and structures, and reading JSON. This time around we’re going to look at creating and manipulating JSON. Demo file: winery-json.zip (If the above screen shot looks familiar you have a good memory, because […] View the full article

Kevin Frank

Kevin Frank

 

Virtual List Reporting with JSON Arrays

Acknowledgement: As always a huge thank you to Bruce Robertson, for inventing virtual list, and for many other contributions to the FM community over the years. Introduction As a follow up to my recent “Virtual List on Steroids” presentations at DIG-FM and dotFMP, today I want to take a fresh look at using JSON arrays […] View the full article

Kevin Frank

Kevin Frank

 

Fast Summaries Re-revisited

My recent “Virtual List on Steroids” presentation at DIG-FM, and the preparation of a revised version to give at dotFMP next week, has prompted me to reconsider certain assumptions re: optimizing performance both locally, and across a LAN and/or WAN. Specifically, there are two things we’re going to look at today. First, a way to […] View the full article

Kevin Frank

Kevin Frank

 

Virtual List on Steroids, part 2

Here are files that may be demoed or referred to during my “Virtual List on Steroids” DIG-FM presentation on Thursday, May 10th, 2018 (VLR = “virtual list reporting). Demo Files Step One – Admitting There’s A Problem VLR, part 2 (on Steroids) VLR + JSON Array, v1 [new] VLR + JSON Array, v2 [new] VLR […] View the full article

Kevin Frank

Kevin Frank

 

Thinking About JSON, part 1

I’ve been working on a couple large JSON projects over the last few months, and with the one year anniversary of FileMaker having built-in JSON capabilities just around the corner, this seems an opportune moment to share some reflections and opinions (some of which may contradict JSON-related opinions I have expressed previously). Demo file: json-sandbox.zip […] View the full article

Kevin Frank

Kevin Frank

 

Custom Field-Based Value Lists

Introduction Does this sound familiar? You’ve rolled out a solution that includes a single-record Settings table where authorized users can enter/update various system-wide settings, including one or more fields where the items will appear in popup menus… and then comes the inevitable question: Why don’t items in popup menus appear in the order I entered […] View the full article

Kevin Frank

Kevin Frank

 

Exposed by Tableau

Editor’s note: today we have a guest article written by John Weinshel, who has been quietly contributing to the FileMaker community for 20+ years. John’s thoughtful postings have helped developers at all levels of expertise, and I’m pleased to present his thoughts on Tableau here on FileMaker Hacks. Demo files: exposed-by-tableau.zip (6Mb, contains two .twbx […] View the full article

Kevin Frank

Kevin Frank

 

Sorting on a Field Rep > 1

Recently, in a virtual list report, I had a need to sort on rep number 2 of a repeating field called cell_text_r. FileMaker does not offer an obvious way to script a sort on a field rep > 1, and I had worked around the problem in the past by A. defining some special non-repeating […] View the full article

Kevin Frank

Kevin Frank

 

Virtual List on Steroids

Here are links to resources that may be referenced during my FM-DiSC presentation on Friday, January 12th. This page will be updated to include demo files in the near future. Virtual List Articles Long Documents in FileMaker 11 Conditional Subsummary Report in Browse Mode Virtual List Reporting, Part 1 Virtual List Reporting, Part 2 Virtual […] View the full article

Kevin Frank

Kevin Frank

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.