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:

Continue reading “Converting textual dates in FileMaker”

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.

Continue reading “Alternative FMP/Rails Integration: External SQL sources”

FileMaker Pro/Rails integration methodology

[Authored by Ian]

Here’s a synopsis of my findings on integrating Rails with FMP.


  • 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

Continue reading “FileMaker Pro/Rails integration methodology”

1 16 17 18