Thanks for attending one of my sessions at FileMaker DEVCON 2017!
Please make sure to fill out an evaluation form below!
Bonus Offers:
- 30% off Live Training Class with Cris Ippolite in Los Angeles (OCT 24-27, 2017) Email traininginfo@isolutions-inc.com and mention “Training Day” for discount. Also visit the iSolutions booth at DEVCON for private onsite and mentoring training options.
- Lynda.com FREE 30-Day Trial for complete access to all Intermediate FileMaker Training Videos (links provided below by clicking the name of each topic below that is labeled “not covered”)
Calling all FileMaker Entrepreneurs! Want to join the best FileMaker team in the world? Reach out to learn more
TRA004 – FileMaker Training for Intermediate Developers
Community Page: https://community.filemaker.com/docs/DOC-8342
1. PDF of the Class Materials (see page numbers next to each topic listed below)
2. Exercise Files for each top below (Each file used in a top is referenced below)
Working with Complex Relationships
COMPLEX RELATIONSHIPS TOPICS COVERED 8:15-9:00am
File: 01_Swimmers
Context
File: 01_Swimmers
Parent and Child Table vs Parent and Child records
File: 01_Swimmers
Query Relationships
Lesson 9 Complex Relationships p3 (Activity 9.1) 02c_Bonsai-> Order_Detail
Creating Self-Relationship
Lesson 9 Complex Relationships p6 (Activity 9.2) 02c_Bonsai-> Customer_Detail
Using Relationships to Drill Through Data
File: 04_Invoices -> Customer Details
Related Fields in Calculations
Layouts/Interface
Topics Not Covered (click for video):
- Organizing Layouts
- Layout Setup
- Explicit Width
- Layout Parts
- Stencils
- Arranging and Aligning
- Tab Order
- Behavior
- Themes and Styles
LAYOUTS/INTERFACE TOPICS COVERED 9:00am -11:15am
Lesson 10 File: 05_Event Management -> Events pdf p34
– Wireframing
Activity 12.1 pg 29
– Inspector
File: 07_LayoutObjects -> Product Details
– Layout Object Window
File: 08_Invoices -> Product Details pdf p32
– Visibility
File: 09_Invoices -> Customer Details | iPad pdf p34
– iOS Touch Keyboards
File: 10_03_Bonsai -> Product Details pdf Activity 13.3 p44 and Activity 13.4 p 47
– Field Control and Value Lists
File: 12_03_Bonsai -> Order Detail pdf Activity 14.6 p63
– Popovers
File: 13_03_Bonsai -> Product Detail pdf Activity 14.7 p68
– Custom Web Viewer
File: 14_03_Bonsai -> Customer Detail pdf Activity 15.1 p74
– Object States
File: 15_03_Bonsai -> Customer Detail pdf Activity 15.2 p75
– Conditional Formatting
Calculations
Topics Not Covered (click for video):
CALCULATION TOPICS COVERED 11:15am-12:00pm
Materials p99 File: 17_03_Bonsai
– Other uses of Calculation Dialog
File: 18_03_Bonsai
– Calculations Fields vs Boolean Calculations
File: 19_03_Bonsai
– Calculated Replace
File: 20_Invoices
– Auto Enter Calculations and Calculated Validation
Lesson 20 Logical Functions p 103 File: 22_Logic
– If and Case Function Example
Lesson 23 Aggregate Functions p 107 File: 22_04_Bonsai -> Activity 23.1 pdf p108
– Aggregate Functions
Scripts
Topics Not Covered (click for video):
- Scripting Workspace
- Finding Using Scripts
- Creating Child Records using Scripts
SCRIPT TOPICS COVERED 1:00pm -2:30pm
File: 23_FTS Meetings -> Activity 26.1 pdf p113
Parameters
Parameter Demo file
File: Invoices Starter Solution
Script Variables
File: 24_Lambeau
Script Triggers
Lambeau file
Lesson 29 pdf p133 File: 23_FTS Meetings -> Activity 29.1 pdf p139
User Interaction
Lesson 32 Window Management pdf p142 File: 26_Window
New Windows and Cards
Lesson 33 pdf p146 File: 27_05a_FTS Meetings
Looping Scripts
Reporting
Topics Not Covered (click for video):
- Summary Fields
- Subsummary Parts
- Current Found Set (Individual Record Data Series)
- Current Found Set (Summarized Group Data Series)
- Current Record (Delimited Data)
- Related Records
REPORTING TOPICS COVERED: 2:45pm -3:30pm
Lesson 36 REPORTING p157 (Activity 36.3) 28_06a_Bonsai
Subsummary with No Body
Lesson 36 REPORTING p159 (Activity 36.4) 29_06a_Bonsai -> Order_List_6_2a
Ranking Reports
Lesson 36 REPORTING p161 (Activity 36.5) 30_06a_Bonsai -> Order_List_6_2b
Multi Level Subsummary Parts
Lesson 37 Charting p173 (Activity 37.1.5) 31_06a_Bonsai -> Order_Detail
Quick Charts
Lesson 37 Charting p176
Data Series
Lesson 37 Charting p181 (Activity 37.2) 33_06a_Bonsai -> Product_Detail
Current Found Set (Individual Record Data Series)
FileMaker 16 New Features
Recommendations:
Lynda.com: “FileMaker 16 New Features”
3:30pm-4:00pm
File: 36_FM Floors Demo
Mailchimp
iBeacon
Tableau Web Connector
JSON Parsing
COR003 – Preparing for FileMaker Certification
FileMaker Community Page: https://community.filemaker.com/docs/DOC-7366
Session Description
Becoming a certified FileMaker developer is a great way to let your clients, coworkers, and supervisors know you truly understand FileMaker and are committed to creating the best solutions possible. Passing the certification exam can be a daunting task as time management is critical, so you can benefit greatly by knowing what is coming and how to approach it. The exam covers all aspects of FileMaker, but it cover some areas more than others. Learn how to pass the test the first time you take it.
Who Should Attend:
Anyone interested in FileMaker Certification.
Products & Technologies
- FileMaker Pro
- FileMaker Pro Advanced
- FileMaker Go
- FileMaker Server
- FileMaker WebDirect
- CWP/XML/PHP
- xDBC
Session Materials
- Materials are not yet available for this session.
What You Will Learn
- How the certification exam is administered
- What is Topics are important to study
- Resources for study
- Question types and formatting
Bonus Offers:
- 30% off Live Training Class with Cris Ippolite in Los Angeles (OCT 24-27, 2017) Email traininginfo@isolutions-inc.com and mention “Training Day” for discount. Also visit the iSolutions booth at DEVCON for private onsite and mentoring training options.
- Lynda.com FREE 30-Day Trial for complete access to all Intermediate FileMaker Training Videos
Important Links
- FileMaker 14 Exam Overview
- Preparing for FileMaker 14 Certification
- FileMaker 15 Exam Overview
- Preparing for FileMaker 15 Certification
- Schedule your FileMaker Certification Exam at PearsonVue.com
- Certification Info on FileMaker.com
- Certification FAQs
Study Materials Mentioned in Session:
- In-Depth: Container Fields
- In-Depth: Charting
- Design Interaction
- Best Practices File Recovery
- Best Practices File Management
- Best Practices: External SQL Data Sources
- iOS Sync
- iOS: Performance
- Security Guide for FileMaker 14
- FileMaker Server 14 Configuration Guide
FileMaker 16 Certification Study Guide
2016 DEVCON INN001 – FileMaker Go and iOS Apps: One-Step Integration
Community Page: https://community.filemaker.com/docs/DOC-7390
Click Here to Evaluate Session
DOWNLOAD THE URL SCHEME iOS EXAMPLE FILE: Here
Demos include:
- Scanning a document using OCR and embedding the text in your custom app
- Editing an image before storing it in a container
- Send Driving directions to Maps
- Add a call reminder to the notification center from your CRM
- Translate text and store translation in your app
- Assign a task, notify assignee via SMS and allow them to accept
- Initiate a call, then log the call in your custom app
Workflow.is Examples:
Next Location:
https://workflow.is/workflows/8dd8d0c4d01b4502975a033009a202be
NextLocationSMS:
https://workflow.is/workflows/0aa875f85573427c9e84f3f1d5955c07
Edit Image:
https://workflow.is/workflows/6bcb40f8686a479bbe57d52d8b94bc4d
Test Question:
https://workflow.is/workflows/50660bcf0bf947f1b05f170c6a3bacf2
IFTTT Examples:
Turn Off Hue Lamp
https://ifttt.com/recipes/439345-turn-off-hue-lamp
Turn Hue Lamp Green
https://ifttt.com/recipes/439346-turn-hue-lamp-green
Turn Hue Lamp Red
https://ifttt.com/recipes/439347-turn-hue-lamp-red
THANKS and if you find any of these files useful, please do not forgot to mention that in your session evaluation here: www.filemaker.com/devcon/evaluations