Flexible Reporting with Virtual Lists and ExecuteSQL I wrote about Martha Zink’s FileMaker DevCon 2018 presentation on Virtual Lists and ExecuteSQL about a month ago. The video has been released by FileMaker, and I recommend every developer to watch it. Non developers, walk away with the knowledge that FileMaker has the ability to produce powerful […]
Virtual Lists and ExecuteSQL But first, a side note The past three years I’ve attended DevCon, I’ve devoted all my time to interviewing well known FileMaker people and FileMaker vendors. And I’ve enjoyed the experience immensely. But for DevCon 2018, I made a change: I collected business cards of people I wanted to interview, and […]
Use Virtual Lists with JSON Arrays to build faster reports Kevin Frank spends a lot of time optimizing code to speed up reporting, and generously shares it with the FileMaker community. This last go around includes building virtual list using JSON arrays, a natural fit for virtual lists. Why? Pretty much all of the data […]
Faster Reports with PSOS and Virtual Lists Anders Monsen’s DevCon 2017 presentation is loaded with great tips about PSOS and Virtual Lists, something your clients need from time to time. He doesn’t stop there, however, as he combines the use of ExecuteSQL to really speed up reporting. If you haven’t heard of Virtual Lists, it’s […]
Free FileMaker Downloads Day! The Free FileMaker Example list has been around for over a year now, and has some interesting statistics: Over 20,000 views! 247 (and counting) free downloadable files Free downloadable FileMaker example files from all over the world An example file for almost every kind of problem or solution you can think of […]
William Porter of MacWorld assesses the release of FileMaker 15 in his article: With version 15, the FileMaker platform gets better, and it was pretty good already. But in terms of features, FileMaker 15 is an evolutionary rather than revolutionary release. Many existing users may not feel the need to rush to upgrade, and both new […]
The virtual list technique has been around quite a while, and is very useful for displaying information from multiple tables in one cross tab report. Jeremy Brown of Soliant wrote a two part series recently on how he applied the virtual list to a problem he faced: FileMaker is a great platform. With its user […]
The need to export FileMaker data to Excel with custom column names is something most developers will encounter from time to time. Face it, people don’t want to read obscure column names or try to figure out what they really mean when they need to change them. Jeroen Aarts of Clickworks shares his technique: Could you […]
DOUGLAS ALDER addresses the UTF-8/16 export problem brought about by a decision made long ago by FileMaker programmers: In my last post about exporting Calendar files, I glossed over the UTF-8/16 issue that is still present in FileMaker Pro. The problem is that if a script employs “Export Field Contents”, which my last demo did, there is […]
KEVIN FRANKS extends his excellent series of posts on virtual lists – this time showing how to displays 3 columns of the same data in browse mode: Recently a question came up on the FMP Experts list re: the possibility of displaying a found set of customers in 3 columns in browse mode in FileMaker […]
Anders Monsen boils it down to 3 steps… Virtual List in Three Easy Steps Published on April 12, 2013 by Anders Monsen The Virtual List technique has been around for a few years (created by Bruce Robertson ca. 2009). Over time and with changes to FileMaker, implementation of this technique has evolved. Knowing how to […]
Great blog post – Kevin Frank always amazes… Conditional Subsummary Report in Browse Mode Posted on September 22, 2013 by Kevin Frank Last time we looked at several summary reporting tricks, including a conditional subsummary when an item’s Status is “Scheduled” it will have a value in the Substatus field — otherwise Substatus will be […]
Business Minute 22 - Above and Below the Line Thinking - FileMaker Pro Gurus: [...] Conditional Subsummaries in Browse Mode (FileMaker) [...]
A preview of a longer video that requires signup to the magazine (well worth it). FileMaker Tutorial – Virtual List Portal Sidebar – YouTube.
Matt Greger: Thanks Don! I just posted the setup for configuring the Redshift ODBC connection via FileMaker Server on Windows. One interesting…
Don Clark: You are welcome, Matt! And thanks for that info, Matt. I thought PostgreSQL was included in FM 15–my mistake. I'll…