bruceR Posted October 28, 2008 Share Posted October 28, 2008 There are times when the full rigor of FileMaker's structured data methods are exactly what you need. On the other hand, there are times you want to work with temporary lists, data snapshots, clipboard contents, and so on. It turns out there are some useful techniques for dealing with data of this type. You probably know about FileMaker global variables, and global fields. Did you know you can create list views and portals from a global variable? Did you know you can sort, find, filter, export, and print the contents of a global variable? You can create an in-memory database of thousands or tens of thousands of records by passing data to a global variable, and then connect it to an index list. You can then create methods to view and report on this data. A variety of sources are set up for demonstration purposes. You can view an example contact list, an example city/state/zip list, a file list, etc. Mac users can instantly display the results of a hard drive search for FileMaker, Excel, or Word files. When viewing this data no data is ever imported. The only data contained in this file is the number set from 1 to 3500 (the data size set for this example). -- Bruce Robertson Concise Design FileMaker 9 Certified memorydb.zip Link to comment Share on other sites More sharing options...
Ocean West Posted October 29, 2008 Share Posted October 29, 2008 Bruce, that is simply brilliant! : I had stumbled on something similar, - your approach is very compelling, now need to find the right project so I can implement it too, thanks for sharing. Link to comment Share on other sites More sharing options...
bruceR Posted October 30, 2008 Author Share Posted October 30, 2008 Thanks! This technique has an enormous range of applications for reporting, value lists, selector portals, all kinds of things. Link to comment Share on other sites More sharing options...
lance123 Posted October 30, 2008 Share Posted October 30, 2008 HI Bruce, That is awesome! I have been working on some things to move some of my field based calculations into memory through global variables in the hope that it would speed things up. But this has blown me away! I can see that if you can get your head around this it extends filemaker into a whole new direction. All the best and thanks for sharing this concept. Regards, Lance Link to comment Share on other sites More sharing options...
Steverino Posted November 23, 2008 Share Posted November 23, 2008 This is really interesting. I'm still wrapping my head around the concept and its applications, but do you think that it could possibly be used to speed up auto-complete or pull-down lists with many values? Link to comment Share on other sites More sharing options...
bruceR Posted December 1, 2008 Author Share Posted December 1, 2008 This is really interesting. I'm still wrapping my head around the concept and its applications, but do you think that it could possibly be used to speed up auto-complete or pull-down lists with many values? Give it a try! But no, I don't think it will make much difference there. I think the flexibility is the primary value of this technique. Link to comment Share on other sites More sharing options...
2 letter pi Posted December 16, 2008 Share Posted December 16, 2008 IS your example available in Windows XP SP2 format??? : Link to comment Share on other sites More sharing options...
bruceR Posted December 17, 2008 Author Share Posted December 17, 2008 IS your example available in Windows XP SP2 format??? : There is no such thing. It is a Filemaker file. Platform and version do not matter. Link to comment Share on other sites More sharing options...
Recommended Posts