FileMaker Hacks

Membres
  • Compteur de contenus

    19
  • Inscription

  • Dernière visite

    jamais

1 abonné

À propos de FileMaker Hacks

  • Rang

Profil général

  • Genre
    Non précisé

Profil FileMaker

  • Certification
    FileMaker 15 Certified Developer
  1. 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: FM-16-Windowing.zip (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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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: fm-sqlportal-filter-and-dynsort.zip (75 Mb compressed, 230 Mb uncompressed) Portal Filtering […] Afficher la totalité du billet
  8. Given its primary role as a database product, it’s easy sometimes to forget what a great teaching tool FileMaker Pro can be. One of my favorite educational uses for it is building models to explore problem spaces, for example… viewing all possible outcomes for a problem with boundary conditions conducting trials to confirm the likelihood […] Afficher la totalité du billet
  9. Today we’re going to explore a couple ideas that were glossed over in last month’s article on the CustomList custom function… implementing a “modal” popover using a “magic” value list to display a properly sorted list of dates …and you can download a copy of today’s demo file, Date Filtration, if you are so inclined. […] Afficher la totalité du billet
  10. Earlier this year, in Virtual List Reporting, I used a custom function written by Agnès Barouh called CustomList to generate a couple basic lists, and then remarked… Well today I’m going to attempt to make good on that assertion. In case you aren’t already familiar with CustomList, it allows you to iteratively generate and/or parse […] Afficher la totalité du billet
  11. If you work with the separation model, or any other multi-file configuration where a layout in file A is based on a table in file B, you may have encountered the following situation: while FileMaker makes it easy to transfer a found set from file A to file B… …there is no obvious mechanism to […] Afficher la totalité du billet
  12. INTRODUCTION Earlier this month I was contacted by a DevCon presenter asking permission to include some slides from my eleven-year old anchor/buoy materials as part of his presentation. I said I’d be honored, but then added, “You might mention that I haven’t used A/B on a new project in about eight years.” He asked what […] Afficher la totalité du billet
  13. Welcome back for the second and concluding installment in our exploration of Virtual List Reporting (a.k.a. VLR). Demo file: VLR-part-2.zip To avoid repetition, this article will assume the reader is familiar with concepts and techniques introduced in part 1 (some of what follows may appear to be gibberish if the reader is not)… but to briefly recap, here […] Afficher la totalité du billet
  14. Today’s release of FileMaker Pro 15 brings a welcome performance boost in the form of in-line portal progress indicators, a.k.a threaded portals. Ian Jempson (@ianjempson) was kind enough to provide me with a test file that he built, and today’s demo file is based on Ian’s work, and shared with his permission. The purpose of […] Afficher la totalité du billet
  15. Self-plagiarism alert: to avoid repeatedly referring the reader back to earlier virtual list articles, portions of text from those earlier articles are incorporated here. Welcome to the first installment of a two-part series on producing reports using the virtual list technique, or more properly, collection of techniques. Demo file: VLR-part-1.zip Invented and popularized by Bruce Robertson, virtual lists are […] Afficher la totalité du billet