I built a Word Cloud to run in FileMaker using an existing D3 Javascript that generates a Word Cloud. I designed it to work on the Desktop or iOS, using the same layout.
Continue reading
Word Cloud D3 Javascript in a Web Viewer in FileMaker
April 8, 2019 
Comments Off on Word Cloud D3 Javascript in a Web Viewer in FileMaker
Exporting UTF-8 Files from FileMaker Pro
March 12, 2019 Comments Off on Exporting UTF-8 Files from FileMaker Pro
In FileMaker 16, a new function was introduced called ‘TextEncode’. It was a lifesaver and an answer to my repeated whinging about how much trouble it was in previous versions of FileMaker to export plain Jane utf-8 files.
Continue reading
Scraping Tables – Pulling Data Tables from Web Pages into FileMaker Pro
January 25, 2019 2 Comments
In an ideal world, this data would be published to a JSON file and FileMaker could easily parse that data into records. Unfortunately, many organizations are not there yet, in terms of sharing their data easily. That is where this parsing routine comes in handy.
Continue reading
Building Folder Structures in the Finder with FileMaker Pro 17
December 11, 2018 4 Comments
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
November 21, 2018 Comments Off on 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
November 16, 2018 1 Comment
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
November 12, 2018 Comments Off on 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
September 3, 2018 3 Comments
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
July 18, 2018 3 Comments
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
July 10, 2018 1 Comment
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
July 4, 2018 Comments Off on Org Charts in FileMaker Pro
…using the Google Chart API Javascript library to generate a decent looking Org Chart right in FileMaker Pro.
Continue readingBackup FileMaker 17 Databases to the Cloud
June 8, 2018 Comments Off on 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
November 8, 2017 Comments Off on 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
November 8, 2017 Comments Off on 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?
July 26, 2017 Comments Off on 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
HomeBase Software 