FileMaker 17

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.

$14.99 / $24.99

Introduction

1. The FileMaker Platform -Summary
8m 10s
2. What kind of Solutions can bemade with FMSP?
6m 5s
3. New Features Brain Dump forNew and Intermediate Users
13m 19s
4. Upgrading 12, 13, 14, 15, or 16Solutions to FM17
9m 42s
5. FM Pro Vs
3m

0200 - FM Starting Point Walkthrough

1. 0205 - What's new in FMSP 6?
4m 30s
2. 0206 - What's new in FMSP 5?
6m 52s
3. 0208 - FMSP Device Support & LayoutOrganization
4m 54s
4. 0210 - Script Numbering andOrganization
3m 39s
5. 0212 - FMSP Walkthrough - Intro
9m 11s
6. 0214 - FMSP Complexity Theory
6m 23s
7. 0218 - FMSP Account & ContactsWalkthrough
17m 24s
8. 0219 - FMSP Invoice Walkthrough
13m 57s
9. 0232 - FMSP Invoice - New Line Items- Advanced
14m 29s
10. 0233 - FMSP Estimate to InvoiceTransfer Button
11m 25s
11. 0234 - FMSP Calculating Margin andMarkup in Invoices
9m 24s
12. 0236 - FMSP Unlimited RelatedDigital Document Upgrade
8m 40s
13. 0241 - Tab Controls with Calculations
4m 22s
14. 0245 - Super New Action Calendar
3m 21s
15. 0250 - Dashboard Charts Part #1
11m 24s
16. 0251 - Dashboard Charts Part #2 -Scripting
25m 20s
17. 0252 - Dashboard Charts Part #3 -Performance
4m 58s
18. 0255 - Managing Primary Keys - AutoScript in FMSP
6m 53s
19. 0260 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values
10m 12s
20. 0265 - Startup Bug in FMSP - FM 16Warning..
2m 23s

0270 - Old FM Starting Point Videos

1. 0272 - Calendar Under the Hood Part1 - Old
9m 38s
2. 0273 - Calendar Under the Hood Part2 - Old
12m 46s

0300 - Fundamentals & Basics

1. 0301 - Opening Files ..
7m 9s
2. 0304 - What is a Database - Part 1
5m 50s
3. 0305 - What is a Database - Part 2
4m 30s
4. 0307 - Modes in FileMaker
5m 38s
5. 0308 - Browse Mode, and the Deletemenu item
6m 17s
6. 0309 - Saving Data
2m 1s
7. 0310 - Converting from .fp7 to.fmp12 file formats
10m 45s
8. 0312 - Converting from .fp5 to .fp7file formats
11m 23s
9. 0313 - How to make a Copy of a FMDatabase
4m 58s
10. 0315 - What is a Relationship (VeryBasic Video)
18m 24s
11. 0330 - Basics of Sharing a Database
13m 36s

0400 - Performing Finds & Sorts

1. 0401 - Finding Records - Basics
5m 37s
2. 0402 - Finding - Multiple Requests
11m 1s
3. 0403 - Finding Ranges of Dates
5m 23s
4. 0404 - Finds with Special Operators
8m 39s
5. 0405 - Finds and Indexing andPerformance, Stored Calcs
6m 16s
6. 0406 - Finds Constrain and Extend
4m 24s
7. 0407 - Sorting Records
7m 37s
8. 0408 - Custom Sort Orders
7m 42s

0500 - Working on Fields & Layouts

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

0550 - Container Fields & DocumentManagement

1. 0551 - Container Field Introduction
8m 32s
2. 0552 - Thumbnailing - Under theHood
3m 53s
3. 0553 - Interactive Containers
11m 50s
4. 0556 - Fixing Interactive Containers -Which are not Interactive
15m 30s
5. 0560 - Containers in FMSP
6m 38s
6. 0580 - When Container Storage goesBad..
8m 39s

0600 - Advanced Layout Techniques

1. 0601 - Making Layouts load 200%faster in FM 16 - Performance
7m 20s
2. 0602 - 200% faster Part 2 -Performance
10m 26s
3. 0603 - 200% faster Part 3 -Performance
2m 54s
4. 0604 - Grouping with Slide Panels toHide Objects
5m 45s
5. 0605 - Get Object Attribute forHidden Objects
2m 51s
6. 0614 - What is a Virtual List? ***Advanced ***
14m 9s
7. 0615 - Hierarchical Portal forNavigation *** Advanced ***
16m 49s
8. 0622 - FileMaker 14 SVG Icon HelperTool
19m 23s
9. 0630 - Web Viewers
7m 19s

0800 - Calculations

1. 0801 - Calculation Engine & WorkSpace
13m 20s
2. 0802 - Calculation Engine & WorkSpace Part 2
5m 13s
3. 0810 - Parsing Text with Calcs - Part1
12m 7s
4. 0811 - Parsing Text with Calcs - Part2
11m 33s
5. 0812 - Detecting Window Mode andFilter Function
11m 6s
6. 0813 - Date Calcs
5m 11s
7. 0814 - Detecting Device & PlatformTypes
3m 22s
8. 0820 - Get Functions Walkthrough -Part 1
10m 12s
9. 0821 - Get Functions Walkthrough -Part 2
11m 47s
10. 0822 - Get Functions Walkthrough -Part 3
10m 23s
11. 0823 - Get Functions Walkthrough -Part 4
9m 29s
12. 0824 - GetLayoutAttribute
5m 26s
13. 0825 - GetContainerAttribute
5m 15s
14. 0826 - Get(UUID) andGet(PersistentID)
8m 11s
15. 0840 - List Function, Summary List,and GetValue
7m 58s
16. 0842 - SortValues and UniqueValues
1m 37s

0900 - Writing Scripts

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

0980 - Script Triggers

1. 0981 - Script Triggers - Intro
5m 2s
2. 0982 - Script Triggers - LayoutSpecific
9m 21s
3. 0983 - Script Triggers - ObjectSpecific
7m 51s
4. 0984 - Script Triggers - FieldValidations
7m 50s
5. 0985 - Script Triggers - MoreLayouts controls
6m 6s
6. 1001 - Database PerformanceOptimization Overview
5m 26s

1000 - Performance Optimization

1. 1003 - Making Scalable Databases -Part 1
11m 3s
2. 1004 - Making Scalable Databases -Part 2
15m 33s
3. 1007 - Server Evidence - SlowPerformance - Slow Scripts
3m 28s
4. 1010 - Performance Improvementswith the 16 Platform
8m 1s
5. 1015 - FileMaker's 3 Engines withNick Hunter
24m 44s
6. 1025 - Database PerformanceTuning with Nick Lightbody
51m 14s
7. 1030 - Performance Improvementswith the 15 Platform
10m 25s
8. 1040 - Performance Improvementswith the 14 Platform
9m 17s

1100 - Relationships

1. 1101 - What is a Relationship?
6m 11s
2. 1102 - Table Occurrence Basics
11m 52s
3. 1103 - Relationship Graph & ERDs
12m 23s
4. 1104 - What is a Portal..
6m 42s
5. 1105 - Multi-Predicate Relationships
8m 40s
6. 1106 - Multi-Key Relationships
9m 38s
7. 1107 - Cascading Adds
7m 33s
8. 1108 - Cascading Deletes
11m 20s
9. 1110 - Portal Dialog Options
12m 12s
10. 1111 - Portals Dialog - Add-OnTables
8m 2s
11. 1112 - Portal Summary Sum Totals
7m 8s
12. 1114 - Filtering Portals - RadioButtons
7m 19s
13. 1120 - Lookup Values
13m 13s
14. 1121 - Relookup Command -Updating One Time Relationships
8m 7s
15. 1130 - Anchor Buoy DesignMethodology Part 1
9m 24s
16. 1131 - Anchor Buoy DesignMethodology Part 2
7m 24s
17. 1135 - Master Detail Portals - NewFeature
10m 51s
18. 1136 - Master Detail Portals - Buildone in 60 seconds...
4m 34s
19. 1140 - Many to Many Relationships
14m 38s
20. 1141 - Preference Table in yourSolution
7m 7s
21. 1150 - Calculating and Primary Keywith the current Year
10m 14s
22. 1170 - Multiple Page Invoices -Portal Management - Part 1
10m 26s
23. 1171 - Multiple Page Invoices -Portal Management - Part 2
28m 33s

1200 - Security

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

1300 - Printing & Report Creation

1. 1301 - Printing and PDF Generation
13m 18s
2. 1302 - Structuring your data so it isreportable
4m 28s
3. 1303 - Table View for Ad-HocReporting
4m 9s
4. 1304 - Layout Parts on List View -for Beginners
9m 29s
5. 1305 - FileMaker Report Wizard -Very Cool
10m 20s
6. 1306 - Printing & Reporting onGovernment Forms
7m 4s
7. 1307 - Subsummaries in Detail
11m 15s
8. 1320 - State of Charting in FileMaker
13m 1s
9. 1321 - Built-in Charting Overview
19m 33s
10. 1322 - Google Charts
12m 16s
11. 1325 - MultiPage Append to PDF
7m 19s

1400 - Custom Functions

1. 1401 - Top 10 FileMaker CustomFunctions (For Senior Developers)
18m 44s
2. 1402 - Richard Carlton's Top 5FileMaker Custom Functions
13m 46s
3. 1403 - Parsing XML - CustomFunction
16m 28s

1500 - FileMaker Server (on premiseServer)

1. 1501 - Deployment & Sharing -terminology
4m 3s
2. 1502 - Deployment & Sharing - Intro
14m 54s
3. 1503 - FMS Changes..
4m 34s
4. 1504 - FMS Install w/William
13m 28s
5. 1505- Walkthrough of FMS AdminConsole
12m 57s
6. 1507 - Finding the Server Logs
6m 58s
7. 1508 - Scheduling Backups - TheBasics
15m 21s
8. 1509 - Hard Linking
7m 15s
9. 1510 - Progressive Backups
8m 36s
10. 1511 - FMS - Restoring from a Crash
14m 10s
11. 1512 - FMS - Command LineInterface (CLI)
15m 54s
12. 1514 - FMS - SSL Install
14m 52s
13. 1516 - FMS - Admin Data API
10m 25s
14. 1520 - FMS - Offsite Backups
11m 47s
15. 1525 - Disconnecting Idle Users
4m 53s
16. 1530 - SASE
13m 3s
17. 1541 - Server PerformanceImprovements 14 - Nick Lightbody
35m 46s
18. 1542 - Server PerformanceImprovements 15 - Nick Lightbody
31m 24s

1600 - FileMaker Cloud

1. 1602 - Detailed Comparison withRegular FileMaker Server
10m 32s
2. 1603 - Is FileMaker Cloud Right foryou?
11m 5s
3. 1604 - Brain Dump for ExperiencedFileMaker Developers
11m 35s
4. 1607 - Uploading files to FileMakerCloud
7m 16s
5. 1609- Picking the right size ofAmazon Server
8m 38s
6. 1611 - Understanding Amazon'sTotal Cost
14m 22s
7. 1612 - How to Save 50% to 75% onAmazon Instance
7m 21s
8. 1613 - FMI Hourly Costs..
3m 11s
9. 1615 - Restoring from a Backup(New Process)
10m 55s
10. 1616 - Robot DB & Notifications
4m 47s
11. 1617 - Automated Maintenance
7m 54s
12. 1618 - EBS & Backups
7m 35s
13. 1620 - Supersize my Server!
7m 48s
14. 1622 - Detecting When a File isrunning on FileMaker Cloud
5m 1s
15. 1624 - Instance Refresh &Emergency Procedures Part 1
10m 51s
16. 1630 - Offboarding FileMaker Cloud
3m 48s
17. 1640 - Intro T2 Burstable Instances,Performance, CPU Credits
10m 1s
18. 1641 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large
3m 19s
19. 1642 - Standard Usage Scenario
16m 11s

1700 - WebDirect

1. 1704 - Overview WebDirect -Android Client for FileMaker
7m 34s
2. 1710 - Creating PDF's and Emailingfrom WebDirect
16m 43s

1800 - E-mailing, Imports and Exports -Basic Integration

1. 1801 - Introduction to FileMakerIntegration
2m 19s
2. 1802 - Importing Data
14m 36s
3. 1803 - Exporting Data
7m 58s
4. 1804 - Scripting Import & Exports -Basics
4m 31s
5. 1805 - Automating Imports orExports - Robots and Servers
8m 30s
6. 1809 - Finding Your SMTP Settings
3m 47s
7. 1810 - Automating outbound emails
8m 41s
8. 1812 - Spamming with FileMaker
6m 52s
9. 1814 - Automating Emailing ofExports, Like a PDF
8m 3s
10. 1816 - Scripting FileMaker to Deletea File
1m 59s
11. 1817 - Multi-Table Imports...Complex Imports
11m 37s
12. 1830 - Updating data in a FileMakertable from an Excel File
9m 2s

1900 - Intermediate Integration

1. 1901 - Intermediate IntegrationOverview
2m 24s
2. 1903 - Barcode DeploymentPlanning & Options
12m 1s
3. 1904 - Installing the BarcodeCreator into FMSP
5m 53s
4. 1905 - Scanning Items into Invoiceswith Barcodes
2m 26s
5. 1906 - Under-the-hood withScanner Barcodes In FMSP Part 1
7m 17s
6. 1907 - Under-the-hood withScanner Barcodes In FMSP Part 2
8m 40s
7. 1908 - Under-the-hood withScanner Barcodes In FMSP Part 3
12m 41s
8. 1909 - USB Barcodes Gun We'reUsing
4m 5s
9. 1910 - Setup Printer Labels & UsersScanning the Wrong Barcode
6m 24s
10. 1911 - Viewer Questions & troubleshooting Barcodes
7m 4s
11. 1912 - CHOPPING BLOCK!! InfinitePeripherals Barcode Hardware for iPho…
10m 53s
12. 1914 - OUT OF DATE GettingFileMaker Server to Generate PDFs - PS…
9m 25s
13. 1915 - What is a FileMaker Robot?
8m 41s
14. 1921 - Using 360Works Email Pluginto Send HTML Emails
16m 12s
15. 1930 - Building a Progress Bar inFileMaker
12m 41s
16. 1931 - Validating Emails with aService
8m 30s
17. 1932 - Getting Driving DistanceFrom Google
8m 39s
18. 1935 - Dialing VOIP Phone with SIP& X-Lite
10m 10s
19. 1940 - Sending SMS with Twilio
10m 28s
20. 1945 - Syncing to iPad or Syncing 2databases - 2
39m 39s
21. 1946 - Clustering and Replication -MirrorSync 3
20m 3s
22. 1960 - 360Works' CloudMail insideof FMSP...Overview
9m 32s

2000 - Advanced Integration - PHP & Rest

1. 2001 - What is REST and SectionOverview
9m 11s
2. 2002 - What OAuth
5m 34s
3. 2003 - Integration with Paypal ShortOverview
9m 31s
4. 2004 - Integration with Paypal -Workflow Planning
10m
5. 2005 - Integration with Paypal -Setup Website
14m 37s
6. 2006 - Integration with Paypal-Under-the-hood Walk Through
4m 3s
7. 2015 - Newbie Introduction to APITraining #1
11m 52s
8. 2016 - Newbie Introduction to APITraining #2
10m 47s
9. 2017 - Newbie Introduction to APITraining #3
18m 32s

2300 - FileMaker's Certification Test

1. 2303 - If it's not Canon..
5m 26s
2. 2304 - What is FMI's Official StudyList Part #1
12m 31s
3. 2305 - What is FMI's Official StudyList Part #2
15m 53s
4. 2306 - Final Test Taking Tips...
10m 1s

2400 - Data Migration

1. 2401 - Data Migration Intro
36s
2. 2405 - Data Migration Tool - Intro
4m 10s
3. 2406 - Data Migration Tool - Rulesof the Road
9m 46s
4. 2407 - FDMT - CLI Test Drive
15m 14s
5. 2410 - FDMT - Free Wrapper App -Productive Computing
4m 17s

2500 - MISC

1. 2520 - Duplicate Module in FMSPPart 1
6m 20s
2. 2521 - Duplicate Module in FMSPPart 2
14m 38s
3. 2522 - Duplicate Module in FMSPPart 3
14m 47s
4. 2523- Duplicate Module in FMSPPart 4
12m 4s