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
Archive by Author
WordPress FileMaker Sync price dropped
May 17, 2012 
5 Comments
WordPress FileMaker Sync | Send FileMaker Data to the Web in Minutes. There has been a large price drop on the FileMaker to WordPress plugin. It was $500 and is now down to $149. I looked at this plugin a while ago, when it was first published and was impressed, but reluctant to purchase […]
Continue reading Interactive Charts driven by Virtual Javascript files
April 17, 2012 2 Comments
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
April 15, 2012 23 Comments
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
April 12, 2012 Comments Off on 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
February 17, 2012 87 Comments
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 Changing Window Names based on User Input
January 6, 2012 4 Comments
Sometimes you notice the little things in a software program and wonder ‘How did they do that?’. As a FileMaker Developer, the next question is usually, ‘can I do that in FileMaker?’ Today I was noticing that in Apple’s Mail App, when you start typing something in the Subject field of a message, it shows […]
Continue reading 2011 in review
December 31, 2011 1 Comment
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 19,000 times in 2011. If it were a concert at Sydney Opera House, it would take about 7 sold-out performances for that many […]
Continue reading How do I update information in a whole bunch of records at once in FileMaker?
December 7, 2011 1 Comment
Recently a friend of mine who hadn’t used FileMaker for a while asked me how he could move through a bunch of records and update some text in all those records. He vaguely remembered there were some quick ways of doing this. This blog entry is for him and everyone out there in Google, Yahoo […]
Continue reading Windows Management Part II: How to stop the user from accidentally closing the last window in a FileMaker database
November 23, 2011 2 Comments
Here is a demo file containing the “On Close” script. The script is self contained and can be pasted into any FileMaker database. How to stop the user from accidentally closing the last window in a FileMaker database Add a script called “On Close” In the Script, prompt them when they try to close the […]
Continue reading Windows Management Part I: Cleaning up Windows in FileMaker
November 20, 2011 5 Comments
I was working on a database that linked a lot of data to other data, employing many join tables. It is a database about maintaining a library of video and audio recordings of art events. The idea is to allow researchers explore and move through Artists, Events, Media Assets, Groups and Programs easily. As a […]
Continue reading All the Access you want on a Mac
November 14, 2011 Comments Off on All the Access you want on a Mac
A recent project required accessing MDB files from Access. I found this useful utility in the Mac App Store. Bare Bones Microsoft Access Table Viewer app MDB Viewer available on the Mac Store is really just a bare bones table viewer for Microsoft Access MDB files. It sells for $6 and for the right situation […]
Continue reading Move Selected Files into a New Folder using AppleScript and Automator
August 17, 2011 4 Comments
Mac users, do you find yourself doing this more often than you like? You select a batch of files or folders, then realize you want to put these items into a folder to facilitate moving them about. You have to back out of your selection, create the folder, then move the files into the newly […]
Continue reading Getting FileMaker Go databases onto an iOS device using Dropbox
August 14, 2011 12 Comments
Update 2017-08-31 – This article is getting a little long in the tooth. FileMaker Go doesn’t look like this any more. There are easy ways to get files to and from Google Drive, Dropbox and iCloud using the sharing menu in iOS. Here is an article about using Google Drive from a web client as […]
Continue reading FileMaker and Image Maps in a Web Viewer
May 3, 2011 14 Comments
Software, although continuously improving sometimes loses capabilities that were in older packages or versions. For a long time, I have wished there was a better way to tie an image map to data in FileMaker, something I saw demonstrated a long time ago. Filevision offered the ability to link graphics and data Source: ebay auction […]
Continue reading
HomeBase Software 