Aller au contenu

FileMaker Hacks

  • Compteur de contenus

  • Inscription

  • Dernière visite


1 abonné

À propos de FileMaker Hacks

  • Rang

Profil général

  • Genre
    Non précisé

Profil FileMaker

  • Certification
    FileMaker 15 Certified Developer

Visiteurs récents du profil

Le bloc de visiteurs récents est désactivé et il n’est pas visible pour les autres utilisateurs.

  1. FileMaker Hacks

    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 […] Afficher la totalité du billet
  2. FileMaker Hacks

    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 […] Afficher la totalité du billet
  3. FileMaker Hacks

    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 + […] Afficher la totalité du billet
  4. FileMaker Hacks

    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 […] Afficher la totalité du billet
  5. FileMaker Hacks

    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: (If the above screen shot looks familiar you have a good memory, because […] Afficher la totalité du billet
  6. FileMaker Hacks

    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 […] Afficher la totalité du billet
  7. FileMaker Hacks

    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 […] Afficher la totalité du billet
  8. FileMaker Hacks

    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 […] Afficher la totalité du billet
  9. FileMaker Hacks

    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: […] Afficher la totalité du billet
  10. FileMaker Hacks

    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 […] Afficher la totalité du billet
  11. FileMaker Hacks

    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: (6Mb, contains two .twbx […] Afficher la totalité du billet
  12. FileMaker Hacks

    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 […] Afficher la totalité du billet
  13. FileMaker Hacks

    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 […] Afficher la totalité du billet
  14. FileMaker Hacks

    Scrolling the Unscrollable

    Demo file: Howard Schlossberg’s presentation on popovers (FileMaker 13 Popovers) has inspired me on multiple occasions… a favorite takeaway is the idea that you can have a scrolling check box set within a popover. The trick is to size the field as tall as necessary to display all the values (this is an extreme […] Afficher la totalité du billet
  15. FileMaker Hacks

    Excel Exports using XML and XSLT

    Editor’s note: Once again it is an honor and a privilege to present an in-depth guest article written by Beverly Voth. This is a follow-up to the User-Friendly Excel Exports series by Kevin Frank, but using an XML export along with various XSLT to give you .csv or .xls (for Excel). The first demo is […] Afficher la totalité du billet