Archives
- December 2017
- August 2015
- June 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- March 2014
- February 2014
- December 2013
- June 2012
- April 2012
- March 2012
- February 2012
- December 2011
- November 2011
- September 2011
- August 2011
- July 2011
- October 2010
- July 2010
- March 2010
- August 2007
Categories
Meta
Category Archives: Function of the Week
FM Function of the Week: Day Functions
Scanning the growing list of functions of the week, I noticed a lack of date and time functions. Dealing with temporal matters isn’t always easy. If time were a base-ten system with, say, ten hours in a day and a hundred … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: Day Functions
FM Function of the Week: Average
After a brief hiatus, the Function of the Week is back and just as ordinary, normal, typical, standard and regular as ever! Why so mundane? Because we’re picking apart the Average function this week and we’ve caught the Average Spirit! Average … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: Average
FM Function of the Week: Length and Position
The past few posts have covered an array of text parsing functions. There are countless scenarios where you may need to manipulate text in FileMaker, but the two I most often encounter are data migration and data grooming. I don’t know … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: Length and Position
FM Function of the Week: LeftValues, RightValues, and MiddleValues
Having previously ruminated on the Left, Right and Middle functions, then the LeftWords, RightWords, and MiddleWords functions, we’re going to wrap up with a third triad of functions, namely LeftValues, RightValues, and MiddleValues. Before we dig into the functions though, a definition … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: LeftValues, RightValues, and MiddleValues
FM Function of the Week: LeftWords, RightWords, and MiddleWords
Last week we looked at the Left, Right, and Middle text parsing functions. These are extremely useful when you need to parse out highly regular data like, say, a telephone number where you can count on the first three characters to be … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: LeftWords, RightWords, and MiddleWords
FM Function of the Week: Left, Right, and Middle
Text parsing pops up a lot when migrating data from an old system to a new one, or even when you realize that your data just needs some grooming. Whatever the impetus, Left, Right, and Middle are the cornerstones of … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: Left, Right, and Middle
FM Function of the Week: Sign
Sign is a nice example of a compact, efficient function that can really cut down the length of certain calculations. Its utility is simply this: check a number and report whether it’s negative, zero, or positive. Sign accepts just one parameter … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: Sign
FM Function of the Week: Count
If there’s a theme, or worse, a monotonous repetition to my descriptions of FileMaker’s many functions, it’s probably the bit where I say “this function isn’t complicated, but you can do cool stuff with it.” While I could possibly try … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: Count
FM Function of the Week: GetNthRecord
In FileMaker the current record, that is the record you’re currently viewing at any given moment, is the center of the universe. Very nearly everything you can see or derive is in that record or somehow related to it. This is … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: GetNthRecord
FM Function of the Week: TextStyleAdd
Finding a happy place in text formatting isn’t always as simple as you might think. Sure, plain, black on white text gets dull, but we’ve all seen embellishments get out of hand when somebody combines bold, underline, and strikethrough. But … Continue reading
Posted in FileMaker 13, Function of the Week
Comments Off on FM Function of the Week: TextStyleAdd