All content for FileMaker DevCast: Everything Claris FileMaker is the property of Portage Bay Solutions and is served directly from their servers
with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
DevCast, Episode 25: Reports, Pickers, and JSON: The Value of Virtual Lists
FileMaker DevCast: Everything Claris FileMaker
51 minutes
1 month ago
DevCast, Episode 25: Reports, Pickers, and JSON: The Value of Virtual Lists
Virtual lists are one of the most powerful and flexible techniques in FileMaker, giving developers the ability to generate custom reports, create dynamic pickers, and display complex data without storing it in fields.The team breaks down the essentials, like how global variables and JSON arrays feed into unstored calculations, how scripts can define headers and build arrays with SQL or looping, and why this approach is so effective for reporting and beyond.
We also look at advanced use cases, from scaling large data sets and handling character limits to applying conditional formatting, integrating with WebViewer for interactive tables, and exploring Kevin Frank’s MD5-hashed window method for running multiple virtual lists at once.