Skip 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.

FileMaker Hacks

A blog by Kevin Frank in Affiliate Blogs

  • Entries

    351

  • Comments

    2

  • Views

    93,839

Entries in this blog

FM 12 ExecuteSQL: Dynamic Parameters, part 2

This is a quick follow-up to part 1, with a couple more observations about dynamic parameters. a) I can’t believe I forgot to mention this the other day:  A major ExecuteSQL headache that dynamic parameters can alleviate is the dreaded “embedded apostrophe” problem. In case you aren’t familiar with it, if your text string has an [...] Source

FM 12 ExecuteSQL: A Cool Tool

It’s been a fun week experimenting with the ExecuteSQL function, and also seeing what others are doing with it. In some cases the experience has been eye opening, and I strongly recommend that anyone interested in ExecuteSQL grab the SQL Builder file from Eden Morris, available at http://fmforums.com/forum/files/file/25-sql-builder/ This attractive and powerful tool provides a [...] Source

FM 12 ExecuteSQL, part 2

One of the fun things about a new FileMaker release is figuring out how new features work, including subtle behavioral nuances. Today’s demo file, FM12 ExecuteSQL Help Example from CW, is based on Corn Walker’s re-working of one of the demos from part 1, and helps demonstrate how ExecuteSQL fits in with the FileMaker security [...] Source

FM 12 ExecuteSQL, part 1

FileMaker 12 offers many intriguing new features, including new windowing capabilities, significant charting and container field improvements, and a brand new design surface. But to my way of thinking, all of these pale in comparison to the exciting possibilities offered by the new ExecuteSQL function. What’s so great about ExecuteSQL? In a nutshell, it allows [...] Source

User-Friendly Excel Exports, part 1

Many end users appreciate FileMaker’s ability to export a found set of records in Excel format — it’s fast, straight-forward and empowering. One request that I have received from clients multiple times over the years is: make the exported field names in the top row of the spreadsheet “human-friendly”… For example, instead of this: …perhaps they [...] Source

Google Route Mapping, part 2

Those of you who attended DevCon 2011 in San Diego may recall meeting Andries Heylen of BH&A, who cheerfully answered questions in the FileMaker Genius Bar. Well, from the sow’s ear demo I posted in part 1, Andries has woven a silk purse (google-route-mapping-part-2), which I am sharing with his permission, and which uses Google [...] Source

Google Route Mapping

The other day someone asked a question on the FMP Experts list about plotting a driving route in Google Maps using FileMaker data. Mark Rubinstein posted a simple solution, and my reactions were, in this order: “No way, it can’t possibly be this easy; better build a demo (google-route-mapping) to find out; wow, it really [...] Source

Locating Matching Records, part 1

Sometimes a seemingly-simple FileMaker challenge turns out to be more nuanced and educational than first impressions might indicate. This happened recently when I was asked to help make a scripted search behave properly. Most of the time, the existing routine worked correctly, but on certain records it would fail. The challenge: Click a button to [...] Source

FileMaker 11 Internal SQL Changes, part 2

Welcome back for a second action-packed episode, as we continue exploring changes to the FileMaker 11 internal SQL parser. We ended part 1 by looking at the INSERT/SELECT construction which, as you may recall, provides the SQL equivalent of a FileMaker “add new records” import from one table to another. Actually, when you use INSERT/SELECT, [...] Source

A Simple Backup Script

Broadly speaking, FileMaker developers fall into three categories: a) those who do all their development on local files; those who do all their development on hosted files; and c) those who sometimes develop locally, and sometimes in a hosted environment. I happen to fall into category “c”, and suspect that most of my colleagues [...] Source

Birthday Challenges, part 2

Dear FileMaker Hacks, In my personnel database, how can I find all birthdays in a given range, for example, between September 8 and November 15? — Perplexed in Peoria Dear Perplexed, You do come up with some interesting questions. As I recall from our previous correspondence, you are in the US, where dates are formatted [...] Source

Account

Navigation

Search

Search

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.