Monthly Archives: August 2014

FM Function of the Week: Filter

In keeping with a text parsing theme I seem to have going here, this week’s function is the fabulous Filter function. It’s a text strainer that only permits the characters you specify to come out the other end. But you … Continue reading

Posted in FileMaker 13, Function of the Week | Comments Off on FM Function of the Week: Filter

FM Function of the Week: Substitute

Like the substitutes you knew in your youth, FileMaker’s Substitute function is easily taken advantage of. Depending on your temperament, however, you may be disappointed to learn that the Substitute function is not easily flustered and won’t demand to know … Continue reading

Posted in FileMaker 13, Function of the Week | Comments Off on FM Function of the Week: Substitute

FM Function of the Week: Min and Max

What’s better than a function of the week? Two functions of the week! This week we’ll explore the (fraternal) twin functions of Min and Max. These functions return the lowest and highest value respectively among a range of fields. But … Continue reading

Posted in FileMaker 13, Function of the Week | Comments Off on FM Function of the Week: Min and Max

The Greatest Tip Ever Told

Maybe there’s a touch of hyperbole in that title. More apt might be “(One of) The Greatest (FileMaker Pro Advanced) Tip(s) Ever Told.” It’s not the kind of tip that will help you corner the rice market or find eternal … Continue reading

Posted in FileMaker 11 Features, FileMaker 12, FileMaker 13 | Comments Off on The Greatest Tip Ever Told

FM Function of the Week: PatternCount

If FileMaker functions had sleeper hits (as though FileMaker functions have hits at all), PatternCount would be surely be one of them. It’s not like PatternCount does anything particularly impressive. Give it some text and a search term and it … Continue reading

Posted in FileMaker 13, Function of the Week | Comments Off on FM Function of the Week: PatternCount