Archive | FileMaker Pro Techniques RSS feed for this section

Getting Foreign Exchange Rates into FileMaker


2016-10-16 Update: Apparently this parsing code for XE.com broke. XE.com changed the html formatting of their currency table. I have created an updated version (in .fmp12 format) and it has replaced the demo file link below. Here are the steps I changed: In the script “Get Exchange Rate Batch of Currencies” Change these variables (Set […]

Continue reading

UTF, WTF! Writing HTML and JSON from FileMaker


Recently, I was working on a Timeline creation database. A FileMaker Pro database is used to store the events that will be displayed on the timeline. When the data has been entered, the database is designed to export two files, one an HTML file for the main page display and the second a JSON file […]

Continue reading

How to Automate ‘Paste and Match Style’ in FileMaker


Copying text from another application, such as a Web browser or Word document, and then pasting that text into a field in a FileMaker database field, can be annoying when the text pasted arrives with an undesirable style, color, font, or font size. In many programs, such as Numbers, Pages etc, there is the capability to […]

Continue reading

Made changes to a FileMaker Layout and want to back out of it?


Ever modified a layout and then wished you hadn’t? This is a common occurance for FileMaker developers, or at least me. If you are like most developers (or me), you long ago turned on the option for Saving Layout changes automatically. Up until FileMaker 12, there was only one Undo move available. With FileMaker 12 […]

Continue reading

How to find lost image files in your Mac Mail folder


I recently saw mention of an app for the Mac that helps you find your photos lost in your email attachments. It is called Lost Photos and sells for $2.99 in the App Store. Although the price is a bargain and not to take the thunder of out of this app, which does some other […]

Continue reading

Replacing a Time Machine Backup Hard Drive


There are a number of good articles on setting up Time Machine backup hard drives. This blog entry is a little different. A client recently encounter a problem with their Time Machine backup. This article is if you already have a Time Machine hard drive that is giving you troubles. Get a new hard drive […]

Continue reading

Getting Help about FileMaker – FAST!


I recently saw a useful tip from the folks at Skeleton Key on speeding up access to the FileMaker Help System. View the video version of their tip here. This tip is primarily for Mac Users. I tested this in FileMaker Pro for Windows using Parallels and it doesn’t look like this is really an […]

Continue reading

Simple Static Map Overlays in FileMaker Pro


This is an idea I had about creating static map overlays in FileMaker Pro. The gist of it is to create a base graphic map using a program like Photoshop and then add a number of transparent overlays to the map. Save the base map and overlay layers as transparent PNG files and import them […]

Continue reading

Macworld Article: When and why to use group email services


Good overview article in Macworld of why you might want to use a group email service. MailChimp gets a mention. It does not appear to attempt to evaluate the services mentioned, merely make people aware of the options. For my money, MailChimp rules on features, friendliness and use. Related Articles: MailChimp Integration with FileMaker Pro – […]

Continue reading

Where Am I? Using FileMaker Go 12 to track your Location


FileMaker Go 12 has a new mobile function called “Location()”. Location() only works on Mobile devices at this point, so to test this demo file you need to have FileMaker Go 12 installed on your iOS device, an iPhone, iPod or iPad. FileMaker Go is free and available here for the iPhone and here for […]

Continue reading

Making FileMaker interact with Google Translate


2017-12-31 Update – It has been a while since I looked at this file. Reader Jose, informed me that it was no longer working, so I set out to modernize it using the new JSON functions in FileMaker 16. I have created a new demo file, which requires FM 16 to use. The interface is […]

Continue reading

Interactive Charts driven by Virtual Javascript files


Check out this demo of cool interactive charts by Logicurio. They use an interesting technique with their handling of Javascripts. Instead of writing the file out the drive, they store the .js file in a global field and then throw the text of the .js files into Global Variables on launch. Define Global text fields […]

Continue reading

Using FileMaker 12 Runtime files with FileMaker Go 12


Did FileMaker just open the door for developers to create databases that will run on Macs, Windows, iPhones and iPads, all for free? Runtime + Go = Free Distribution Platform The recent launch of FileMaker Pro 12 has been getting rave reviews around the web. A big bonus of the new version is that FileMaker […]

Continue reading

Searching for Email Addresses in FileMaker


The @ symbol used in email addresses has a use in FileMaker that predates email. FileMaker started using this symbol as a wildcard to search for missing characters. For instance if you were looking for something that ends in ‘smith’, you could search for @smith, which would bring up silversmith and goldsmith etc. Apparently, database […]

Continue reading

Creating Google Cluster Maps from FileMaker


  2014-12-17 Update: The FileMaker Pro 11 demo works well on Macintosh, but there are some issues with Internet Explorer on Windows. If at all possible, it is recommended that you use FileMaker Pro 12 or 13 on Windows. Here is a link to the FileMaker Pro 12 Demo. 2014-01-25 Update: Working with the demo file in […]

Continue reading