2017 DEVCON Session Materials


Thanks for attending one of my sessions at FileMaker DEVCON 2017!

Please make sure to fill out an evaluation form below!

Bonus Offers:

  • 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):

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):

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:

Important Links

Study Materials Mentioned in Session:

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

DemoFileScreenShot

Demos include:

Workflow.is Examples:

Download Workflow

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:

Download IFTTT

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