Sign up to save your podcasts
Or
Share DevCast, Episode 25: Reports, Pickers, and JSON: The Value of Virtual Lists
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
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.
View all episodes
By Portage Bay Solutions
5
33 ratings
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.