Archive | FileMaker Pro 12 RSS feed for this section

Building an Accounts Receivables and Invoicing System in FileMaker Pro


Long ago, a wise old accountant named Bud, once pointed out to a much younger version of me, that most businesses have very similar accounting needs with respect to Accounts Payable, General Ledger and Payroll systems. Where they differ the most is in the Sales and Accounts Receivable (also Inventory Systems, but that is a […]

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

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

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

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

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

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

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

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

FileMaker Navigation – Go to Layout Script


This is a demonstration of a simple navigation system. FileMaker has had layout tab objects for a while and they are great, but in many solutions you actually want to move between layouts to view different data tables. I show the way I like to do it and then an alternative that works in some […]

Continue reading

Cluster Maps Continued: Perimeter Search in FileMaker Pro 12


Working on a presentation for a customer that employs the Cluster Maps concept, the request came up about doing perimeter searches—as in ‘How do I see all the related addresses around a specific location?” This ability would aid sales people in the field, cut down on travel etc. A search on Brian Dunning’s very useful […]

Continue reading

Cluster Maps Update – Running URL Scripts in a Web Viewer


A reader’s suggestion prompted me to try a powerful technique I have been wanting to experiment with: two-way communication through the Web Viewer. By that, I mean sending a calculated link into some HTML in a FileMaker Web Viewer via a script or calculation. Then with the Web Viewer displayed, the user clicks on the link […]

Continue reading

How to Setup FileMaker Server for Remote Access


Setting up remote access to FileMaker Pro databases is a fairly common task for FileMaker Developers. It is also one of the more common support questions asked by my clients after I have left the building, so I have created a walk through on how to set this up that is hopefully simple enough for […]

Continue reading

Screen Capture from FileMaker Pro on the Macintosh


Macintosh OS X has a built-in command line utility for taking screen captures. This utility can be called via AppleScript. FileMaker Pro can send out this command from a script. Why would you want to take screen captures using FileMaker Pro? I can think of two good reasons: building documentation within FileMaker Pro and for […]

Continue reading

2012 in review


The WordPress.com stats helper monkeys prepared a 2012 annual report for hbase.net’s blog. Here’s an excerpt: This blog had 50,000 views in 2012. Click here to see the complete report.

Continue reading