Tag Archives: FileMaker Pro 13

Smart Phone Caller ID Triggers Customer Search in FileMaker Pro Database


A while back, I did a blog entry on capturing Caller ID to look up FileMaker database contacts using a VOIP system. I thought it might be interesting to see if the same thing could be done with just a mobile phone, such as an iPhone or Android device.

Continue reading

Click, Display, Capture – Google Map Longitude & Latitude into FileMaker Pro


Using a Javascript overlay on Google Maps and FileMaker’s URL scheme to channel those coordinates into FileMaker records. Click on a map, add longitude and latitude to FileMaker Pro.

Continue reading

Flipping in FileMaker


Rotating Images or PDFs in Containers with Applescript (Mac) In my previous blog post I talked about automating scanner documents into FileMaker container fields using AppleScript. This was based on a customer request. Logging in to that system recently, I noticed that it was fairly common for staff members to scan documents in upside down. […]

Continue reading

Automating Webcam Photo Capture within FileMaker (Windows)


OK folks, here is a hack for you. The Challenge: Capturing images from a web cam into FileMaker on Windows. I was able to achieve this previously on a Mac using AppleScript, but there is no similar easy inter-application scripting language on Windows. FileMaker Go on mobile has the ability to grab photos right from […]

Continue reading

Window Management in FileMaker Pro – Preventing Extra Windows from Opening


My first version of the system was rejected by the customers because it kept opening extra windows, confusing the users. So I set about writing a fairly modular script that I could reuse to test if a window was already open and if so, simply select it, rather than opening another new window. This seemed to make the users much happier. I share it with you and my future self here.

Continue reading

The End is Near – a Minor Datacalypse is Coming


I have written before about the need to stay current with FileMaker Pro, operating systems and hardware. I recently received an email from a reader who asked: Between me and a colleague we built a large database with all the bells and whistles back in the days of FM 5.5 and yes, we fell behind or […]

Continue reading

Speedy Document Scanning Directly into FileMaker Pro 13


A Macintosh computer, FileMaker Pro 13, a Fujitsu ScanSnap S1300i, Automator, Applescript, a Folder Action and FileMaker’s URL Scheme make a paperless solution for legal waivers a reality.

Continue reading

Applescript Notification from FileMaker


FileMaker developers (and other app developers) are always looking for better ways to communicate information to their users. System level notifications have proven to be an effective way of sending short ‘dissolving’ messages to users. These Notification messages show up in the top right corner of the users screen, make a little chime, hang around for […]

Continue reading

How to Maintain a Connection to FileMaker Server on a Dynamic IP Address with DynDNS Updater


Overview Once you have your FileMaker Server setup and accessible remotely, I recommend setting up Dyn.com Remote Access service. Their tagline is “Access your device or files using a unique hostname, instead of a confusing (and ever-changing) IP address.” The reason you may need a service like this is because in many cases your Internet provider doesn’t […]

Continue reading

Mapping from FileMaker Pro with OpenStreetMap and Leaflet Markercluster.js


Recently, when searching for updates to markercluster.js on Google, I found an interesting Javascript library called Leaflet Markercluster, that uses OpenStreetMap instead of Google Maps. OpenStreetMap is an open source, Wikipedia-like project for maps. Apple is using some of the data from OpenStreetMap in the Maps app on iOS and Macintosh. The maps and data are not as robust as […]

Continue reading

Cluster Maps Update – fixed popup formatting bug


Fixed formatting issue on the popup box. This version also uses V3 of the markercluster.js file. Download the Demo File ClusterMaps.zip Popup box formatting issue Previous versions of the Cluster Maps demo have suffered from a formatting issue. I have known about this for a while, but haven’t had the time to fix it. I […]

Continue reading

Export Calendar files from FileMaker Pro – Virtual List Technique


Update 2015-11-25: An even easier method of creating vCards that seem to work cross platform is demonstrated by Joe Simpson of Radical Application Development. He uses Base64Encode and then Base64Decode to generate the file in a container field. The same approach should work with .ics files. Then it is a simple matter to export it. Check it out […]

Continue reading

Exporting Calendar files (.ics) from FileMaker Pro 13


2017-04-23 Update: Radical Application Development’s page has changed, so here is another link that describes the Base64Encode/Decode technique: FileMaker Hacks. 2014-05-22 Update: If you have problems with the import of .ics events into your calendar, please see the next blog posting on Exporting Calendar files using the Virtual List Technique.   Update 2015-11-25: An even easier method of creating vCards […]

Continue reading

No Internet Connection, Can’t use Plugins, Need QR Codes? — Create QR Codes in FileMaker Pro using only Javascript


A while back, I wrote a blog and demo using FileMaker Pro to generate QR Codes. The technique employed Google’s API to generate a QR Code and the Insert from URL command in FileMaker Pro 12 to get the code into a container field. A reader requested a technique that allowed users to generate QR […]

Continue reading

Exploring the New File Level Encryption Feature in FileMaker Pro 13


What is the new Encryption At Rest (EAR) ability for in FileMaker Pro 13? FileMaker Safe? I started out exploring FileMaker Pro 13’s new encryption feature because I wondered about securing a single FileMaker database on my system. We like to think of a FileMaker file as a locked box, but I was never quite […]

Continue reading