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

2013 in review

The 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

QR Codes in FileMaker 12 & 13 — No Plug-ins, No Custom Functions

A while back I did a blog posting on generating 2D Bar Codes, or QR Codes from Google’s Chart API. The demo was created back in the dark days of FileMaker 11, before the advent of the Insert from URL function (FM12). In the old demo I used a Custom Function and a free plugin […]

Continue reading

FileMaker 13 – Use Base64Encode/Decode for Icon Storage

Another nice new feature in FileMaker Pro 13 is the set of Base64Encode/ Base64Decode functions. Base64 encoding is a method of representing binary data (for example a .png icon file) in an ASCII string format (suitable for pasting into scripts or calculation fields). This new set of functions have the potential to eliminate extraneous Global […]

Continue reading

Bar Code Scanning in FileMaker Pro 13

One of the new features of FileMaker Go 13 is the ability to scan bar codes directly into the database. It is a nice new feature but probably won’t replace a dedicated scanner in many situations — here is why. Bar Code Test database Setup is simple. Create a layout with a field and a […]

Continue reading

FileMaker Pro 13 – First Thoughts

FileMaker Pro 13 is now available from FileMaker Inc. The marque features are the new WebDirect feature and a new licensing model based on concurrent connections. There are some very useful new interface and development tools which will get developers excited about using FileMaker Pro 13. When I read the system requirements, my heart sank […]

Continue reading

Hiding in Plain Sight: Using Invisible Tab Panels for Pick Lists

Recently I attended a FileMaker UI/UX Masterclass (UI = User Interface, UX = User Experience) session put on by FileMaker Canada in Vancouver. The session’s main presenter was Yann Liqueur-Salzédo from Infografix in Nice, France. Yann’s innovative design work wowed the crowd at the 2012 FileMaker DevCon in Florida. He has recently launched a web […]

Continue reading

Running FileMaker Scripts from Your Desktop with Launchy or Alfred

Here is a cool trick, a method of running FileMaker Pro scripts directly from the Desktop on Mac or Windows computers. My friend Joshua Paul of Neo Code Software sent me an email with the headline “Launchy/Alfred + FileMaker FMP URI = AWESOME“. Josh is often coming up with innovative approaches to technical challenges, so I […]

Continue reading

Dialing Phone Numbers using SkypeOut from FileMaker Pro

A while back, I found a technique to launch Skype and using the SkypeOut URI scheme, dial a number in Skype. I tested the ability recently and was surprised to see that the technique seems to be broken. Back in 2006 Skype announced on their blog that a FileMaker plug-in had been created by Premium […]

Continue reading

MailChimp Integration with FileMaker Pro – Part 5 of 4 – Importing Mailing Lists

A reader asked recently about getting a MailChimp list into FileMaker Pro. The work that I did on the MailChimp integration demo was based on a project that I did a customer who wanted to start syncing an existing FileMaker data set with MailChimp, so we were starting with the data in FileMaker. It was […]

Continue reading

Cluster Maps and Instant Web Publishing

A reader asked how to make the Cluster Maps demo database work with Instant Web Publishing. A little bit of research in the documentation for Instant Web Publishing (IWP) suggested a possible solution. The Demo database has been updated to reflect these changes. Inside the FileMaker Pro folder is a folder called ‘Web’ Inside that […]

Continue reading

Drag and Drop Images from a Web Viewer in FileMaker Pro 12 on a Macintosh

The Problem: FileMaker Pro 12 is turning out to be a great document and image management system with some of the new features to do with Container Fields. However there is one little annoying ‘feature’ holdover from previous versions —when using Drag and Drop of images from a Web Browser or Web Viewer (Sarari or Firefox) into container […]

Continue reading

Resizing Images in FileMaker Pro 12

Sometimes it is the little things in an upgrade that take a while to percolate through to real world applications. FileMaker Pro 12 has its share of amazing marquee features, (Insert from URL, ExecuteSQL etc), but the humble GetThumbnail function didn’t cross my radar screen until recently. I read an article by DB Services on […]

Continue reading

Get every new post delivered to your Inbox.

Join 36 other followers