Beezwax Collaboration in Action: Insights From Our Work and Our Team

We believe ideas get better when shared. This space is where our developers, designers, and data experts open up about what they're building and why it matters.

Convert FileMaker value lists to AppleScript expression

Passing values between FileMaker and AppleScript can be a pain. Sure, you can use a named field and table in FileMaker to do this, but if you (or someone else) ever changes either of the names your AppleScript routine breaks. So, even though its not the most efficient way to do things, for short routines […]
Read it now

FMPRoRHTTP, or, making FileMaker interface with Rails over HTTP

[Authored by Ian] I’ve been doing work on a couple projects integrating Rails with FileMaker Pro (FMP) over HTTP. There are a few different FMP features and plugins the FMP developers use to connect to Rails, none of which I truly grok. Notwithstanding my lack of FMP knowledge, I wanted to write-up what I expect […]
Read it now

Converting textual dates in FileMaker

If you’re working with data from outside of FileMaker, you’ll commonly have to work with dates that FileMaker’s GetAsDate function won’t understand. To handle this, I created a custom function that allows conversion of a wide variety of date formats. Some examples of how the function works:
Read it now

Never write a render_foo method again

[Authored by Ian] I’ve probably written a hundred render_not_found methods in my life as a Rails dev. Usually they just render a static file under /public, and maybe, if I’m feeling nice, give an XML response. No more!
Read it now

Setting the Commit Author to Pair Programmers' Names in Git

[Authored by Sam] In beezwax’s webdev division we generally work in pairs, but our commit logs didn’t used to show this. We wouldn’t bother to reconfigure the git author every time we sat down with a new pair so our git log only recorded one of the programmers’ names. Bryan Helmcamp has a nice script […]
Read it now

Remote Pair Programming: Part II: Sharing the server

[Authored by Sam] [01/04/15 – Editor’s note: This post was written in 2008. In 2015 we don’t use this “reverse ssh tunnel” method much anymore, but the technique is still interesting.] In my last post I described how to use reverse ssh tunnels and screen -x to setup a remote pair programming environment.
Read it now

Remote Pair Programming: How we do it

[Authored by Sam] [01/04/15 – Editor’s note: This post was written in 2008. In 2015 we don’t use this “reverse ssh tunnel” method much anymore, but the technique is still interesting.] There’s a lot of talk about remote pair programming, but the fact is it can be a pain to set up.  Using iChat screen […]
Read it now

Alternative FMP/Rails Integration: External SQL sources

[Authored by Ian] In my last post, I described my preferred methodology for integrating Rails and FMP. In this post, I’ll discuss an alternative technique using FMP’s external SQL sources functionality. Since IANAFMPD (I am not a FileMaker Pro Developer), I’ll skip the implementation details and just cut to when it’s an appropriate solution.
Read it now

FileMaker Pro/Rails integration methodology

[Authored by Ian] Here’s a synopsis of my findings on integrating Rails with FMP. Goals: allow two-way data transmission between FileMaker Pro (FMP) and Rails minimize development time required for both FMP and Rails accommodate as many clients (which may be another application written with FMP, Rails, or anything else) as possible
Read it now

A Use For Git's Post-Commit Hook

[Authored by Sam] I love git and I love to be lazy, so lately I’ve been playing with git hooks. Git’s default pre-commit hook is really handy, but today I’m in more of a post-commit kind of mood.  Like all git’s hooks it comes with an example script.
Read it now