Episode 25: Reports, Pickers, and JSON: The Value of Virtual Lists

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.

Tämä jakso on lisätty Podme-palveluun avoimen RSS-syötteen kautta eikä se ole Podmen omaa tuotantoa. Siksi jakso saattaa sisältää mainontaa.

Jaksot(33)

Episode 33: FileMaker 2026 Review: More Than Meets the Eye

Episode 33: FileMaker 2026 Review: More Than Meets the Eye

It's been two months since FileMaker 2026 was released and our devs are still discovering. This episode, the team is looking into what the update really means for developers and the new features they’...

11 Elo 32min

Episode 32: The Intelligence Limits of Confidently Incorrect AI

Episode 32: The Intelligence Limits of Confidently Incorrect AI

In this episode of DevCast, our devs share their firsthand experiences using AI tools like Claude and Gemini for FileMaker development. They spotlight where they excel, where they fall short, and what...

28 Heinä 44min

Episode 31: What We’ve Been Building: Web App Edition

Episode 31: What We’ve Been Building: Web App Edition

In their spare time, John, Xandon, and Jacob have been creating personal web apps. John is creating a healthcare referral portal that easily and efficiently collects and processes referral submissions...

12 Kesä 39min

Episode 30: Using ExecuteSQL: A Cautionary Tale

Episode 30: Using ExecuteSQL: A Cautionary Tale

One little ExecuteSQL query can’t hurt… right? In this episode, the team unpacks the FileMaker performance issues hiding inside real-world solutions. Runaway SQL calls, invisible object calculations, ...

26 Touko 34min

Episode 29: Claude Cowork, AI Linguistics, and 3D Printing

Episode 29: Claude Cowork, AI Linguistics, and 3D Printing

Welcome to an inside look at how our devs are testing out where AI can help versus hinder every day work conundrums. Our team's focus in this meeting is Claude Cowork, a tool designed to track everyth...

22 Huhti 40min

Episode 28: Comparing Tools: FMPerception, BaseElements, 2empowerFM

Episode 28: Comparing Tools: FMPerception, BaseElements, 2empowerFM

The Portage Bay team sits down for a conversation about the tools and workflows that support their day-to-day work. Their discussion offers a behind-the-scenes look at how the devs approach problem-so...

5 Helmi 1h 3min

Episode 27: Meet HAM - Another Option for FileMaker Permissions (with Charles Delfs)

Episode 27: Meet HAM - Another Option for FileMaker Permissions (with Charles Delfs)

We had the pleasure of hearing Charles Delfs break down HAM (Headless Authorization Module) as he showed us how this system transforms the way you manage roles, permissions, and feature access in File...

15 Joulu 202558min

Episode 26: Click, Build, Deploy: FM BetterForms Updates Unwrapped

Episode 26: Click, Build, Deploy: FM BetterForms Updates Unwrapped

We’re diving into the latest updates to FM Better Forms and taking a closer look at one of our own client’s web apps built on the platform. We share what’s new in Better Forms and how we’ve used it to...

3 Marras 202548min