2018 DEVCON Session Materials


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

Please make sure to fill out an evaluation form below!

Bonus Offers:

 

Below you see this icon ( 🎬 )…clicking the icon (using your existing lynda.com account or your trial from above) allows you to see a video on the topic being covered.

Clicking on a file name (##_01) will download the sample file used for this section

 

2018 Sessions

Training Day Intermediate: Relationships 

8:30-12:00pm in TEXAS B

 

0. Intro / Data Modeling  🎬

8:30am-8:55am 

  • Why relational?  🎬
  • Relational Modeling  🎬
  • What information do I want to manage 
  • What tables do I need (Identifying Entities)
  • Plan before you build (blueprint)

1. Relationships 

8:55am- 9:10am

  • Types of relationships     🎬
  • Diagramming relationships   🎬

2. Many to Many Relationships 

9:10am- 9:25am

  • Why Many to Many are bad 02_01   🎬
  • Join Tables  02_02   🎬
  • How add-on Tables solve Many to Many

3. Key Fields  🎬

9:25am- 9:35am

  • Primary Keys
  • Foreign Keys

4. Defining Relationships in the Relationship Graph 

9:35am- 9:55am

  • Adding Tables   🎬
  • Adding Keys   🎬
  • Creating Relationships   🎬

5. Borrowing from Related Tables 

9:55am- 10:15am

 

10:15am-10:30am BREAK

 

 

6. Working with Queries

10:30am- 10:55am

  • Base Table Relationships vs Query Relationships  06_01     🎬
  • Multiple predicate (query) 06_02       🎬
  • Using operators in matches 06_03     🎬

 

7. Relating Child Records to Parents

10:55am- 11:20am

  • Creating child records through a value list 07_01   🎬
  • Creating child records using relationship options (via portal) 07_02    🎬
  • Creating child records using a script  07_03   🎬

 

8. Review Examples  

11:20am- 11:55am

 

9. Using Relationships (Optional)

PLEASE EVALUATE

 

More Relationships Training Resources:

Download FileMaker Training Series : Relationships

 

Training Day Intermediate: Calculations 

1:00-4:30pm  in TEXAS B

 

INTRO 

1. Calculation Dialog   🎬

1:00pm-1:10pm

  • Calculation vs Boolean 01_01
  • Storage option
  • “Evaluate when all empty”
  • Data Viewer
  • Specify context
  • Different Places where you find the Calculation Dialog

 

2. Number Functions  🎬

1:25pm- 1:35pm

3. Date and Time Functions  🎬

1:35pm- 1:45pm

  • Extracting data from DATE fields 03_01
  • Constructing Dates from other fields/values

 

4. Text Functions   🎬

1:45pm- 2:30pm 

  • Auto-Enter 04_01
  • Field Filtering
  • Parsing data
  • Calculated Replace
  • Calculations in Validation

2:30pm-2:45pm BREAK 

 

5. Container Functions 

2:45pm- 2:55pm 

 

6. Aggregate Functions   🎬

2:55pm- 3:10pm 

  • Aggregating related values 06_01
  • Sum( )
  • Count( )

 

7. Logic Functions    🎬

3:10pm- 3:30pm 

  • IF( )  07_01
  • CASE( )
  • LET ( )

 

8. Get Functions 

3:30pm- 3:40pm 

  • Get(RecordNumber)  08_01
  • Get(ActiveRecordNumber)
  • Get(TotalFoundCount)
  • Get(SortState)

 

9. Mobile Functions 

3:40pm- 3:55pm 

  • GetSensor  09_01  🎬
  • Location
  • Region Monitoring 09_02    🎬
  • Get(Device)
  • Get(SystemPlatform)
  • Get(NetworkType)

 

10. Custom Functions

3:55pm- 4:00pm 

 

11. Other Uses of Calculation Dialog (Optional)

4:00pm- 4:25pm 

 

12. Closing 

4:25pm- 4:30pm 

 

PLEASE EVALUATE

 

More Calculations Training Resources:

Download FileMaker Training Series : Calculations

 

 

 

 

 

2017 Sessions

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 Sessions

 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