HyperListby Todd Geist
(Update Version 2.0.1 1/29/2014 – fixed the bug reported by Tim Anderson – more info here)
(Update Version 2.0 1/8/2014 – added support for up to 5 fields, detects and uses ListOf)
Post and video over at geistinteractive.com
(Update 10/7/2013 – added trailing return to maintain backwards compatibility )
(Update 8/20/2013 – new and improved faster list function. 2 to 3 times faster then the previous version. )
(update 7/2/2013 fixed a bug that caused HyperList to drop records when hitting found counts that ended in “01”. 101, 301, 100201, etc.)
HyperList is a very fast, completely abstracted module for capturing a found set of Primary Keys to a variable, for use in FileMaker Virtual List techniques. It has been shown to be faster than any other known method for gathering IDs in the current found set. Yes it is faster than the Custom List Custom function. It is capable of capturing 80,000 primary keys in about 10 seconds. As of version 2.0 it can gather up to 5 fields per record.
- Works on any found set
- Uses normal FileMaker sorting order.
- Can handle 10s of thousands of records.
- It works on FileMaker Go and FileMaker Pro
Sam and Jesse Barnum of 360Works.com, figured out that string variables in FileMaker are probably immutable, which means they are never changed, only copied. They also discovered that if you are building long strings with a looping FileMaker script, it can be faster if you write each loop’s string to it’s own $variable and then later compact those variables back into one variable. HyperList builds on this insight.
Jason Young of seedcode.com built the multiple field support for version 2.0
email me for now
Here it is…