"12 Days of FileMaker 12" - Week 5

Discussion created by beyondthechaos on May 7, 2012

FM Academy, a collaboration of leading FileMaker development and training companies, is proud to announce the 12 Days of FileMaker 12 webinar series. Each Tuesday and Thursday for six weeks the Academy will host a 60-minute webinar on a new feature of the FileMaker 12 product line. This week features:


TUESDAY, May 8, 2pm EDT

Webinar 9: New Calculation Functions. 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. Functions are part of the building blocks of FileMaker calculations. Many of the new enhancements in FileMaker 12 may require scripting changes, or open possibilities for information and action based on what these functions provide. While the ExecuteSQL may draw a great deal of attention from developers, we need to be aware of these other functions, their purpose, and how to integrate them into our solutions.


Anders Monsen is the presenter. He is the Architect of Integration for MightyData, an FBA Platinum Member. A FileMaker Pro 9-11 Certified Developer and Authorized Trainer, he has spoken at FileMaker’s DevCon in 2010 and 2011, and authored an article on FileMaker and PHP for FileMaker Advisor.


THURSDAY, May 10, 2pm EDT

Webinar 10: ExecuteSQL Function. FileMaker 12’s new ExecuteSQL function opens up the power and flexibility of the SQL query language to any FileMaker calculation. This webinar will present techniques for using the ExecuteSQL function within calculations to gather and manipulate data for reports, charts, dashboards, and more. We’ll use a variety of built-in and custom functions to slice and dice data in any context. We’ll also cover the basics of the SQL SELECT statement so anyone can get started quickly.


Greg Lane is the presenter. He is VP of Application Development at Skeleton Key, a FileMaker Business Alliance Platinum level member in St. Louis, Missouri. He is a FileMaker 7, 8, 9, 10, and 11 certified developer and has enjoyed solving problems with FileMaker for more than 20 years. Greg has authored articles for FileMaker Advisor Magazine and has contributed to books, white papers, and other FileMaker-related publications. He is looking forward to speaking about FileMaker and SQL again at the 2012 FileMaker Developer Conference.


Free registration for the complete series schedule is available immediately. Once you register for the series, you will receive email reminders for each session. The only thing you need to attend is a computer, iOS or Android device and a WiFi connection.


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.