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
Taking & Sharing Screenshots of FileMaker Go layouts on your iPad/iPhone
Communicating with your FileMaker application developer or other users of a database system can be greatly facilitated by the use of screenshots. Sending a screenshot from FileMaker Go is fairly easy to accomplish, if you know the secret of capturing. Here is how to do it.
Continue reading
Click, Display, Capture – Google Map Longitude & Latitude into FileMaker Pro
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
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
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
Create Folders from FileMaker Pro Using AppleScript on a Macintosh
Someone on one of the Facebook FileMaker Group pages recently asked for a simple method, using AppleScript of creating a folder on the Desktop. FileMaker Pro can generate a variety of file formats, including Text, PDF and Excel, and it is possible to script the names of these files. It is also possible to script […]
Continue reading
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
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
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
Tools for New FileMaker Developers – How to make a million bucks…
FileMaker has a bit of a push on right now to get new developers into working with the FileMaker Pro platform. They recently launched a webpage on their main website to encourage new developers considering the platform. At the recent FileMaker DevCon they talked it up and encouraged developers to help enlisting others to the […]
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
Exporting vCards from FileMaker Pro
Update 2019-06-12: A reader asked about getting this to work on iOS and it prompted me to ditch the Virtual List method and use the much simpler Text Encode Function that was introduced in FileMaker 16. This simplifies the integration into other systems as well. Now you just need to add two fields (UUID and FieldExport) and two scripts (edit the one with the REQUIRED FIELDS) to add this functionality to any database.
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
Why Upgrade to FileMaker Pro 13/14?
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
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