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
FileMaker Pro Server – Setting up a Dropbox Backup Copy of Your Databases
Setting up FileMaker Pro Server on a new Mac Mini, running OS X Mavericks, I wanted to add a Scheduled Backup of the Server databases to go to a Dropbox folder. The idea was to add another level of backup that was offsite in the event of fire or theft of the server hardware. Problems […]
Continue reading
Mapping from FileMaker Pro with OpenStreetMap and Leaflet Markercluster.js
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
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
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
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
FileMaker Development on a Windows 8 Tablet
I tried. I wanted to make this work, but the software and hardware does not seem to be there yet. When the iPad/FileMaker Go combo came out, I immediately wished that I could program FileMaker Pro on my favorite reclining device — an iPad tablet. It seems unlikely that FileMaker Inc., will add developer tools […]
Continue reading
Auto Close a FileMaker Pro Database After a Set Interval Using an OnTimer Script Step
Databases can contain sensitive data. Sometimes you have a database you only open occasionally, but you don’t want to forget and leave the data file open on your computer. There are other solutions to this, including locking your computer screen after a set interval, but if you find that procedure overkill and just want to […]
Continue reading
Record and Field Locking Strategies
I was recently asked by a client about how to set up a record locking system. The idea of record locking is that when some event happens a record becomes no longer editable, preserving the contents from change. I have used two different strategies for record locking before and they are both useful, depending upon […]
Continue reading
Mapping Directions from FileMaker Pro with Google Maps
Ever wish you could generate a Google Map pin map from your FileMaker database of things like: a sales route a customer list a distribution list? Not a complex Cluster Map of large numbers of addresses, as I have detailed in another blog post, but a simple reusable script to display small groups of locations as […]
Continue reading