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
  1. Reciprocal Linkage

    Challenge: in a multiuser document management system, facilitate the linking (and unlinking) of any document with any other. Make it clear which documents are linked to the current document, and make sure the approach is multiuser friendly — in other words, allow document records to be linked and unlinked even if one or both of […] Afficher la totalité du billet
  2. JSON Array + Virtual List

    Over the last few postings we’ve been looking at using JSON with Virtual List… and prior to today, our focus has been on JSON structures using name/value pairs. Well today we’re going to switch our attention to basic JSON array structures. Demo file: (requires FileMaker 16.02 or later) Apart from using JSON arrays instead […] Afficher la totalité du billet
  3. Virtual List Reporting + JSON

    Today we’re going to look at an alternative approach to the multi-window VLR technique we examined last month in Virtual List Reporting part 3, utilizing and extending techniques introduced in last month’s JSON + Virtual List. To avoid needless repetition, today’s article will assume the reader is familiar with that material. Demo files: vlr-plus-json-v1 and […] Afficher la totalité du billet
  4. JSON + Virtual List, part 2

    Demo file: This is a short follow-up to part 1, to demonstrate an alternative idea re: JSON date encoding. As you may recall, JSON does not have a “date” type, and one of our goals is to encode and decode JSON dates in a region-agnostic manner (e.g., encode in a region where MM/DD/YYYY is […] Afficher la totalité du billet
  5. JSON + Virtual List

    One nice thing about FileMaker being on a yearly release cycle is that there is always something new to learn and write about… and, having just attended a couple highly informative sessions on the topic of JSON (JavaScript Object Notation) at Devcon 2017 — thank you Todd Geist and Anders Monsen — it is clear […] Afficher la totalité du billet
  6. Virtual List Reporting, part 3

    Last year I posted a couple articles on the topic of virtual list reporting (part 1 and part 2), a.k.a. VLR. Today we’re going to look at some additional things you can do with VLR, and to avoid a lot of repetition, this article will assume the reader is familiar with the material covered in […] Afficher la totalité du billet
  7. FM 16: Pseudo Indexing

    During our recent discussion of SortValues and UniqueValues, I made passing reference to an article I wrote a few years ago on the topic of “pseudo indexing“, i.e., displaying a list of unique values for a specific field for a found set, rather than for all records. Well today we’re going to dust the pseudo […] Afficher la totalité du billet
  8. FM 16: SortValues and UniqueValues

    Today we’re going to look at two functions introduced in FileMaker 16: SortValues and UniqueValues, and you may want to download and follow along in this demo file: FM 16 – SortValues & UniqueValues (5 Mb, requires FM 16 or later) Each of these functions operates on a return-delimited list of values, and the names […] Afficher la totalité du billet
  9. Windowing in FM 16: First Impressions

    9 May 2017: Today’s release of FileMaker 16 introduces new windowing options, and changes to existing windowing behavior… some of these changes are cross-platform, and one is specific to FileMaker for Windows. Demo file: (requires FM 16 or later) Cross-Platform Changes Change #1. Redesigned “New Window” dialog Note the new “Card” window style — […] Afficher la totalité du billet
  10. Export Field Contents (Update for FM 16)

    In the article “An In-Depth Look at “Export Field Contents” (here), the study of how FileMaker exports text as single field contents is compared to the standard FileMaker Exports. Some of these present a problem when the field (exported) gets converted to something which a receiving system may reject as invalid. Several methods and alternative […] Afficher la totalité du billet
  11. User-Friendly Excel Exports, part 7

    This is a follow up to last week’s part 6, with three refinements. Demo 1 (Excel Exports, v7a) – fixes a numeric formatting bug Demo 2 (Excel Exports, v7b) – offers a more flexible Excel export “save” dialog Demo 3 (Excel Exports, v7c) – uses ExecuteSQL to reduce the # of TOs on the RG […] Afficher la totalité du billet
  12. User-Friendly Excel Exports, part 6

    Recently I was asked to implement user-friendly Excel exports on a WAN-based solution, utilizing some of the techniques explored earlier in this series (part 1, part 1.1, part 2, part 3, part 4 and part 5 — all from five years ago). There was just one problem: while performance was great locally, and okay on a LAN, it was […] Afficher la totalité du billet
  13. PDF with Embedded Links

    Author’s note: I’d like to offer a big thank you to Christian Schmitz of Monkeybread Software, not only for creating and continually improving a fantastic plug-in, but also for promptly and patiently answering my many questions. A few weeks ago we looked at creating a table of contents for a PDF containing nine individual reports. […] Afficher la totalité du billet
  14. Virtual List Table Of Contents, part 1

    A few years back I did an article on producing a PDF catalog + table of contents, with the TOC based on a vendor table and the catalog entries based on a products table. Today we’re going to use a different approach to generate a table of contents, and it builds on techniques explored in […] Afficher la totalité du billet
  15. FM/SQL Portal Filter + Dynamic Sort

    Editor’s note: Today I’m pleased to present a guest article and accompanying demo file written by Joel Englander on using ExecuteSQL + a global multi-line key as an alternative to FileMaker’s built-in portal filtering mechanism, with dynamic portal sorting included as an added bonus. Demo file: (75 Mb compressed, 230 Mb uncompressed) Portal Filtering […] Afficher la totalité du billet