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
Tag Archives: FileMaker Pro 13
Click, Display, Capture – Google Map Longitude & Latitude into FileMaker Pro
July 17, 2015 
3 Comments
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
June 2, 2015 6 Comments
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)
May 25, 2015 Comments Off on 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
May 19, 2015 Comments Off on 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
April 23, 2015 Comments Off on 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
April 14, 2015 7 Comments
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
October 31, 2014 Comments Off on 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
July 7, 2014 Comments Off on 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
June 24, 2014 7 Comments
2018-12-17 Update: It has been pointed out by reader Andreas that the geo coding function no longer works in this demo file. As I recall, this demo was still using the Google API to get the geo coordinates. I haven’t yet found a URL method for looking up Map Coordinates for Longitude and Latitude. This capability […]
Continue reading Cluster Maps Update – fixed popup formatting bug
June 17, 2014 11 Comments
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
May 22, 2014 3 Comments
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
May 16, 2014 26 Comments
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
May 11, 2014 9 Comments
Update 2017-09-02: A reader named Robert Richardson was having issues with blank QR pngs showing up. In the end he solved this himself: “The solution I’ve found is to hard code a 1 second pause to populate the container (when producing qr codes in a loop for many records). This seems to give each record […]
Continue reading Exploring the New File Level Encryption Feature in FileMaker Pro 13
April 10, 2014 3 Comments
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
HomeBase Software 