FileMaker 16

What’s included

$14.99 / $24.99

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

4.59

Pay once, own it forever

Video Courses

0100 - Introductions - Overview

Lectures	Duration
1. 0102 - The FileMaker Platform -Summary	7m 29s
2. 0105 - Installing FileMaker andDowngrades	8m 46s
3. 0106 - Buying / Licensing FileMaker -FLT	6m 29s
4. 0107 - Pro for FLT & ConcurrencyConnections	13m 48s
5. 0108 - New Feature Brain Dump forNew and Intermediate Users	8m 50s
6. 0109 - The New Windows Interface	3m 6s
7. 0113 - Basics of Sharing a Database	13m 36s
8. 0115 - Upgrading 12, 13, 14, or 15Solutions to FM16	7m 49s
9. 0117 - FM Pro Vs	2m 26s

1. 0102 - The FileMaker Platform -Summary

7m 29s

2. 0105 - Installing FileMaker andDowngrades

8m 46s

3. 0106 - Buying / Licensing FileMaker -FLT

6m 29s

4. 0107 - Pro for FLT & ConcurrencyConnections

13m 48s

5. 0108 - New Feature Brain Dump forNew and Intermediate Users

8m 50s

6. 0109 - The New Windows Interface

3m 6s

7. 0113 - Basics of Sharing a Database

13m 36s

8. 0115 - Upgrading 12, 13, 14, or 15Solutions to FM16

7m 49s

9. 0117 - FM Pro Vs

2m 26s

FM Starting Point Walkthrough

Lectures	Duration
1. 0201 - FMSP Walkthrough - Intro	6m 23s
2. 0202 - FMSP Device Support & LayoutOrganization	5m 22s
3. 0203 - Script Numbering andOrganization	4m 10s
4. 0205 - Whats new in FMSP 5?	6m 30s
5. 0207 - FMSP Account & ContactsWalkthrough	17m 24s
6. 0208 - FMSP Invoice Walkthrough	9m 12s
7. 0211 - FMSP Sales Followups	14m 37s
8. 0212 - FMSP Invoice - New Line Items- Advanced	14m 25s
9. 0213 - FMSP Estimate to InvoiceTransfer Button - Customize it!	11m 32s
10. 0214 - FMSP Calculating Margin andMarkup in Invoices	9m 24s
11. 0216 - FMSP Unlimited RelatedDigital Document Upgrade	8m 40s
12. 0219 - Calendar Under the Hood Part1	9m 38s
13. 0220 - Calendar Under the Hood Part2	12m 46s
14. 0221 - Tab Controls with Calculations	4m 19s
15. 0230 - Dashboard Charts Part #1	11m 22s
16. 0231 - Dashboard Charts Part #2 -Scripting	25m 18s
17. 0232 - Dashboard Charts Part #3 -Performance	5m 2s
18. 0235 - Managing Primary Keys	6m 54s
19. 0240 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values	10m 36s

1. 0201 - FMSP Walkthrough - Intro

6m 23s

2. 0202 - FMSP Device Support & LayoutOrganization

5m 22s

3. 0203 - Script Numbering andOrganization

4m 10s

4. 0205 - Whats new in FMSP 5?

6m 30s

5. 0207 - FMSP Account & ContactsWalkthrough

17m 24s

6. 0208 - FMSP Invoice Walkthrough

9m 12s

7. 0211 - FMSP Sales Followups

14m 37s

8. 0212 - FMSP Invoice - New Line Items- Advanced

14m 25s

9. 0213 - FMSP Estimate to InvoiceTransfer Button - Customize it!

11m 32s

10. 0214 - FMSP Calculating Margin andMarkup in Invoices

9m 24s

11. 0216 - FMSP Unlimited RelatedDigital Document Upgrade

8m 40s

12. 0219 - Calendar Under the Hood Part1

9m 38s

13. 0220 - Calendar Under the Hood Part2

12m 46s

14. 0221 - Tab Controls with Calculations

4m 19s

15. 0230 - Dashboard Charts Part #1

11m 22s

16. 0231 - Dashboard Charts Part #2 -Scripting

25m 18s

17. 0232 - Dashboard Charts Part #3 -Performance

5m 2s

18. 0235 - Managing Primary Keys

6m 54s

19. 0240 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values

10m 36s

0300 - Fundamentals & Basics

Lectures	Duration
1. 0301 - What is a Database - Part 1	5m 49s
2. 0302 - What is a Database - Part 2	4m 31s
3. 0303 - Modes in FileMaker	5m 40s
4. 0304 - Browse Mode, and the Deletemenu item	6m 29s
5. 0305 - Saving Data	2m 2s
6. 0306 - Converting from .fp7 to.fmp12 file formats	10m 49s
7. 0307 - Converting from .fp5 to .fp7file formats	9m 30s
8. 0308 - How to make a Copy of a FMDatabase	5m 10s
9. 0309 - What is a Relationship?	18m 27s

1. 0301 - What is a Database - Part 1

5m 49s

2. 0302 - What is a Database - Part 2

4m 31s

3. 0303 - Modes in FileMaker

5m 40s

4. 0304 - Browse Mode, and the Deletemenu item

6m 29s

5. 0305 - Saving Data

2m 2s

6. 0306 - Converting from .fp7 to.fmp12 file formats

10m 49s

7. 0307 - Converting from .fp5 to .fp7file formats

9m 30s

8. 0308 - How to make a Copy of a FMDatabase

5m 10s

9. 0309 - What is a Relationship?

18m 27s

Performing Finds & Sorts

Lectures	Duration
1. 0401 - Finding Records - Basics	5m 43s
2. 0402 - Finding - Multiple Requests	10m 49s
3. 0403 - Finding Ranges of Dates	4m 14s
4. 0404 - Finds with Special Operators	8m 37s
5. 0405 - Finds and Indexing andPerformance, Stored Calcs	6m 15s
6. 0406 - Finds Constrain and Extend	4m 37s
7. 0407 - Sorting Records	7m 38s
8. 0408 - Custom Sort Orders	7m 42s

1. 0401 - Finding Records - Basics

5m 43s

2. 0402 - Finding - Multiple Requests

10m 49s

3. 0403 - Finding Ranges of Dates

4m 14s

4. 0404 - Finds with Special Operators

8m 37s

5. 0405 - Finds and Indexing andPerformance, Stored Calcs

6m 15s

6. 0406 - Finds Constrain and Extend

4m 37s

7. 0407 - Sorting Records

7m 38s

8. 0408 - Custom Sort Orders

7m 42s

0500 - Working on Fields & Layouts

Lectures	Duration
1. 0501 - Layouts - Available tools	13m 15s
2. 0502 - Tour of the Inspector	21m 29s
3. 0503 - Intro to Adding Fields toDatabase (Text and Number)	12m 11s
4. 0504 - Added Calc fields and HidingObjects	11m 40s
5. 0505 - Creating a Survey & TabPanels & Value Lists	14m 28s
6. 0506 - Value Lists - Under the hood	9m 11s
7. 0507 - Hiding Objects & ConditionalFormatting	13m 26s
8. 0508 - Text Fields with User SpecifiedFormatting	11m 20s
9. 0509 - Merge Fields	4m 36s
10. 0510 - Stored Vs UnstoredCalculations	11m 22s
11. 0511 - 3 Types of Buttons and OneGlyph - Icon	9m 36s
12. 0512 - Button Bar as New Data InputControl Style	3m 5s
13. 0513 - Inline Field Labels	3m 29s
14. 0514 - Layout Object Windows (LOW)(aka Layout Object Tree)	9m 25s
15. 0515 - Tabs vs	5m 51s
16. 0516 - Popovers and New WindowCommand	9m 43s
17. 0517 - Auto-Enter Options for Fields	8m
18. 0521 - Introduction to Single-User vs.Multi-User databases	9m 25s
19. 0522 - Global Fields	10m 44s
20. 0523 - Tooltips	7m 8s
21. 0524 - Object Flags, or Badges	7m 33s
22. 0525 - Object Alignment tools	11m 44s
23. 0526 - Creating a new iOS Layoutfrom Scratch - Stencils	7m 1s
24. 0527 - Field Validation Options	13m 3s
25. 0528 - Repeating Fields	8m 34s
26. 0530 - Layout Badge Tooltips	2m 46s
27. 0539 - Custom Currency in FMSP	4m 6s
28. 0540 - Formatting Currency - When itgoes into a Text Field	10m 2s
29. 0545 - Hamburger Menus & InlineText Labels	6m 7s

1. 0501 - Layouts - Available tools

13m 15s

2. 0502 - Tour of the Inspector

21m 29s

3. 0503 - Intro to Adding Fields toDatabase (Text and Number)

12m 11s

4. 0504 - Added Calc fields and HidingObjects

11m 40s

5. 0505 - Creating a Survey & TabPanels & Value Lists

14m 28s

6. 0506 - Value Lists - Under the hood

9m 11s

7. 0507 - Hiding Objects & ConditionalFormatting

13m 26s

8. 0508 - Text Fields with User SpecifiedFormatting

11m 20s

9. 0509 - Merge Fields

4m 36s

10. 0510 - Stored Vs UnstoredCalculations

11m 22s

11. 0511 - 3 Types of Buttons and OneGlyph - Icon

9m 36s

12. 0512 - Button Bar as New Data InputControl Style

3m 5s

13. 0513 - Inline Field Labels

3m 29s

14. 0514 - Layout Object Windows (LOW)(aka Layout Object Tree)

9m 25s

15. 0515 - Tabs vs

5m 51s

16. 0516 - Popovers and New WindowCommand

9m 43s

17. 0517 - Auto-Enter Options for Fields

18. 0521 - Introduction to Single-User vs.Multi-User databases

9m 25s

19. 0522 - Global Fields

10m 44s

20. 0523 - Tooltips

7m 8s

21. 0524 - Object Flags, or Badges

7m 33s

22. 0525 - Object Alignment tools

11m 44s

23. 0526 - Creating a new iOS Layoutfrom Scratch - Stencils

7m 1s

24. 0527 - Field Validation Options

13m 3s

25. 0528 - Repeating Fields

8m 34s

26. 0530 - Layout Badge Tooltips

2m 46s

27. 0539 - Custom Currency in FMSP

4m 6s

28. 0540 - Formatting Currency - When itgoes into a Text Field

10m 2s

29. 0545 - Hamburger Menus & InlineText Labels

6m 7s

0550 - Containers Field & DocumentManagement

Lectures	Duration
1. 0551 - Container Field Introduction	11m 40s
2. 0553 - Advanced Container FieldKung-Fu	11m 1s
3. 0556 - Interactive Containers inFileMaker	15m 35s
4. 0560 - Containers in FMSP	6m 33s
5. 0562 - HiJacking Containers in FMStarting Point	17m 2s
6. 0580 - When Container Storage goesBad..	8m 38s

1. 0551 - Container Field Introduction

11m 40s

2. 0553 - Advanced Container FieldKung-Fu

11m 1s

3. 0556 - Interactive Containers inFileMaker

15m 35s

4. 0560 - Containers in FMSP

6m 33s

5. 0562 - HiJacking Containers in FMStarting Point

17m 2s

6. 0580 - When Container Storage goesBad..

8m 38s

0600 - Advanced Layout Techniques

Lectures	Duration
1. 0601 - Making Layouts load 200%faster in FM 16 - Performance	7m 16s
2. 0602 - 200% faster Part 2 -Performance	8m 12s
3. 0603 - 200% faster Part 3 -Performance	2m 53s
4. 0604 - Grouping with Slide Panels toHide Objects	5m 45s
5. 0605 - Get Object Attribute forHidden Objects	2m 52s
6. 0608 - Script Triggers - Intro	4m 17s
7. 0609 - Script Triggers - LayoutSpecific	10m 3s
8. 0610 - Script Triggers - Object Specific	7m 51s
9. 0611 - Script Triggers - FieldValidations	10m 12s
10. 0612 - Script Triggers - More Layoutscontrols	6m 5s
11. 0614 - What is a Virtual List? *Advanced *	14m 12s
12. 0615 - Hierarchical Portal forNavigation * Advanced *	16m 49s
13. 0620 - Go to Related Record - GTRR	19m 10s
14. 0622 - FileMaker 14 SVG Icon HelperTool	18m 20s

1. 0601 - Making Layouts load 200%faster in FM 16 - Performance

7m 16s

2. 0602 - 200% faster Part 2 -Performance

8m 12s

3. 0603 - 200% faster Part 3 -Performance

2m 53s

4. 0604 - Grouping with Slide Panels toHide Objects

5m 45s

5. 0605 - Get Object Attribute forHidden Objects

2m 52s

6. 0608 - Script Triggers - Intro

4m 17s

7. 0609 - Script Triggers - LayoutSpecific

10m 3s

8. 0610 - Script Triggers - Object Specific

7m 51s

9. 0611 - Script Triggers - FieldValidations

10m 12s

10. 0612 - Script Triggers - More Layoutscontrols

6m 5s

11. 0614 - What is a Virtual List? ***Advanced ***

14m 12s

12. 0615 - Hierarchical Portal forNavigation *** Advanced ***

16m 49s

13. 0620 - Go to Related Record - GTRR

19m 10s

14. 0622 - FileMaker 14 SVG Icon HelperTool

18m 20s

0700 - Emailing, Imports and Exports

Lectures	Duration
1. 0701 - Sharing Data Intro	1m 17s
2. 0702 - Importing Data	14m 34s
3. 0703 - Exporting Data	7m 59s
4. 0704 - Scripting Import & Exports -Basics	4m 31s
5. 0706 - Send Email Script Step	3m 53s
6. 0707 - Finding Your SMTP Settings	8m 40s
7. 0708 - Automating outbound emails	6m 51s
8. 0709 - Spamming with FileMaker	8m 7s
9. 0710 - Automating Emailing ofExports, Like a PDF	2m
10. 0711 - Scripting FileMaker to Deletea File	11m 36s
11. 0712 - Multi-Table Imports...Complex Imports	21m 20s
12. 0713 - Upgrading Copies of FMSP,migrating / updating to a new release	9m 16s
13. 0714 - Updating data in a FileMakertable from an Excel File	13m 27s
14. 0720 - Using 360Works Email Pluginto Send HTML Emails	6m
15. 0725 - 360Works' CloudMail Install	16m 15s

1. 0701 - Sharing Data Intro

1m 17s

2. 0702 - Importing Data

14m 34s

3. 0703 - Exporting Data

7m 59s

4. 0704 - Scripting Import & Exports -Basics

4m 31s

5. 0706 - Send Email Script Step

3m 53s

6. 0707 - Finding Your SMTP Settings

8m 40s

7. 0708 - Automating outbound emails

6m 51s

8. 0709 - Spamming with FileMaker

8m 7s

9. 0710 - Automating Emailing ofExports, Like a PDF

10. 0711 - Scripting FileMaker to Deletea File

11m 36s

11. 0712 - Multi-Table Imports...Complex Imports

21m 20s

12. 0713 - Upgrading Copies of FMSP,migrating / updating to a new release

9m 16s

13. 0714 - Updating data in a FileMakertable from an Excel File

13m 27s

14. 0720 - Using 360Works Email Pluginto Send HTML Emails

15. 0725 - 360Works' CloudMail Install

16m 15s

0800 - Integration

Lectures	Duration
1. 0803 - Barcode DeploymentPlanning & Options	12m 20s
2. 0804 - Installing the BarcodeCreator into FMSP	7m 21s
3. 0805 - Scanning Items into Invoiceswith Barcodes	2m 25s
4. 0806 - Under-the-hood withScanner Barcodes In FMSP Part 1	7m 20s
5. 0807 - Under-the-hood withScanner Barcodes In FMSP Part 2	8m 40s
6. 0808 - Under-the-hood withScanner Barcodes In FMSP Part 3	12m 52s
7. 0809 - USB Barcodes Gun We'reUsing	6m 40s
8. 0810 - Setup Up Printer Labels &Users Scanning the Wrong Barcode	6m 23s
9. 0811 - Viewer Questions & troubleshooting Barcodes	7m 6s
10. 0812 - Infinite Peripherals BarcodeHardware for iPhone & iPad	11m 29s
11. 0814 - Getting FileMaker Server toGenerate PDFs - PSOC	9m 1s
12. 0815 - What is a FileMaker Robot?	8m 40s
13. 0820 - Intro to Sending HTML emailsand SMS messages	7m 15s
14. 0830 - Building a Progress Bar inFileMaker	12m 19s
15. 0831 - Validating Emails with aService	8m 27s
16. 0832 - Getting Driving DistanceFrom Google	8m 45s
17. 0835 - Dialing VOIP Phone with SIP& X-Lite	10m 13s
18. 0840 - Sending SMS with Twilio	10m 38s
19. 0845 - Syncing to iPad or Syncing 2databases - MirrorSync 2	45m 21s
20. 0846 - Clustering and Replication -MirrorSync 3	19m 48s
21. 0847 - 360Works MirrorSync 4	5m 24s

1. 0803 - Barcode DeploymentPlanning & Options

12m 20s

2. 0804 - Installing the BarcodeCreator into FMSP

7m 21s

3. 0805 - Scanning Items into Invoiceswith Barcodes

2m 25s

4. 0806 - Under-the-hood withScanner Barcodes In FMSP Part 1

7m 20s

5. 0807 - Under-the-hood withScanner Barcodes In FMSP Part 2

8m 40s

6. 0808 - Under-the-hood withScanner Barcodes In FMSP Part 3

12m 52s

7. 0809 - USB Barcodes Gun We'reUsing

6m 40s

8. 0810 - Setup Up Printer Labels &Users Scanning the Wrong Barcode

6m 23s

9. 0811 - Viewer Questions & troubleshooting Barcodes

7m 6s

10. 0812 - Infinite Peripherals BarcodeHardware for iPhone & iPad

11m 29s

11. 0814 - Getting FileMaker Server toGenerate PDFs - PSOC

9m 1s

12. 0815 - What is a FileMaker Robot?

8m 40s

13. 0820 - Intro to Sending HTML emailsand SMS messages

7m 15s

14. 0830 - Building a Progress Bar inFileMaker

12m 19s

15. 0831 - Validating Emails with aService

8m 27s

16. 0832 - Getting Driving DistanceFrom Google

8m 45s

17. 0835 - Dialing VOIP Phone with SIP& X-Lite

10m 13s

18. 0840 - Sending SMS with Twilio

10m 38s

19. 0845 - Syncing to iPad or Syncing 2databases - MirrorSync 2

45m 21s

20. 0846 - Clustering and Replication -MirrorSync 3

19m 48s

21. 0847 - 360Works MirrorSync 4

5m 24s

0900 - Writing Scripts

Lectures	Duration
1. 0901 - Scripting	9m 58s
2. 0902 - Intro to Script Workspace	11m 47s
3. 0903 - Workspace KeyboardShortcuts	10m 56s
4. 0904 - Set fields vs	16m 35s
5. 0905 - Set fields & Context	2m 29s
6. 0906 - Buttons run one Command	15m 2s
7. 0907 - Navigation	3m 27s
8. 0908 - IF...THEN...decisions	6m 30s
9. 0909 - Variables vs	6m 5s
10. 0910 - Performing Finds	9m 3s
11. 0911 - Basic Error Capture	10m 26s
12. 0912 - Calling Subscripts - ScriptParameters	8m 57s
13. 0913 - Advanced Script Parameters& Script Results	5m 2s
14. 0914 - Looping Scripts	3m 15s
15. 0917 - Preserving User Contextwhen running a Script	7m 23s
16. 0918 - New Window - Script Step	14m 6s
17. 0920 - Script Debugger - Part 1	20m 54s
18. 0921 - Script Debugger - Part 2	3m 11s
19. 0924 - Data Viewer	13m 32s
20. 0932 - UI Indicators for DatabaseActivity	10m 46s
21. 0940- Database PerformanceOptimization Overview	5m 42s
22. 0941- Making Scalable Databases	11m 26s
23. 0942- Server Evidence - SlowPerformance - Slow Scripts	3m 28s
24. 0943 - Perform Script on Server -PSOS	20m 10s
25. 0945 - PSOS in FMSP	7m 11s
26. 0946 - Testing for PSOS Availability	12m 27s
27. 0947 - SASE	10m 31s
28. 0948 - Case Statement	2m 9s
29. 0950 - Deduplicating Records, thePlan	7m 56s
30. 0951 - Replace Command - A TigerLoose at the Zoo	8m 3s
31. 0953 - Landmines in FileMaker	9m 50s
32. 0955 - Testing to Make Sure YourScript has Access to a Record	7m 40s
33. 0957 - Testing to See if a Field orvariable contains ONLY a number / Tri…	5m 17s
34. 0965 - One Use Loop Technique	5m 57s
35. 0968 - Go To Object	12m 18s

1. 0901 - Scripting

9m 58s

2. 0902 - Intro to Script Workspace

11m 47s

3. 0903 - Workspace KeyboardShortcuts

10m 56s

4. 0904 - Set fields vs

16m 35s

5. 0905 - Set fields & Context

2m 29s

6. 0906 - Buttons run one Command

15m 2s

7. 0907 - Navigation

3m 27s

8. 0908 - IF...THEN...decisions

6m 30s

9. 0909 - Variables vs

6m 5s

10. 0910 - Performing Finds

9m 3s

11. 0911 - Basic Error Capture

10m 26s

12. 0912 - Calling Subscripts - ScriptParameters

8m 57s

13. 0913 - Advanced Script Parameters& Script Results

5m 2s

14. 0914 - Looping Scripts

3m 15s

15. 0917 - Preserving User Contextwhen running a Script

7m 23s

16. 0918 - New Window - Script Step

14m 6s

17. 0920 - Script Debugger - Part 1

20m 54s

18. 0921 - Script Debugger - Part 2

3m 11s

19. 0924 - Data Viewer

13m 32s

20. 0932 - UI Indicators for DatabaseActivity

10m 46s

21. 0940- Database PerformanceOptimization Overview

5m 42s

22. 0941- Making Scalable Databases

11m 26s

23. 0942- Server Evidence - SlowPerformance - Slow Scripts

3m 28s

24. 0943 - Perform Script on Server -PSOS

20m 10s

25. 0945 - PSOS in FMSP

7m 11s

26. 0946 - Testing for PSOS Availability

12m 27s

27. 0947 - SASE

10m 31s

28. 0948 - Case Statement

2m 9s

29. 0950 - Deduplicating Records, thePlan

7m 56s

30. 0951 - Replace Command - A TigerLoose at the Zoo

8m 3s

31. 0953 - Landmines in FileMaker

9m 50s

32. 0955 - Testing to Make Sure YourScript has Access to a Record

7m 40s

33. 0957 - Testing to See if a Field orvariable contains ONLY a number / Tri…

5m 17s

34. 0965 - One Use Loop Technique

5m 57s

35. 0968 - Go To Object

12m 18s

1000 - Calculations

Lectures	Duration
1. 1001 - Calculation Engine & NewWork Space	13m 21s
2. 1002 - Calculation Engine & NewWork Space Part 2	4m 48s
3. 1010 - Parsing Text with Calcs - Part1	12m 7s
4. 1011 - Parsing Text with Calcs - Part2	11m 33s
5. 1012 - Detecting Window Mode andFilter Function	11m 14s
6. 1013 - Date Calcs	5m 11s
7. 1014 - Detecting Device & PlatformTypes	3m 27s
8. 1020 - Get Functions Walkthrough -Part 1	8m 51s
9. 1021 - Get Functions Walkthrough -Part 2	7m 16s
10. 1022 - Get Functions Walkthrough -Part 3	3m 39s
11. 1023 - Get Functions Walkthrough -Part 4	5m 7s
12. 1024 - GetLayoutAttribute	5m 26s
13. 1025 - GetContainerAttribute	5m 15s
14. 1026 - Get(UUID) andGet(PersistentID)	8m 11s
15. 1040 - List Function, Summary List,and GetValue	7m 58s
16. 1042 - SortValues and UniqueValues	1m 40s
17. 1045 - Get (ScriptName) - Understand Timing Issues...	16m 37s

1. 1001 - Calculation Engine & NewWork Space

13m 21s

2. 1002 - Calculation Engine & NewWork Space Part 2

4m 48s

3. 1010 - Parsing Text with Calcs - Part1

12m 7s

4. 1011 - Parsing Text with Calcs - Part2

11m 33s

5. 1012 - Detecting Window Mode andFilter Function

11m 14s

6. 1013 - Date Calcs

5m 11s

7. 1014 - Detecting Device & PlatformTypes

3m 27s

8. 1020 - Get Functions Walkthrough -Part 1

8m 51s

9. 1021 - Get Functions Walkthrough -Part 2

7m 16s

10. 1022 - Get Functions Walkthrough -Part 3

3m 39s

11. 1023 - Get Functions Walkthrough -Part 4

5m 7s

12. 1024 - GetLayoutAttribute

5m 26s

13. 1025 - GetContainerAttribute

5m 15s

14. 1026 - Get(UUID) andGet(PersistentID)

8m 11s

15. 1040 - List Function, Summary List,and GetValue

7m 58s

16. 1042 - SortValues and UniqueValues

1m 40s

17. 1045 - Get (ScriptName) - Understand Timing Issues...

16m 37s

1100 - Relationships

Lectures	Duration
1. 1101 - What is a Relationship?	9m 27s
2. 1102 - Table Occurrences Basics	11m 52s
3. 1103 - Relationship Graph & ERDs	12m 23s
4. 1104 - What is a Portal..	6m 42s
5. 1105 - Multi-Predicate Relationships	8m 46s
6. 1106 - Multi-Key Relationships	11m 1s
7. 1107 - Cascading Adds	7m 24s
8. 1108 - Cascading Deletes	6m 12s
9. 1111 - Portal Dialog Options	16m 44s
10. 1112 - Portal Summary Sum Totals	7m 14s
11. 1114 - Filtering Portals - RadioButtons	7m 30s
12. 1120 - Lookup Values	13m 12s
13. 1121 - Relookup Command -Updating One Time Relationships	8m 6s
14. 1130 - Anchor Buoy DesignMethodology Part 1	9m 23s
15. 1131 - Anchor Buoy DesignMethodology Part 2	7m 31s
16. 1132 - Many to Many Relationships	14m 37s
17. 1135 - Preference Table in yourSolution	7m 8s
18. 1140 - Calculating and Primary Keywith the current Year	10m 14s
19. 1150 - Multiple Page Invoices -Portal Management - Part 1	10m 26s
20. 1151 - Multiple Page Invoices -Portal Management - Part 2	28m 25s

1. 1101 - What is a Relationship?

9m 27s

2. 1102 - Table Occurrences Basics

11m 52s

3. 1103 - Relationship Graph & ERDs

12m 23s

4. 1104 - What is a Portal..

6m 42s

5. 1105 - Multi-Predicate Relationships

8m 46s

6. 1106 - Multi-Key Relationships

11m 1s

7. 1107 - Cascading Adds

7m 24s

8. 1108 - Cascading Deletes

6m 12s

9. 1111 - Portal Dialog Options

16m 44s

10. 1112 - Portal Summary Sum Totals

7m 14s

11. 1114 - Filtering Portals - RadioButtons

7m 30s

12. 1120 - Lookup Values

13m 12s

13. 1121 - Relookup Command -Updating One Time Relationships

8m 6s

14. 1130 - Anchor Buoy DesignMethodology Part 1

9m 23s

15. 1131 - Anchor Buoy DesignMethodology Part 2

7m 31s

16. 1132 - Many to Many Relationships

14m 37s

17. 1135 - Preference Table in yourSolution

7m 8s

18. 1140 - Calculating and Primary Keywith the current Year

10m 14s

19. 1150 - Multiple Page Invoices -Portal Management - Part 1

10m 26s

20. 1151 - Multiple Page Invoices -Portal Management - Part 2

28m 25s

1200 - Security

Lectures	Duration
1. 1201 - Security in FileMakerOverview	5m 21s
2. 1202 - Accounts and Privileges	12m 11s
3. 1203 - Extended Privileges...theBasics	10m 26s
4. 1204 - Extended Privileges...RecentChanges	9m 8s
5. 1205 - Encryption at Rest (EAR)	9m 12s
6. 1206 - Point-to-Point Encryption -SSL Certificates	52m 27s
7. 1207 - Audit Trails - Part 1 -Overview	12m 25s
8. 1208 - Audit Trails - Part 2 -Technical	11m 46s
9. 1209 - Audit Trails - Audits in FMSPPart 1	9m 14s
10. 1210 - Audit Trails - Audits in FMSPPart 2	17m 44s
11. 1211 - Audit Trails - Logging Recordsviewed - HIPAA	19m 22s
12. 1213 - Security through Obscurity	7m 55s
13. 1214 - Record Level Security	13m 29s
14. 1215 - Layout and Process AccessControls - Restricting Staff	15m 9s
15. 1216 - Hacking a FileMaker File...and Protecting It	7m 56s
16. 1220 - CryptAuthCode SecurityFunctions	7m 39s

1. 1201 - Security in FileMakerOverview

5m 21s

2. 1202 - Accounts and Privileges

12m 11s

3. 1203 - Extended Privileges...theBasics

10m 26s

4. 1204 - Extended Privileges...RecentChanges

9m 8s

5. 1205 - Encryption at Rest (EAR)

9m 12s

6. 1206 - Point-to-Point Encryption -SSL Certificates

52m 27s

7. 1207 - Audit Trails - Part 1 -Overview

12m 25s

8. 1208 - Audit Trails - Part 2 -Technical

11m 46s

9. 1209 - Audit Trails - Audits in FMSPPart 1

9m 14s

10. 1210 - Audit Trails - Audits in FMSPPart 2

17m 44s

11. 1211 - Audit Trails - Logging Recordsviewed - HIPAA

19m 22s

12. 1213 - Security through Obscurity

7m 55s

13. 1214 - Record Level Security

13m 29s

14. 1215 - Layout and Process AccessControls - Restricting Staff

15m 9s

15. 1216 - Hacking a FileMaker File...and Protecting It

7m 56s

16. 1220 - CryptAuthCode SecurityFunctions

7m 39s

1300 - FileMaker Server

Lectures	Duration
1. 1301 - Deployment & Sharing	19m 10s
2. 1302 - FMS Admin Walkthrough	18m 23s
3. 1303 - Scheduling Backups	14m 45s
4. 1304 - Progressive Backups	4m 48s
5. 1305 - Restoring from a Crash	18m 58s
6. 1306 - Server PerformanceImprovements 14 - Nick Lightbody	44m 7s
7. 1307 - Server PerformanceImprovements 15 - Nick Lightbody	31m 27s

1. 1301 - Deployment & Sharing

19m 10s

2. 1302 - FMS Admin Walkthrough

18m 23s

3. 1303 - Scheduling Backups

14m 45s

4. 1304 - Progressive Backups

4m 48s

5. 1305 - Restoring from a Crash

18m 58s

6. 1306 - Server PerformanceImprovements 14 - Nick Lightbody

44m 7s

7. 1307 - Server PerformanceImprovements 15 - Nick Lightbody

31m 27s

1400 - Printing & Report Creation

Lectures	Duration
1. 1401 - Printing and PDF Generation	13m 14s
2. 1402 - Structuring your data so it isreportable	4m 29s
3. 1403 - List View for Ad-HocReporting	4m 9s
4. 1404 - Layout Parts on List View -for Beginners	9m 34s
5. 1405 - FileMaker Report Wizard -Very Cool	10m 20s
6. 1406 - Printing & Reporting onGovernment Forms	7m 4s
7. 1407 - Subsummaries in Detail	11m 17s
8. 1420 - State of Charting in FileMaker	13m
9. 1421 - Built-in Charting Overview	19m 34s
10. 1422 - Google Charts	12m 12s
11. 1425 - MultiPage Append to PDF	7m 19s

1. 1401 - Printing and PDF Generation

13m 14s

2. 1402 - Structuring your data so it isreportable

4m 29s

3. 1403 - List View for Ad-HocReporting

4m 9s

4. 1404 - Layout Parts on List View -for Beginners

9m 34s

5. 1405 - FileMaker Report Wizard -Very Cool

10m 20s

6. 1406 - Printing & Reporting onGovernment Forms

7m 4s

7. 1407 - Subsummaries in Detail

11m 17s

8. 1420 - State of Charting in FileMaker

13m

9. 1421 - Built-in Charting Overview

19m 34s

10. 1422 - Google Charts

12m 12s

11. 1425 - MultiPage Append to PDF

7m 19s

1500 - Custom Functions

Lectures	Duration
1. 1501 - Top 10 FileMaker CustomFunctions (For Senior Developers)	17m 46s
2. 1502 - Richard Carlton's Top 5FileMaker Custom Functions	13m 44s
3. 1503 - Parsing XML - CustomFunction	16m 40s

1. 1501 - Top 10 FileMaker CustomFunctions (For Senior Developers)

17m 46s

2. 1502 - Richard Carlton's Top 5FileMaker Custom Functions

13m 44s

3. 1503 - Parsing XML - CustomFunction

16m 40s

1600 - WebDirect

Lectures	Duration
1. 1602 - Creating PDF's and Emailingfrom WebDirect	16m 34s

1. 1602 - Creating PDF's and Emailingfrom WebDirect

16m 34s

1700 - MISC

Lectures	Duration
1. 1701 - Performance Improvementsin 14 - Advanced	8m 1s
2. 1702 - Database PerformanceTuning with Nick Lightbody	51m 12s
3. 1704 - 3 Areas of PerformanceImprovement in Pro 15	10m 25s
4. 1706 - 3 Area of PerformanceImprovement in Pro 14	9m 29s
5. 1708 - How to make an AssetDatabase in 5 Minutes	7m 59s
6. 1717 - PHP #1 - Overview	11m 52s
7. 1718 - PHP #2 - Technical ProcessWalkthrough	10m 34s
8. 1719 - PHP #3 - Sample CodeReview	16m 55s
9. 1720 - Duplicate Module in FMSPPart 1	7m 9s
10. 1721 - Duplicate Module in FMSPPart 2	14m 42s
11. 1722 - Duplicate Module in FMSPPart 3	14m 50s
12. 1723 - Duplicate Module in FMSPPart 4	12m 7s

1. 1701 - Performance Improvementsin 14 - Advanced

8m 1s

2. 1702 - Database PerformanceTuning with Nick Lightbody

51m 12s

3. 1704 - 3 Areas of PerformanceImprovement in Pro 15

10m 25s

4. 1706 - 3 Area of PerformanceImprovement in Pro 14

9m 29s

5. 1708 - How to make an AssetDatabase in 5 Minutes

7m 59s

6. 1717 - PHP #1 - Overview

11m 52s

7. 1718 - PHP #2 - Technical ProcessWalkthrough

10m 34s

8. 1719 - PHP #3 - Sample CodeReview

16m 55s

9. 1720 - Duplicate Module in FMSPPart 1

7m 9s

10. 1721 - Duplicate Module in FMSPPart 2

14m 42s

11. 1722 - Duplicate Module in FMSPPart 3

14m 50s

12. 1723 - Duplicate Module in FMSPPart 4

12m 7s

1800 - FileMaker Cloud

Lectures	Duration
1. 1802 - Detailed Comparison withRegular FileMaker Server	16m 30s
2. 1803 - Is FileMaker Cloud Right foryou?	8m 15s
3. 1804 - Brain Dump for ExperienceFileMaker Developers	16m 38s
4. 1805 - How to Buy FMC - Directfrom AWS - New Users	18m 30s
5. 1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses	17m 27s
6. 1807 - Uploading files to FileMakerCloud	7m 16s
7. 1809 - Picking the right size ofAmazon Server	9m 43s
8. 1811 - Understanding Amazon'sTotal Cost	14m 32s
9. 1812 - How to Save 50% to 75% onAmazon Instance	7m 43s
10. 1813 - FMI Hourly Costs..	3m 11s
11. 1814 - Restoring from a Backup(New Process)	11m 2s
12. 1815 - Restoring from a Backup	7m 6s
13. 1816 - Robot DB & Notifications	4m 47s
14. 1817 - Automated Maintenance	7m 55s
15. 1818 - EBS & Backups	7m 32s
16. 1820 - Supersize my Server!	7m 47s
17. 1822 - Detecting When a File isrunning on FileMaker Cloud	5m 1s
18. 1824 - Instance Refresh &Emergency Procedures Part 1	10m 51s
19. 1830 - Offboarding FileMaker Cloud	3m 48s
20. 1840 - Intro T2 Burstable Instances,Performance, CPU Credits	9m 59s
21. 1841 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large	3m 17s
22. 1842 - Standard Usage Scenario	16m 15s

1. 1802 - Detailed Comparison withRegular FileMaker Server

16m 30s

2. 1803 - Is FileMaker Cloud Right foryou?

8m 15s

3. 1804 - Brain Dump for ExperienceFileMaker Developers

16m 38s

4. 1805 - How to Buy FMC - Directfrom AWS - New Users

18m 30s

5. 1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses

17m 27s

6. 1807 - Uploading files to FileMakerCloud

7m 16s

7. 1809 - Picking the right size ofAmazon Server

9m 43s

8. 1811 - Understanding Amazon'sTotal Cost

14m 32s

9. 1812 - How to Save 50% to 75% onAmazon Instance

7m 43s

10. 1813 - FMI Hourly Costs..

3m 11s

11. 1814 - Restoring from a Backup(New Process)

11m 2s

12. 1815 - Restoring from a Backup

7m 6s

13. 1816 - Robot DB & Notifications

4m 47s

14. 1817 - Automated Maintenance

7m 55s

15. 1818 - EBS & Backups

7m 32s

16. 1820 - Supersize my Server!

7m 47s

17. 1822 - Detecting When a File isrunning on FileMaker Cloud

5m 1s

18. 1824 - Instance Refresh &Emergency Procedures Part 1

10m 51s

19. 1830 - Offboarding FileMaker Cloud

3m 48s

20. 1840 - Intro T2 Burstable Instances,Performance, CPU Credits

9m 59s

21. 1841 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large

3m 17s

22. 1842 - Standard Usage Scenario

16m 15s

1900 - FileMaker's Certification Test

Lectures	Duration
1. 1902 - Who takes the FileMakerCertification test?	5m 19s
2. 1904 - What is FMI's Official StudyList Part #1	12m 34s
3. 1905 - What is FMI's Official StudyList Part #2	15m 53s
4. 1906 - Final Test Taking Tips...	10m 43s

1. 1902 - Who takes the FileMakerCertification test?

5m 19s

2. 1904 - What is FMI's Official StudyList Part #1

12m 34s

3. 1905 - What is FMI's Official StudyList Part #2

15m 53s

4. 1906 - Final Test Taking Tips...

10m 43s

FileMaker 16

What’s included

Pay once, own it forever

0100 - Introductions - Overview

FM Starting Point Walkthrough

0300 - Fundamentals &amp; Basics

Performing Finds &amp; Sorts

0500 - Working on Fields &amp; Layouts

0550 - Containers Field &amp; DocumentManagement

0600 - Advanced Layout Techniques

0700 - Emailing, Imports and Exports

0800 - Integration

0900 - Writing Scripts

1000 - Calculations

1100 - Relationships

1200 - Security

1300 - FileMaker Server

1400 - Printing &amp; Report Creation

1500 - Custom Functions

1600 - WebDirect

1700 - MISC

1800 - FileMaker Cloud

1900 - FileMaker's Certification Test

0300 - Fundamentals & Basics

Performing Finds & Sorts

0500 - Working on Fields & Layouts

0550 - Containers Field & DocumentManagement

1400 - Printing & Report Creation