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.

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:

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!