I’m off for some (almost) spring skiing starting today, so no more posts until next Monday. Until then… The FileMaker Let Function A good exposition on the Let Function from Geist Interactive: The Let function has a lot of uses. It allows you to: Store a value into a variable (be it a function, a […]
FileMaker Let Function and Text Manipulation I recently encountered the following challenge: There were just shy of two thousand web based photo files linked in a FileMaker database, and these files were of multiple types (jpegs, jpg’s, png, and tiffs) of all different sizes – high resolution, medium resolution, different heights and widths. Most of […]
Working with variables in FileMaker Pro I stumbled across this nicely written help.Filemaker.com article on using variables in FileMaker Pro. And, as usual, learned something I did not know. Which means I had to share it: The Let ( ) function is the primary method of defining a variable in a calculation. From within a […]
I’ll admit, my previous experience with developing FileMaker solutions in other languages was limited: I changed the labels in different runtime packages to support advertising research in India (Hindi), China, Japan, and various countries in Europe. Pretty basic, but it worked. Mike Duncan of Soliant takes it a couple of steps further, and provides a demo solution, […]
The virtual list technique has been around quite a while, and is very useful for displaying information from multiple tables in one cross tab report. Jeremy Brown of Soliant wrote a two part series recently on how he applied the virtual list to a problem he faced: FileMaker is a great platform. With its user […]
FileMakerHacks (Kevin Frank) is a master of finding more than one way to mine data from a database: What do you get when you combine the Separation Model + FM 14 placeholder text + ExecuteSQL + a million-record table + a variable array + Get(CalculationRepetitionNumber) + the Mod and Ceiling functions + a couple custom functions, with blazingly fast (local, LAN and WAN) […]