Building Folder Structures in the Finder with FileMaker Pro 17


In keeping with the principle, “Why use a screwdriver, when I have this hammer right here?”, I decided, instead of just downloading a free utility from the Mac App Store, I would build folder creation functionality using FileMaker Pro Advanced 17.

Continue reading

Elapsed Time Display in a Web Viewer


A simple approach, easy to integrate into other FileMaker solutions. A Web Viewer is being sent an HTML page with a Javascript timer displaying the elapsed time. Using the same FileMaker Start Timer script, a Start Time field is set at the same start time and then ended when clicking a FileMaker End Timer button/script.

Continue reading

Deleting Files from Your Computer Using Native FileMaker Pro


Why would you want to delete files in the Finder from FileMaker Pro? Once the files are imported into FileMaker, they are removed from the user’s ‘Scanner Document’ folder on the Desktop of their computer.

Continue reading

How to Delete Attachments from Messages in Apple Mail


Someone recently asked me “I have a malware in my MacBook that Sophos can’t deal with and supposedly, they are all in email attachments. I’d like to get rid of any problems.”

Here is how to get rid of just the attachments in Apple Mail.

Continue reading

Time Picker for FileMaker Go on iOS


I watched this short video by Angel City Data and was inspired to create my own Time Picker for FileMaker Go on iOS.

Continue reading

Using AppleScript to send FileMaker data to Apple Notes App


Recently, a friend asked me about automating the export of data from FileMaker to Evernote. A web search found that someone had already figured this out. I thought this might be useful to send data to Notes, the app that I use.

Continue reading

Set a Keyboard Shortcut for “Save as PDF” in Mac OS


This is a really useful shortcut. I think it should be built in to Mac OS, but until the powers that be get around to doing this, you can add this feature for yourself.  It is now second nature for me to go Command P, Command P to create a PDF.

Continue reading

Org Charts in FileMaker Pro


…using the Google Chart API Javascript library to generate a decent looking Org Chart right in FileMaker Pro. 

Continue reading

Backup FileMaker 17 Databases to the Cloud


FileMaker 17 introduces a useful new feature called “Create Directories” when creating files. This works with saving a copy or clone of the database, as well as exporting PDFs or text files. I decided this was a good time to update my old Backup database script.  I use this script when developing locally. If I […]

Continue reading

How to Download a Batch of Instagram Photos in Safari on a Macintosh


Now that Instagram allows you to view your Saved Bookmarked photo collection in a web browser, here is a method of downloading your favorite photos to your hard drive. Safari: Preferences With Safari open, go to the Safari menu and select ‘Preferences’. Advanced tab: Turn on “Show Develop Menu…” option In the Advanced tab, select […]

Continue reading

How to Upload Photos to Instagram from Safari on a Macintosh Computer


Note: Sorry FileMaker readers, this is a little off topic. It is in the general realm of minor hacking, so perhaps some of you might find it useful. For some reason Instagram is still insisting on users posting photos only from their mobile devices. Something about their walled garden, where they don’t want people to […]

Continue reading

Ever wish there was a way to ‘Send to FileMaker’ from your Web Browser?


Turns out there is a fairly easy way to do this. It involves creating a bookmark in your web browser that is written in Javascript. It calls a FileMaker script using the URL scheme ‘FMP’ and sends the web page title, and the page’s URL to FileMaker. Once you have this in FileMaker, you can […]

Continue reading

FullCalendarIO – a Javascript/HTML Calendar for FileMaker Pro


Add a free open source calendar to Filemaker Pro databases by using the Web Viewer.

Continue reading

How to Automate Saving the First Page of a Batch of PDFs as JPGs


Not specifically a FileMaker challenge today, this is an Apple Macintosh Automator/Shell Script routine. I recently had the requirement of generating a set of images for a large set of PDFs—I just needed the first page of a batch of PDFs converted into JPG files.

Continue reading

Join Tables in FileMaker Pro


To get around the problem of having a many-to-many relationship you need to break apart the many-to-many relationship into two one-to-many relationships. Using a third table, commonly called a “join table”, does this. Each record in the “join table” would have the foreign key fields of the two tables it is joining together.

Continue reading

Display Formatted Text in a Web Viewer


This idea has been documented before, (Using a Web Viewer as a Field) but I rediscovered it myself recently and thought I might have something to add. As was pointed out in The Support Group article, sometimes as a developer, you want to display a long chunk of text (anything that requires scrolling within a field) to the user, but not allow them to edit that text. Some examples might include displaying a block of help text, or a long software agreement. It is obviously possible to format your text using HTML to achieve this effect, but that can become complicated especially if you are not that good at HTML. Fortunately FileMaker offers a much simpler way to display formatted text this using the GetAsCSS function.

Continue reading

Smart Phone Caller ID Triggers Customer Search in FileMaker Pro Database


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

FileMaker Go 14: Keeping Button Bars and Slide Panels in Sync


Someone suggested using the combination of FileMaker 14’s new button bar with a slide panel to emulate a tab panel. Why bother you ask? Well you get the cool slide animation effect.

Continue reading