HarmlessWise IT resources & ideas > mainly FileMaker Pro!
I intend to begin to store stuff relating to IT here that may be of benefit to a broader community. RSS & comments are a long way away. When i build an engine to do it, i'll be much much more 'regular'.
Been developing in FMP 5 for 10 years. FMP 7 for 3 years. Studying FMP 9 for last 6 months. Alongside my other work...
FileMaker Multi-dimensional arrays in FileMaker Pro
A method of getting multi-dimensional associative arrays into FileMaker in tolerable fashion. Uses 5 custom functions, two invisible, three key utility functions so far.
FileMaker Fusion Reactor Plugin PopUpMenu use
A method and demo of generically scripting and implementing Fusion Reactor's PopUpMenu (with hidden IDs and visible Values).
FileMaker Fusion Reactor Plugin LiveField adpation
Covering an adaptation of LiveField using a more complex relationship to enable a very flexible find of people across large data sets [well, tested with 64k]. Could be done without LiveField, of course, but just wouldn't be 'live'!
FileMaker index type & size test across 100k records
Analysis of the FileMaker space usage of different types of text & number indexes, and non-impact of empty/redundant fields & records. Maybe useless, but I found it useful and thought I'd save others the bother by publishing results.