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. …

Interested in Learning More About Open-Book Management?

Next week marks the 20th annual conference on Open-Book Management, the Gathering of Games. The conference will be held at the Hyatt Regency St. Louis at the Arch from May 9th through 11th. Conference participants will celebrate and kick off the 20th Anniversary of the Gathering of Games on May 9th, 6pm, at Busch Stadium, home of the 2011 World Series Champions. This networking reception will be an all-inclusive event: dinner, drinks, tour of the stadium, and a Q&A with Jack Stack. During the conference, the Great Game of Business will announce the 12th annual All-Star Award Finalist and Winners. On May 10, they will host a ceremony to recognize and celebrate the remarkable achievements of companies from around the globe that have fully embraced the principles of Open-Book Management and The Great Game of Business and have demonstrated outstanding results. The Open Book community will honor three (3) finalists with the coveted All-Star Award, as well as the Rookie of the Year and Hall of Fame Inductee of 2012.

Why attend?

The Gathering of Games is a great opportunity for any business leader to objectively evaluate the pros and cons of Open-Book Management and decide if it could be right for them. Through a rich schedule of workshops, sessions, and the All-Star awards ceremony, they gain valuable opportunities to share best practices with peers and compare what works and what doesn’t. Fresh ideas and inspiration will be plentiful and flowing from the All-Stars, the top performers in the OBM community. Conference participants will take away tons of useful tips and tools that can be implemented immediately into their own business. Finally, they will see first-hand how to turn ‘Sharing the Numbers’ into measurable, sustainable results to improve the bottom line. Registration and information for the Busch Stadium Networking Reception and for the Gathering of Games Conference is available online. 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. …