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 reports in many ways. In this instance, the virtual report allows you to see data in different ways. Just ask your developer about Virtual Lists and ExecuteSQL.

Here’s the video (Note:  Since FileMaker switched to a new community website, most videos and links are still missing.  As is this video and the example files. I can’t help with the video, but I have uploaded the missing example files here):

Download the Free FileMaker Example files and the presentation notes here.

FileMaker 17 won’t open files automatically

This happened to me, and other developers also remarked on it. After installing FileMaker Pro 17 on my Mac, double clicking on a FileMaker file did not open FileMaker 17 – unless, of course, you only have FileMaker Pro 17 on your computer.  But since most developers have multiple versions of FileMaker Pro, they discovered that the operating system did not make FileMaker 17 the preferred app to open FileMaker Files.

You can fix it. Here are the instructions:

The Mac opens data files (pics, sounds, docs) in applications automatically, but you can change which apps they use in a few simple steps.

It’s four simple steps, and will make your life a bit easier.

Source: Change the Default Application a File Opens With on Your Mac

You can’t use up creativity. The more you use, the more you have. 

Maya Angelou