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
Searching for Email Addresses in FileMaker
April 12, 2012 
Comments Off on Searching for Email Addresses in FileMaker
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
Submitting FileMaker Runtimes to the Mac App Store
April 10, 2011 7 Comments
I have been looking at the feasibility of submitting an app to the Mac App Store using FileMaker. When the Mac Store was first announced, it sounded like the apps had to be created in Xcode/Cocoa and nothing else would do. Since that time, I have seen discussion of using Adobe Flash and RunRev’s LiveCode […]
Continue reading
URLs in PDFs – Yet another reason to shorten URLs in FileMaker
January 25, 2011 9 Comments
Long URLs in FileMaker If you have a long URL in FileMaker, it is no problem. You could just have a button to open the URL from a text field. However, if you export the same URL to a PDF to circulate the information to others who don’t use FileMaker, you can hit problems. The […]
Continue reading
That Syncing Feeling – the Dangers of MobileMe.
January 4, 2011 4 Comments
Attempting to solve one problem, many new problems are created. For the TL;DR crowd – bought MacBook Air (MBA) on sale, setup MobileMe syncing between MBA and MacBook Pro, decided MBA too limited. Decided to return and in preparing to return to store deleted all of my contacts, calendars and bookmarks, Time Machine saves the […]
Continue reading 2010 in review
January 2, 2011 2 Comments
The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers A Boeing 747-400 passenger jet can hold 416 passengers. This blog was viewed about 9,700 times in 2010. That’s about 23 full 747s. In […]
Continue reading
HomeBase Software 