Thursday, August 13 Thursday | Friday | Saturday | Sunday
| Time | Session Name | Track Session | Level |
FIleMaker Training Series (FTS) Sessions
| 8:00 AM | Calculation Functions | FTS | Intermediate |
John Mark Osborne (Database Pros)
Session Description Learn how to implement a calculation to filter a phone number. From the Data Viewer to validation, this session will cover the entire process of designing a calculation that works in every scenario. The complete formula will include checks and balances for 7 and 10 digit numbers, a discussion of the interaction between auto-enter and validation, Custom Functions, the Self function and much more.
Products & Technologies
- Scripting
- Calculations
What You Will Learn
- Learn optimized practices that drastically reduce your design and development time
- Discover out how to use the Let, Filter, Case, Self, text functions and more
- Determine the best place to implement a calculation formula for your solution
| 8:00 AM | Data Modeling | FTS | Intermediate |
Scott Love (Soliant Consulting, Inc.)
Session Description This session begins by introducing some of the basic concepts that underlie data modeling. It will delve into such concepts as entities, attributes, and relationships. The second half of the session will show you how to apply these concepts to get effective and useful work done in FileMaker Pro.
Products & Technologies
- Design Tips
- RDB Modeling
- Development Standards
What You Will Learn
- Identify cases where one-to-many or many-to-many relationships are appropriate
- Break a real-world scenario into a set of entities and their attributes
- Create an entity-relationship diagram (ERD)
- Create relationships between FileMaker Pro tables
| 10:30 AM | Working with Layouts | FTS | Intermediate |
Bob Bowers (Soliant Consulting, Inc.)
Session Description In this hands-on session, attendees will gain practical experience working with layouts in FileMaker Pro. Specifically, you will learn how about field formatting and field behavior options, as well as how and why to set script trigger options for layouts and objects. You will also learn how to set auto resize options for layout objects. This workshop is intended for beginning to intermediate developers.
Products & Technologies
- Design Tips
- User Interface
- Scripting
What You Will Learn
- Be more proficient at using the status toolbar and basic layout controls
- Understand how to use field formatting and field behavior to control input into a field
- Know how and why to set script trigger options for layouts and objects
- Be adept at setting auto resize options for layout objects
| 1:30 PM | Reporting | FTS | Beginner |
Cristoffer Ippolite (iSolutions, Inc.)
Session Description "One of the key features of FileMaker Pro is its powerful reporting capabilities. As a developer, you can use these capabilities to create reports that allow users to better understand and analyze their data. An effective report can be anything from a simple list view to a basic subsummary or even a complex HTML report. This module will guide you through the process of building several types of reports in FileMaker Pro and demonstrate various uses of each type. In this lesson, you will learn how to create various types of reports using sub-summary parts in your layouts. You will also learn how to control the contents of a web viewer to create a report in HTML."
Products & Technologies
- Design Tips
- Scripting
- Calculations
What You Will Learn
- Be able to create a basic subsummary report
- Create bodiless subsummary report, ranked and multiple variable summaries
- Using the web viewer to create reports using the Set Web Viewer script step
| 3:30 PM | Advanced Techniques | FTS | Intermediate |
Scott Love Soliant Consulting, Inc.)
Session Description This session will focus on the list-detail/preview pane functionality described in Lesson 9-3. We will explore the lesson in good detail; students will learn how to work with global fields, develop for multi-user scenarios, learn conditional formatting, use multi-line match fields, and gain some advanced scripting best practices. This 'deep dive' will synthesize material presented in prior sessions and use a specific real-world element of functionality to pull together the fundamentals of FileMaker Pro into one hands-on example
Products & Technologies
- Design Tips
- Developer Tools
- Scripting
What You Will Learn
- Be able to dynamically control the contents of a portal
- Know how to work with value lists in creating relational associations
- Understand two techniques for portal sorting
- Be familiar with more advanced scripting techniques
PreCon Sessions
| 8:00 AM | Designing FileMaker Solutions | PreCon | Beginner |
Katherine Russell (Russellware, Inc.)
Session Description For many of us, developing with FileMaker is an organic experience, growing out of a need for a quick solution. But quick doesn’t have to mean dirty, and it doesn’t have to mean skipping important requirements. This session offers basic tools for rapidly assessing the structure of a new solution, creating a model on which to base the solution, and producing a solution that provides a high-quality user experience.
Products & Technologies
- Development Standards
- Development Tips
- Design Tips
What You Will Learn
- How to structure an efficient database
- How to create models of user processes and data that meet solution requirements
- How FileMaker tables, fields, and relationships combine to offer elegant and tightly integrated solutions
- How layouts, scripts, and “hidden” elements such as custom functions enrich the user experience
| 8:00 AM | Intro to PHP | PreCon | Intermediate |
Jonathan Stark (Jonathan Stark Consulting, Inc.)
Session Description PHP is arguably the most popular and ubiquitous scripting language on the web. FileMaker Server 10 supports Custom Web Publishing with PHP natively, so it's time to get to know PHP.
Products & Technologies
- HTML
- PHP
- FileMaker API for PHP
What You Will Learn
- How PHP fits into the Web publishing puzzle
- How PHP compares with other Web publishing options
- Core syntax of the PHP language
- Practical FileMaker/PHP examples
| 10:30 AM | Effective and Reliable FileMaker Security | PreCon | Intermediate |
Steven Blackwell (Management Counseling Services)
Session Description In challenging economic times it is exceptionally important to have confidence in the reliability of the technologies we utilize. The adverse impact on an organization of unreliable technologies can range from mild to catastrophic. If FileMaker Pro solutions are unreliable this has a host of consequences for organizations that use them. The core purpose of FileMaker Pro security is to preserve the Confidentiality, Integrity, and Availability of databases and of the business processes these databases manage and enforce. This program is designed for beginners to mid-level intermediate developers and users and will examine the underpinnings and foundations of the modern FileMaker security system. High level intermediate to advanced level developers may also find it useful for review and emphasis on core elements.
Products & Technologies
- Security
- FileMaker Server
- Development Standards
What You Will Learn
- What is security and what is its purpose?
- What are the impacts and the consequences on the owners and users of the databases if there is no security or if security fails?
- What are the two key parts of the FileMaker security system?
- After you have done everything right about security, what else do you still have to do?
| 10:30 AM | Functions & Formulations: An Introduction to FileMaker Calculations |
PreCon | Beginner |
Darren Terry (Pacific Data Management, Inc.)
Session Description This pre-conference session is a beginner-level survey of calculations in FileMaker Pro. The goal of the session is to familiarize you with the elements that go into making a successful calculation formula. Topics covered will include: Introduction and overview of the calculation dialog box and its elements, introduction of key concepts involved in calculations (functions, parameters, expressions, operators), Examination of such key concepts as calculation result types and conditional logic, and tips on calculation troubleshooting and how to format your formulas to make them easier to maintain in the long run. By the end of this pre-conference session, you will have a working database with example calculations that can easily be replicated in real-world solutions.
Products & Technologies
- Development Tips
- Calculations
What You Will Learn
- Learn the basics of FileMaker Pro calculations -- techniques that you can apply to your solutions today
- Learn the anatomy of calculation functions and expressions
- Discover how to let FileMaker do the heavy lifting of data manipulation for you
- Unravel the mysteries of subjects like conditional logic and data parsing
| 1:30 PM | SQL and ODBC Basics for FileMaker Developers | PreCon | Intermediate |
Greg Lane (Skeleton Key)
Session Description FileMaker 10 provides a variety of ODBC-related features for sharing data with other applications and database systems. This session is intended for any FileMaker developer who needs to gain a fundamental understanding of ODBC, SQL, and ESS and how these technologies can be used to make your organization’s data more valuable. We’ll unravel the acronyms and demonstrate practical examples of how to access information in other database systems from FileMaker and how to access information in FileMaker from other systems. Learn the pros and cons of each of the different ODBC-related capabilities FileMaker 10 has to offer. We'll explore FileMaker's SQL Query Builder for creating simple queries and learn how to extend these generated SQL statements to create more potent results. We’ll cover practical uses for each type of SQL statement supported by the FileMaker ODBC client drivers. Learn about important SQL expression elements including various operators, functions, and constants. Learn about ODBC data types and how to convert between data types.
Products & Technologies
- Data Integration
- ESS
- External APIs
What You Will Learn
- Learn the fundamentals of ODBC, SQL, and ESS and when each of the technologies can be used
- See specific examples that show how to configure and use each of FileMaker’s ODBC technologies
- Discover practical ways to use each of the basic SQL statements
- Find out what's new in ESS and ODBC in FileMaker 10
| 1:30 PM | Philosophy of Scripting 101 Part I | PreCon | Intermediate |
John Mark Osborne (Database Pros)
Session Description Scripting is much more than navigating between layouts. This session will uncover the philosophy of scripting in order to develop a completely scripted interface for your FileMaker solution. With techniques like the Ultimate Find, you’ll learn the importance of scripting to create a professional solution.
Products & Technologies
- Scripting
- Calculations
What You Will Learn
- Conditional Scripting
- How to Combine Calculations and Scripts
- Error Capturing
- Dynamic Scripting
| 3:30 PM | Philosophy of Scripting 101 Part II | PreCon | Intermediate |
John Mark Osborne (Database Pros)
Session Description Scripting is much more than navigating between layouts. This session will uncover the philosophy of scripting in order to develop a completely scripted interface for your FileMaker solution. With techniques like the Ultimate Find, you’ll learn the importance of scripting to create a professional solution.
Products & Technologies
- Scripting
- Calculations
What You Will Learn
- Conditional Scripting
- How to Combine Calculations and Scripts
- Error Capturing
- Dynamic Scripting
Opening Session
| 6:30 PM | Opening Session |
Session Description FileMaker executives will showcase FileMaker products and technologies for today and beyond.