| Save to Calendar |
FTS: An Introduction to the FileMaker Training Series (FTS) Track (no fee required)
Monday
10:00 a.m.
|
FTS |
Beginner |
|
Session Description
This session will be open to all DevCon attendees. You'll have an opportunity to meet the FileMaker Authorized Trainers delivering the respective modules and key areas that they will focus on in their sessions. We'll discuss the best ways to use and learn from the FileMaker Training Series to enhance your skills, and to prepare for FileMaker Certification.
What You Will Learn
- Overview of the FTS track sessions
- Who the FTS speakers are and what they will focus on
- Getting through the tracks and some housekeeping
- Answers to frequently asked questions about the training series and certification
|
| Save to Calendar |
FTS: Data Modeling
Monday
10:30 a.m.
|
FTS |
Beginner |
|
Session Description
This session will cover content from Module 3 of the FileMaker Training Series. A solid understanding of data modeling is essential for developing efficient and effective database solutions. In this session, we will take real world scenarios, create data models and then express that in a FileMaker relationship graph. Along the way, we will investigate the terminology and methods associated with data modeling, and the unique features of the FileMaker relationship graph. Finally, we will review the various tools and methods available in FileMaker Pro for leveraging the relationship structures you create.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- To translate real world scenarios into data models with entities and attributes
- Create and understand an entity relationship diagram (ERD) and how it relates to the FileMaker relationship graph
- Understand elements of the FileMaker relationship graph - table occurrences and relationships
- Use relationships to drive portal display, record filtering and scripting
|
| Save to Calendar |
FTS: Layouts
Monday
1:30 p.m.
|
FTS |
Beginner |
|
Session Description
This session will review the use, setup, and behavior of layouts and layout objects. We will examine field and object control options and when they can be used; the how, when, and where of conditional formatting; and what you need to know about layout themes. We will look at the design toolset in FileMaker 12 and how it can help you provide a modern user experience. We will also discuss the layout design process and platform specific considerations (Desktop, iPad, iPhone).
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
Products & Technologies
- FileMaker Pro 12
- FileMaker Go
What You Will Learn
- Use fields and portals to express appropriate views of data
- Use graphical formatting tools to visually help users understand their data
- Use layout themes
- Use Layout Mode tools for development efficiency
|
| Save to Calendar |
FTS: Calculations
Monday
3:45 p.m.
|
FTS |
Beginner |
|
Session Description
Calculation functions are the lifeline of FileMaker. They are used throughout the application for everything, from defining fields to scripting, security, and conditional formatting. If there's one thing that can make you a better FileMaker developer across the board, it's having a solid grounding in the use of calculation functions. In this session, you'll learn about the core calculations that every FileMaker developer needs to be adept with, as well as practical applications of their use.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- Syntax and usage of dozens of core calculation functions
- Best practices for writing effective and efficient calculations
- Practical applications for using functions
- Tips for learning new functions
|
| Save to Calendar |
FTS: Scripting
Tuesday
10:45 a.m.
|
FTS |
Intermediate |
|
Session Description
Scripting is a major artery in any FileMaker system due largely to the fact that it allows you to automate laborious and time-consuming manual processes. Despite the plethora of possible processes worthy of automation there are common design patterns - sequences or arrangements of script steps - that serve as the building blocks for script after script. Examples of these design patterns include interacting with the user, finding data, error trapping, navigating to related records, and looping over a set of records. By focusing on the common patterns, you will learn the building blocks necessary for creating scripts in your own database solutions.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- Discover patterns in scripting
- Write scripts that make use of modal dialogs, loop through data sets, and output data
- Use the script debugger and data viewer to troubleshoot scripts
- Set up layout and object level script triggers as well as attach scripts to buttons
|
| Save to Calendar |
FTS: Reporting
Tuesday
3:45 p.m.
|
FTS |
Beginner |
|
Session Description
This session will teach the essentials of FileMaker Pro 12 sub-summary reporting and working with charts, based on Module 7 of the FileMaker Training Series (lessons 7.1, 7.2, and 7.3). We will focus on planning reports and using scripts to incorporate them into your workflow, defining layout parts and summary fields, creating ad-hoc summary reports in table view, advanced sub-summary reports, and finishing with an introduction to Quick Charts.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- Defining layout parts and summary fields
- Advanced reports such as summary-only or summarizing by multiple variables
- Using scripts and triggers to enable users to quickly generate reports
- Ad-hoc reporting with table view and quick charts
|
| Save to Calendar |
FTS: Security
Wednesday
9:00 a.m.
|
FTS |
Beginner |
|
Session Description
Implementing a proper security model only begins with controlling whether or not someone can log into a database. FileMaker Pro includes a robust set of features for controlling which users have access to what information and what they can do with that information via the accounts and privileges settings. This session will provide a comprehensive overview of FileMaker's security model and demonstrate how to restrict users from particular operations or information within a database, how to associate privileges with authenticated accounts, and how to control specific features within a database based on a given user's assigned privileges.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
Products & Technologies
- FileMaker Pro
- FileMaker Server
- OSX/Windows
What You Will Learn
- Understanding security controls in FileMaker files
- Creation and management of accounts and privilege sets
- Restricting record deletion
- Approaches for implementing conditional record access
|
| Save to Calendar |
FTS: FileMaker Server
Wednesday
10:45 a.m.
|
FTS |
Beginner |
|
Session Description
This session is designed to strengthen the beginner and/or intermediate FileMaker developer's knowledge of FileMaker Server by reviewing the ABC's of deployment, administration, and configuration coupled with an inside look at best practices and new features.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
Products & Technologies
- FileMaker Server
- virtual environments
What You Will Learn
- Increased familiarity with FileMaker Server 12's new features
- Inside look at best practices for FileMaker Server deployment and configuration
- Inside look at best practices for FileMaker Server administration
|
| Save to Calendar |
FTS: Connectivity
Wednesday
2:00 p.m.
|
FTS |
Intermediate |
|
Session Description
One of the great strengths of FileMaker Pro software is its ability to share data with other applications. Not only can FileMaker Pro make its own data available technologies compatible with Open Database Connectivity (ODBC), it can access data stored in other systems as well. This session covers the ways in which FileMaker Pro can share data using ODBC, a database interchange technology. Using ODBC, you can import data from sources, such as SQL databases, into your FileMaker Pro solution. Likewise, you can make data from your FileMaker Pro solution available to other programs that use ODBC. The session will also cover connecting through the External SQL Sources (ESS) feature in FileMaker Pro, where you can directly access certain kinds of SQL-based data from within a FileMaker Pro system. Attending this session will also help prepare you for the FileMaker certification exam in regard to Connectivity questions.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
What You Will Learn
- Different ways of interacting with other data sources using ODBC technologies
- The requirements and procedures for configuring data source names (DSNs) to connect to specific ODBC data sources
- How to use the ESS feature to integrate SQL data sources directly with FileMaker Pro solutions
- The requirements and procedures for using a FileMaker Pro solution as an ODBC data source
|
| Save to Calendar |
FTS: FileMaker Go
Thursday
9:00 a.m.
|
FTS |
Beginner |
|
Session Description
FileMaker Go 12 for iPhone and FileMaker Go 12 for iPad are free apps that allow you to turn your database into a mobile app. This is a beginner level session that starts with an introduction to FileMaker Go 12 and how it differs from FileMaker Pro. We'll work with the control styles built into FileMaker Go and special features available for capturing container field data. We will design layouts specific for the touch interface. Finally we will look at some useful scripts and reporting options when using FileMaker Go.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
Products & Technologies
- FileMaker Pro
- FileMaker Go
What You Will Learn
- FileMaker Go 12 and how it differs from FileMaker Pro
- Using FileMaker Go
- Designing layouts for the mobile user
- Useful scripts and reporting in FileMaker Go
|
| Save to Calendar |
FTS: FileMaker Web Publishing
Thursday
10:45 a.m.
|
FTS |
Intermediate |
|
Session Description
The web technologies in FileMaker Server and FileMaker Pro allow you to give your solutions a very broad reach. However, there are some trade offs to be aware of, which this session will discuss in detail. Web technologies allow users to interact with a FileMaker Pro solution using only a web browser. This session will discuss both Instant and Custom Web Publishing options available as well as considerations for both. There will also be discussion on setting up Web Publishing and the required Server components and additional software you will need to publish your FileMaker Pro data to the web. Additional things you will learn: PHP syntax and API installation.
Note: A Gold Pass is required for all FTS sessions. Attendees will receive one DVD of the FTS materials (includes modules, videos, exercise and demo files).
Products & Technologies
- FileMaker Pro
- FileMaker Server
- FileMaker Server Advanced
What You Will Learn
- Web publishing options avail and their required server version
- Instant web publishing review
- PHP API syntax and installation
- Server components setup
|
| Save to Calendar |
Preparing for FileMaker Certification: Next Steps (no fee required)
Thursday
12:00 p.m.
|
FTS |
Beginner |
|
Session Description
Preparing for the FileMaker Certification Exam doesn't stop with just the FTS materials. This session will review all the resources available to those who wish to properly prepare for the exam. Recommended reading and additional study guides will be reviewed as well as a discussion on how and where to take the exam. This session will introduce attendees to the "next steps" for preparing for certification. Attendees will also have time to ask questions about FileMaker Certification. (Lunch will be provided at this session.)
What You Will Learn
- Exam logistics
- How the exam process works
- Additional resources for preparing for the exam
- Next steps for becoming certified
|