Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
  • Entries

    341
  • Comments

    2
  • Views

    81,264

Entries in this blog

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 […] View the full article
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 This approach to reporting can be ideal in situations where the “shape” of your data is known in advance. I don’t mean to imply that VLR cannot be used with more open-ended reporting challenges, but the sales data we […] View the full article
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 […] View the full article
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 […] View the full article
Recently, in the midst of various reporting and charting projects, I’ve found myself wishing for an easy way to “dynamically instantiate” one or more variables… in other words, set them by name, with the name determined programmatically, as opposed to being hard coded. This issue has come up from time to time on this blog […] View the full article
If you do complex data analysis, then from time to time you probably need to group, summarize, and parse data into variables and/or fields. There are various ways to accomplish this, including the Fast Summary technique, which regular readers of this blog may be familiar with, as it has made a number of appearances here […] View the full article
If you produce reports or other FileMaker output in PDF format, here’s a little trick that can be a real time saver in terms of development. Imagine this: a client receives a nightly report via email in PDF format, and asked you to make sure the report would fit on a single page in landscape […] View the full article
Note: Thank you to Colleen Hammersley for bringing this issue to my attention, and thank you also to Howard Schlossberg for proposing a clever and elegant work around that addresses the issue on the Windows platform. (We’ll also look at another fix that works cross-platform.) Today we’re going to explore a windowing behavior change that […] View the full article
Over the last few years I’ve been collecting miscellaneous tips and tricks with the thought of eventually aggregating them into a blog posting, and it appears that day has finally come. Ideally there will be something new and useful here for developers of all levels, from the neophyte to the most grizzled of FileMaker veterans. […] View the full article
Recently a colleague contacted me with some questions about making ExecuteSQL found-set aware, and I realized that while I had addressed aspects of the problem in various blog postings over a multiyear period (for example, here and here), I had not assembled my thoughts into one cohesive, up-to-date article. Well, that shortcoming has now been […] View the full article
Editor’s note: Today it’s my honor and privilege to present an article by guest author Beverly Voth, whose contributions to the FileMaker community are numerous and much appreciated. It’s great to have her back here on FileMaker Hacks. FileMaker 13 & 14 have some features that can be leveraged to allow one layout to toggle between […] View the full article
Note: Interface file #1 requires FM 14 or later; interface file #2 works with FM 12 or later. What do you get when you combine the Separation Model + FM 14 placeholder text + ExecuteSQL + a million-record table + a variable array + Get(CalculationRepetitionNumber) + the Mod and Ceiling functions + a couple custom functions, with blazingly fast (local, LAN and WAN) performance thrown […] View the full article
The need to isolate duplicates within an existing found set has often been a source of frustration for developers. A couple weeks ago we examined a technique by Ralph Learmont demonstrating that, contrary to popular belief and experience, the ! (find duplicates) operator can, under certain conditions, be coerced into isolating duplicate values within a found […] View the full article
Today we have two great examples of using demos from this site as a starting point and making significant improvements: one from Malcolm Fitzgerald in response to FM 13: Anti-deduping, part 1, and one from Ralph Learmont in response to FM 13: Anti-deduping, part 2. As you may recall the challenge was to retain duplicates […] View the full article
Have you ever wanted to generate sample data for one of your solutions that was random in certain ways, but within a defined range or scope? For example, from an existing table of customers… choose 20 at random create between 4 and 8 invoices for each of them dated anywhere between 1 September and 31 […] Source
Editor’s note: Today it’s my privilege to present an informative guest article written by Jonathan Fletcher on the elusive topic of sorted dynamic value lists. Jonathan is a well-regarded, thoughtful and thought-provoking fixture in the FileMaker community, known for his generous and frequent contributions to various online FileMaker forums. Have you ever had a need […] Source
Challenge: in a system with three privilege sets, Employee, Manager and Administrator, you want to control access to various panels on this tab control like so: As usual in the FileMaker world, there are various approaches you could take, and today we’re going to look at three of them with the help of these three […] <a href="http://www.filemakerhacks.com/?p=8576" rel='nofollow external'>Source</a>
Last time we looked at several summary reporting tricks, including a conditional subsummary (when an item’s Status is “Scheduled” it will have a value in the Substatus field — otherwise Substatus will be blank). The challenge was to generate a summary report showing Substatus only where appropriate, without seeing any annoying empty gray rows beneath […] <a href="http://www.filemakerhacks.com/?p=8581" rel='nofollow external'>Source</a>

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.