Tag Archives: Custom Functions

Historical Foreign Exchange Lookup in FileMaker


Scripts to look up Foreign Exchange rates seem to be something of a recurring item on this blog. It is because the Internet keeps changing and what worked last year, doesn’t necessarily work this year. Also, this time, I had a need for looking up foreign exchange rates on a specific date. I found another […]

Continue reading

FileMaker to Google Translate for Longer Texts


ChatGPT is a better FileMaker Programmer Than Me

So, I decided to ask ChatGPT to re-create the script that I had worked so hard on. In a few seconds, the way it does, it came back with a much simpler way of doing the task.

Continue reading

Scraping Tables – Pulling Data Tables from Web Pages into FileMaker Pro


In an ideal world, this data would be published to a JSON file and FileMaker could easily parse that data into records. Unfortunately, many organizations are not there yet, in terms of sharing their data easily. That is where this parsing routine comes in handy.

Continue reading

Ever wish there was a way to ‘Send to FileMaker’ from your Web Browser?


Turns out there is a fairly easy way to do this. It involves creating a bookmark in your web browser that is written in Javascript. It calls a FileMaker script using the URL scheme ‘FMP’ and sends the web page title, and the page’s URL to FileMaker. Once you have this in FileMaker, you can […]

Continue reading

Free Mortgage Calculator for FileMaker Go 14


The beauty of the FileMaker Platform is that in a few hours you can create an ‘app’ …

Continue reading

QR Codes in FileMaker 12 & 13 — No Plug-ins, No Custom Functions


A while back I did a blog posting on generating 2D Bar Codes, or QR Codes from Google’s Chart API. The demo was created back in the dark days of FileMaker 11, before the advent of the Insert from URL function (FM12). In the old demo I used a Custom Function and a free plugin […]

Continue reading

Cluster Maps Continued: Perimeter Search in FileMaker Pro 12


Working on a presentation for a customer that employs the Cluster Maps concept, the request came up about doing perimeter searches—as in ‘How do I see all the related addresses around a specific location?” This ability would aid sales people in the field, cut down on travel etc. A search on Brian Dunning’s very useful […]

Continue reading

Creating and Storing 2D Bar Codes in FileMaker


2D Bar Codes are all the rage these days. These new style bar codes can store considerably more data than a standard bar code. Combined with the wide spread availability of iPhones and other smart phones with a built-in camera, capable of scanning these codes, there is an opportunity to employ these codes for a […]

Continue reading

Growl Integration with FileMaker


FileMaker dialog boxes can be informative, but sometimes they are just annoying. You have to click them to get them to go away. Lots of times, you just want to give a little bit of feedback to the user, so they they get a clue as to what your scripts are doing, without requiring them […]

Continue reading