ValueCountSpecific ( lst ; value )

ValueCount ( FilterValues ( lst ; value ) )


Ben Miller and I came up with this tiny little function to tell us how many times a specific value occurs in a list. It’s smart enough to consider full values (carriage-return delimited), rather than partial text strings.

Continue reading “ValueCountSpecific ( lst ; value )”

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 12 13 14