ExecuteSQL Function- Day 10 of 12 Days of FileMaker 12 Web Series
Thursday, May 10th, marked Day Ten of FM Academy’s 12 Days of FileMaker 12 Web Series. ExecuteSQL Function, hosted by Greg Lane at Skeleton Key summary: FileMaker 12 adds a dozen new functions, including the much anticipated ExecuteSQL, some Location functions for iOS devices, new ID functions, a set that accompany the new container method, and others. FileMaker 12’s new ExecuteSQL function opens up the power and flexibility of the SQL query language to any FileMaker calculation. This webinar presented techniques for using the ExecuteSQL function within calculations to gather and manipulate data for reports, charts, dashboards, and more. We used a variety of built-in and custom functions to slice and dice data in any context. We also covered the basics of the SQL SELECT statement so anyone can get started quickly. If you missed the Webinar, and would like to watch these examples of the new ExecuteSQL Function, the video is available on FileMaker Academy’s YouTube Channel. In the meantime, you may download the demo file, with all the examples shared during the webinar, by clicking HERE. Day Eleven of the web series is Tuesday, May 15th, 2pm – 3pm (EST), hosted by Anvil Dataworks. The topic: Script Trigger Enhancements. Register today. About FM Academy FM Academy is a consortium of seven FileMaker Business Alliance Platinum companies. Our goal is to educate FileMaker users and developers, encourage best practices, and foster adoption of the FileMaker platform. The members of FM Academy are 360Works, Anvil Dataworks, Fiddlehead Software, IT Solutions, KyoLogic, MightyData and Skeleton Key. Nancy Rodriguez manages Operations & Marketing at Skeleton Key.
About Skeleton Key
Skeleton Key is an accomplished team of technology consultants who solve business problems. We specialize in the rapid development of custom applications, integrating Macs and PCs in the professional workplace, and providing personalized FileMaker training and coaching. Despite our end-to-end technical skills, we are consultant first and technologist second. We know that you don’t just need technology. You need to know that the technology you choose to deploy will provide the results you desire. Skeleton Key is a Platinum Level FileMaker Business Alliance company, an Authorized FileMaker Trainer, a member of the Apple Consultants Network and a Microsoft Registered Partner. …