Sometimes it is the little things in an upgrade that take a while to percolate through to real world applications. FileMaker Pro 12 has its share of amazing marquee features, (Insert from URL, ExecuteSQL etc), but the humble GetThumbnail function didn’t cross my radar screen until recently. I read an article by DB Services on […]
Continue reading
Archive by Author
FileMaker Navigation – Go to Layout Script
July 10, 2013 
1 Comment
This is a demonstration of a simple navigation system. FileMaker has had layout tab objects for a while and they are great, but in many solutions you actually want to move between layouts to view different data tables. I show the way I like to do it and then an alternative that works in some […]
Continue reading Cluster Maps Continued: Perimeter Search in FileMaker Pro 12
June 21, 2013 7 Comments
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 MailChimp Integration with FileMaker Pro 12 – Part 4 of 4
June 20, 2013 6 Comments
Readers have reported problems running this file on Windows in FileMaker 11. The problem is that with a Web Viewer on Windows, Internet Explorer, the underlying technology behind the Web Viewer on Windows doesn’t like raw JSON files returned from MailChimp. There are some other solutions for FM 11, but it is fairly simple to […]
Continue reading Cluster Maps Update – Running URL Scripts in a Web Viewer
June 18, 2013 6 Comments
A reader’s suggestion prompted me to try a powerful technique I have been wanting to experiment with: two-way communication through the Web Viewer. By that, I mean sending a calculated link into some HTML in a FileMaker Web Viewer via a script or calculation. Then with the Web Viewer displayed, the user clicks on the link […]
Continue reading How to Setup FileMaker Server for Remote Access
March 13, 2013 7 Comments
Setting up remote access to FileMaker Pro databases is a fairly common task for FileMaker Developers. It is also one of the more common support questions asked by my clients after I have left the building, so I have created a walk through on how to set this up that is hopefully simple enough for […]
Continue reading Screen Capture from FileMaker Pro on the Macintosh
January 23, 2013 5 Comments
Macintosh OS X has a built-in command line utility for taking screen captures. This utility can be called via AppleScript. FileMaker Pro can send out this command from a script. Why would you want to take screen captures using FileMaker Pro? I can think of two good reasons: building documentation within FileMaker Pro and for […]
Continue reading 2012 in review
December 30, 2012 Comments Off on 2012 in review
The WordPress.com stats helper monkeys prepared a 2012 annual report for hbase.net’s blog. Here’s an excerpt: This blog had 50,000 views in 2012. Click here to see the complete report.
Continue reading Building a Barcode System in FileMaker Pro
December 18, 2012 11 Comments
I had a discussion recently from someone wanting to know how to setup FileMaker Pro with a barcode scanning system. I have setup a FileMaker Pro system called PassTracker that employs barcodes to keep track of membership activity at gyms. I was able to provide him with an overview of how to do this and […]
Continue reading Getting Foreign Exchange Rates into FileMaker
November 19, 2012 10 Comments
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 Creating Timelines for the web in FileMaker using TimelineJS
October 1, 2012 5 Comments
2018-03-28 Update: LuminFire has taken over development of this timeline project. Check their web site for updates to the database file. 2016-07-19 Update: Check out this simple and elegant timeline integration by Av Rolf at Mallverkstan. 2014-08-09 Update: I have added a Virtual List export to complement the existing XML Stylesheet export. Both versions are in the […]
Continue reading Guided Access—Kiosk Mode for FileMaker Go on the iPhone or iPad
September 24, 2012 11 Comments
A software-only solution to turning your FileMaker Go databases into true Kiosks. Photo: iPad POS Flip Mountby NClosures Why am I always the last to hear about these things? Apparently this feature, called Guided Access, has been on iPads for a while, and is now available on iPhones with iOS 6. I stumbled on this […]
Continue reading How to Automate Webcam Photo Capture Within Filemaker Pro (Mac)
September 10, 2012 7 Comments
2018-08-16 Update Reader Tim Fox from Miami pointed out that this demo file wasn’t working any more. I have updated it to FM12 format and edited the Automator routine a bit to make it a little faster and smoother running. If you have already attempted to use this and are re-downloading the file, please delete […]
Continue reading UTF, WTF! Writing HTML and JSON from FileMaker
September 5, 2012 9 Comments
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 use Field Comments as Tooltips.
August 31, 2012 Comments Off on How to use Field Comments as Tooltips.
Good tips for tooltips. I had seen this before but couldn’t remember how to do it. Thank you Google. Thank you Philly FileMaker. FieldComment ( Get ( FileName ) ; GetFieldName ( Self ) )
Continue reading
HomeBase Software 