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. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. Reciprocal Linkage, part 3

    I thought after part 2 that this technique had been thoroughly discussed and dissected, but Geoff Gerhard of Creative Solutions writes to point out that, if the goal is to have as few moving parts as possible, the table occurrence (TO) count can be further reduced, from four to three… …and he has provided a […] Afficher la totalité du billet
  8. Reciprocal Linkage, part 2

    This is a quick follow up to last week’s article on reciprocal (bi-directional) linking, and will assume the reader is familiar with that material. Paul Jansen of APJ Computing Solutions sent in a revision of one of my files demonstrating that, among other things, the graph could be a good deal leaner (as per my […] Afficher la totalité du billet
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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