set-the-storage-on-your-server-.png

Harnessing FileMaker Pro 12/13’s Document Management Features WITHOUT FileMaker Server


Many small businesses take advantage of FileMaker Pro’s ability to host up to 5 clients from a copy of FileMaker Pro, rather than invest in the more pricey FileMaker Server. Recently, I encountered just such a client who wanted to add some document management features to their solution and I wasn’t sure they would be […]

Continue reading
filemaker-timeline1

Why Upgrade to FileMaker Pro 13?


Time marches on with software. Keeping up with the latest version of any software can be a delicate balance between hardware, operating system and the actual software. Upgrade too soon and your users can end up experiencing glitches, printer drivers haven’t been updated for the new operating system, old hardware won’t run the new operating […]

Continue reading
mailchimp-v2-api

Modular FileMaker – A New Mailchimp Module


If you are not familiar with the web site called Modular FileMaker, you owe it to yourself to check out some of the great code residing there. A Mailchimp module was recently added from FMSimplicity. It is, as advertised, modular and offers the potential of a less complicated installation procedure. I haven’t actually tried installing it yet, but it looks promising. If […]

Continue reading
wpid10048-caller-id-to-filemaker.gif

Caller ID looks up FileMaker Client Record with VOIP Telephone


A few weeks back, we had a meeting of the BC FileMaker Developer Association. Joshua Paul of Neo Code Software, was talking about the benefits of the Voice Over Internet phone system his company had installed. His phone costs were way down, the voice quality was reliable and crystal clear (because the system uses better more […]

Continue reading
media_1404624381720.png

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
unknown.png

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
OpenStreetMap-Demo

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
PastedGraphic-9.png

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
media_1400782299801.png

Export Calendar files from FileMaker Pro – Virtual List Technique


I thought I was in the clear with my previous demo/post. A number of readers have pointed out the error of my ways. In my last post about exporting Calendar files, I glossed over the UTF-8/16 issue that is still present in FileMaker Pro. The problem is that if a script employs “Export Field Contents”, which […]

Continue reading
media_1400131070188.png

Exporting Calendar files (.ics) from FileMaker Pro 13


I have been working on an event-based database project and my client was requesting some way to get the events to their Calendar application. I looked around and found the basics of how to do this, generating the required text for a calendar .ics file. I also found a good article on FileMaker Hacks that suggested […]

Continue reading
media_1399786428912.png

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
FileMaker-Safe.png

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
media_1394832110027.png

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
OnTimer-Workflow

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
media_1391927659493.png

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
media_1391315115750.png

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
Screen Shot

FileMaker Pro 13 Icon Replacement


Some FileMaker developers, myself included, were disappointed that FileMaker Inc., did not alter the colour scheme of the new icon for FileMaker Pro 13. As a developer, I keep usually keep the last few versions of FileMaker Pro active on my drive. Lined up in my dock, I can’t tell which is FileMaker 12 and […]

Continue reading
2013-12-30 21_43_42

Talk to FileMaker Pro on a Macintosh


Macs have had a built-in speech recognition system since the last version of OS X, Mountain Lion. Apparently things have been improved in the new version and I have been playing around with Mac OS X Mavericks latest iteration with FileMaker Pro to enter notes into text fields and even do numeric data entry. Set […]

Continue reading
2012-emailteaser

2013 in review


The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 100,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 4 days for that many people to see […]

Continue reading
Follow

Get every new post delivered to your Inbox.

Join 51 other followers