A lot of folks have been asking for the Virtual List example file we put together with Bruce Robertson, so here it is: VirtualList.zip

This Virtual List technique is part of what made our early FileMaker calendars fast, and allows FMSearchResults to show records from different tables in the same ‘portal’. We demonstrated some applications of this at DevCon’s Year in Review in 2010 and 2011, showing how this can really speed up FileMaker displays, especially those formatted as columns, grids, or lists.

Todd Geist speaking at SOFA, Nov 2011

Todd Geist has also been speaking about this a lot, including last week in Toronto, where he demonstrated how we’re using it in Worx.

There was a also a great session on Virtual Lists at Pause[x]London. Sample files and recorded presentations here.

Are you using Virtual Lists?

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Tagged with →  

8 Responses to Virtual List

  1. Mike Ryan says:

    I’d love to see more about Virtual Lists. The videos at POE go appear to be at a dead Dropbox link. And your link is broken to Todd Geist’s stuff.

    • Hey Mike, Todd redid his site and I’ve updated that link. As for the videos, they were uploaded by an attendee and he must have taken them down. Sorry about that. The sample files, etc. are still up. If you’re interested in this I’d expect a good deal of discussion on VL at DevCon 2012.

      • Mike Ryan says:

        Thanks John. Bummer about the videos. I’m wondering if SQL is going to overtake VL as a preferred technique by the time next DevCon rolls around. Unfortunately, being a part-time in-house developer on the west coast, I won’t quite get to see it for myself.

  2. I think that SQL and VL is the really key combo. Though SQL isn’t appropriate in all cases, it is a great way to populate VL globals.

  3. Mardi Kennedy says:

    Bloody brilliant demo file – thank you to all of you!

  4. […] you can possibly do with just the SELECT statement (which returns lists of matching data), think Virtual List and stay tuned. Share this:FacebookTwitterEmailLike this:LikeBe the first to like this […]

  5. […] 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 then any other known method for gather IDs in the […]

  6. […] (see Lisette Wilson’s Taming the Virtual List, Part I and Part II) and examples are fairly easy to find. So why write another one? Many examples and To see the full content, […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Share →
DayBack Calendar
Download DayBack and we'll send you a couple short emails with tips on how to modify it and use some of the little known features.
Thank you! Please download: DayBack Calendar
Want More?
Be the first to see articles and tips like these
Need More?
SeedCode tips & example files in your inbox
Need More?
SeedCode tips & example files in your inbox
Want More?
Be the first to see articles and tips like these
Download TimeZync and we'll send you a couple short emails with tips syncing your FileMaker Go files.
Thank you! Please download: TimeZync