Category: FileMaker 18

bBox for FileMaker v0.96 with JSON processing, Python 3 and more

by Simon Brown
Posted in bBox, FileMaker, FileMaker 18, FileMaker 19, Python, Ruby, Tools & Add-ons

We are pleased to release bBox version 0.96, with JSON processing via jq, Python 3 compile/run,  and improvements supporting Zsh, cURL and Ruby.

bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 210 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.96 with JSON processing, Python 3 and more” →

Math in a FileMaker field, for Inputter’s sake

by Christos Savva
Posted in All, FileMaker, FileMaker 18, FileMaker 19, UX

Editor’s Note: An often-ignored reality of data management is that entering data, correctly and cleanly, into all of these database apps we build can be a royal pain in the…
Assumptions can be dangerous, like assuming that your office manager-doubling-as-bookkeeper wants to manually calculate tax on every Invoice row. Or even has the time to.

Not many job titles (anymore) are simply “Data Entry Manager,” and yet entering data is a task that continually must be managed, by one or by many, in the role of “Inputter”. Just entering data can be tedious enough — so, let’s not make it harder. In fact, let’s strive to make it easier. With that in mind, Beezwax Senior Developer Christos Savva provides an example of performing math in a FileMaker field, using a custom function. This is designed to improve data entry user experience, for the sake of Inputters everywhere.

Continue reading “Math in a FileMaker field, for Inputter’s sake” →

Setting FileMaker’s startup file from CLI

by Simon Brown
Posted in All, FileMaker, FileMaker 18, FileMaker 19, Techniques

We had a client that was upgrading their system to FileMaker 18. They had already pushed new FileMaker Pro clients out to their user’s desktops. But now that the upgraded system was ready, how could they give users a quick and easy way to launch right into the new database system?

Continue reading “Setting FileMaker’s startup file from CLI” →

Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS

by Christopher Edwards
Posted in FileMaker, FileMaker 18, FileMaker 19, FileMaker Server, Integration, Security

A longtime enterprise client recently asked us to integrate a FileMaker Server with an Oracle server. No problem, right? This task requires some development to optimize the database schema and script the data sync, but using FileMaker and an ODBC driver to connect to Oracle is straightforward.

Continue reading “Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS” →

How to enable WebKit and JavaScript debugging in FileMaker Web Viewers

by Simon Brown
Posted in All, FileMaker, FileMaker 17, FileMaker 18, FileMaker 19, Integration, JavaScript, Techniques, Web Development

FileMaker supports bidirectional communication between a web viewer and data or scripts. So, you may find yourself doing more development using plenty of web code and JavaScript integrations.

If you’re having difficulty getting your HTML, CSS, or JavaScript to render in a FileMaker web viewer, there’s a great way to help inspect and fix it. You just need to know the hidden option to enable WebKit debugging in FileMaker web viewers.

Continue reading “How to enable WebKit and JavaScript debugging in FileMaker Web Viewers” →

bBox for FileMaker v0.95 Now Available

by Simon Brown
Posted in bBox, FileMaker, FileMaker 18, FileMaker Server, Integration, JavaScript, Python, Tools & Add-ons, Unix

We are pleased to release bBox version 0.95. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 210 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.95 Now Available” →

I Once Was Lost, But Now Am Found: InspectorPro 7 Global Search

by Christopher Edwards
Posted in FileMaker, FileMaker 17, FileMaker 18, InspectorPro, Tools & Add-ons

When I am working in the Bay Area, I often carpool to Beezwax’s Cupertino and Oakland offices with Vince Menanno, the creator and lead architect of InspectorPro. Over two years of commuting, I have been bugging him to add global search to InspectorPro, so FileMaker developers can search elements across the entire DDR for any solution. Vince must have gotten tired of my nagging, because at long last we can all enjoy this functionality, in InspectorPro 7.

Continue reading “I Once Was Lost, But Now Am Found: InspectorPro 7 Global Search” →

Show me external vs. embedded containers in FileMaker

by Beezwax Team
Posted in FileMaker 17, FileMaker 18, InspectorPro

Dear InspectorPro: Can you show me a report on the container fields used in my FileMaker solution, with a list of all externally-referenced vs. internally-stored (“embedded”) fields? Sincerely, Thanks in Advance-d.

Continue reading “Show me external vs. embedded containers in FileMaker” →

Restoring Backup Files on FileMaker Cloud for AWS

by Darren Burgess
Posted in All, FileMaker, FileMaker 17, FileMaker 18, FileMaker Cloud, Server Administration, System Administration

Recently, we had a client who required restoration of FileMaker backup files for their FileMaker Cloud for AWS 1.17–hosted solution. This seemed a simple enough request—we would download their backup files using the FileMaker Cloud for AWS Admin Console and then re-upload them to the server. However, things did not go smoothly as there was seven gigabytes of data to download and the process was too slow for their fast-paced production environment…like half-a-day too slow.
Continue reading “Restoring Backup Files on FileMaker Cloud for AWS” →

1 2