FullCityConsulting features a function I have never used. Dang it. Now I’ll have to find a way: As functions go Choose is dead simple, but there are some things to watch out for. The first result is result zero. Even if you never expect a result less than 1, you must provide something for result zero. The […]
THIS WEEK’S function from FullCityConsulting has a twist, and can help track down where errors occur in complicated calculations: Unlike all previous functions of the week, EvaluationError wasn’t created to give you information that your database uses. Rather, it’s a troubleshooting tool for developers. Take the function Pi; when you call it in a calculation, […]
BOB KELLEY of Scarpetta Group takes on object visibility by combining it with the Get(WindowMode) function from FileMaker’s built in functions: This week we want to review Get(WindowMode) that was introduced in FileMaker Pro 6.0 or earlier. As you know it returns 0 for Browse Mode, 1 for Find Mode, 2 for Preview Mode, 3 […]
Hint: It has nothing to do with construction or buildings. Instead, it is rounding numbers with a twist. FullCityConsulting explores floor and ceiling functions in their weekly post: A few weeks ago we looked at the Min and Max functions. That got me wondering if there are any other FileMaker functions that travel in pairs. I […]
MANIPULATING TEXT IS USUALLY a big stumbling block for beginning developers. Mastering those functions (LeftWords, RightWords, Position, PatternCount, etc.) will make your life much easier. FullCityConsulting’s explanation of the Substitute function starts with a simple example: Substitute simply examines some text for a specific set of characters (called a searchString) and replaces them with a new set of […]
DOUBLE THE PLEASURE, DOUBLE THE FUN. Assuming you find programming fun, that is. FullCity Consulting covers the Min and Max functions this week: 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 […]
THE LET FUNCTION is the main function that allows you to write functions similar to php and other languages. You can declare variables on the fly that only exist while the function is evaluating, and not have to clean them up afterward. You can manipulate data to the nth degree and return a result (or not) that you […]
FULL CITY CONSULTING STARTED a FileMaker function of the week blog post two weeks ago, and explored the case function for their first post: In the above example you’re effectively asking FileMaker if 5 is less than 6. If FileMaker determines that five is indeed less than six, it will show you the phrase “all is […]
FIND OUT MORE ABOUT THE NEW FILEMAKER 13 Function: Get (ModifiedFields). It’s a very simple process to write a script to call the function: SetField(Log; Get(ModifiedFields)) Set the script to run when the record is committed, and the Log field now contains the contents of any fields that were change. There’s a lot more–listen to it all. Filemaker Success […]
left-functions – Computer.m4v – YouTube.
Scripting vs. Built-in Filemaker Functions – YouTube.