Something out of Nothing: Null Object Pattern

What is nothing? nil? null? undefined? A vast void of emptiness that fills your soul with dread? Oh sorry, that’s just my stomach.

We often think of nothing as… well, nothing. It’s when something doesn’t exist and therefore cannot be interacted with. So in our code, we try account for having nothing. No User? No problem.

Continue reading “Something out of Nothing: Null Object Pattern”

Using REST and cURL with FileMaker 19’s Data API

FileMaker 19 introduced a couple of important new features related to using the FileMaker Data API. Here, we’ll cover an overview of the new authorization endpoint, Validate Session, API versioning updates, as well as a new script step, Execute FileMaker Data API.

At the end of this article, you’ll find the demo file for learning more and trying out various REST and cURL functionality with FileMaker’s Data API. Enjoy!

Continue reading “Using REST and cURL with FileMaker 19’s Data API”

Math in a FileMaker field, for Inputter’s sake

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”

Ruby’s Safe Navigation Operator &. and is it a Code Smell?

What is &.?

Ruby devs are probably all too familiar with seeing this error:

Most of the time, it’s probably due to a typo, but every now and then we end up having to do something like:

If you’re on Rails, or are using ActiveSupport, you can use present? or try():

Continue reading “Ruby’s Safe Navigation Operator &. and is it a Code Smell?”

Dark and Light Modes: 3 Simple Paths to FileMaker UX

FileMaker 19 introduced support for Dark Mode. Not only does the application’s chrome support Dark Mode (like many applications), but developers now have the ability to detect the OS Dark Mode setting.

Let’s look at three easy techniques to give FileMaker Pro users a choice between Dark Mode and Light Mode, plus an option to automatically adapt modes based on OS settings.

Continue reading “Dark and Light Modes: 3 Simple Paths to FileMaker UX”

Composition over Inheritance, with JavaScript examples

If you are into object-oriented programming, you most likely have heard about composition over inheritance. The concept itself is simple: Whenever possible, prefer to compose objects rather than introducing inheritance.

Continue reading “Composition over Inheritance, with JavaScript examples”

Setting FileMaker’s startup file from CLI

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”

Dynamic Forms with JavaScript and FileMaker Web Viewers

Using the FileMaker platform we can harness the power and wow-factor of modern web interfaces. This post shows how we can build dynamic data-entry forms for use in our apps.
Continue reading “Dynamic Forms with JavaScript and FileMaker Web Viewers”

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

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

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”

Common Code Smells in OOP

Over years of reviewing Ruby code, the same things tend to come up over and over. In this post, I’d like to address some of the most common code smells I find when reviewing OOP code (and Ruby code in particular).

Continue reading “Common Code Smells in OOP”

Claris Connect in action

Doing the simple is hard. Someone recently reminded me of this when discussing business workflow. Tasks like scheduling, calendaring, communicating and sending notifications are individually manageable, in a world where tools for these tasks exist online. Calendars, email, databases, Slack, and a collection of other apps and services make this possible.

Continue reading “Claris Connect in action”

bBox for FileMaker v0.95 Now Available

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”

Day 3 Sessions | Tableau Conference 2019

And we feel welcomed!
Greeting us from the Mandalay Bay Convention Center

Hello again from Tableau Conference 2019 in sunny Las Vegas! Here at Beezwax, we had 5 attendees this year with a diverse set of sessions between us. I wanted to give a rundown of what I went through and some of my takeaways.

Continue reading “Day 3 Sessions | Tableau Conference 2019”

Beezwax Web Team Code Review: a blog post with ulterior motives

I have ulteI want you hacking, at Beezwaxrior motives.
Continue reading “Beezwax Web Team Code Review: a blog post with ulterior motives”

Let’s Abstract a While() in FileMaker

Introducing JSON Filter, Map, Reduce.

Now that FileMaker has given us a practical and more simplified way to loop in a calculation with the While() function, the doors have opened to other ways to look at looping. Continue reading “Let’s Abstract a While() in FileMaker”

Native HTML Email in FileMaker 18

Email is one of the simplest tools used to communicate and send information. Just open a mail client, write a message and press a button to virtually send a letter or message to a recipient.

Sometimes, in addition to simple text, we want to enrich our emails with graphical contents and attachments, making it more pleasant for those who receive it or giving a more cohesive image to our brand. This requires HTML, and it’s not as simple to build and send emails this way.
Continue reading “Native HTML Email in FileMaker 18”

Imports without Tariffs. Natively, with FileMaker Server.

Combining functions, features, or steps in creative new ways can deliver productive results. I was thrilled to discover in FileMaker 18 that the new file-based script steps give us the ability to perform imports natively on FileMaker Server, with no configuration or changes needed.

Continue reading “Imports without Tariffs. Natively, with FileMaker Server.”

1 2 3 26