Archive | FileMaker Pro 12 RSS feed for this section

FileMaker Navigation – Go to Layout Script


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


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

Cluster Maps Update – Running URL Scripts in a Web Viewer


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


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


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


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


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

Creating Timelines for the web in FileMaker using TimelineJS


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


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)


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


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.


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

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

Database Development with FileMaker Pro Advanced on a tablet


Is database development with FileMaker Pro Advanced possible on a tablet computer yet? Not really, but soon, maybe. FileMaker Go is a wonderful tool for deploying FileMaker databases on iOS devices (iPad, iPods and iPhones) but it leaves something to be desired for the FileMaker developer. There is no way to flip open the hood […]

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