FileMaker 17 Video Course

Curriculum For This Course

• 1. Introduction 5 Videos 00:43:00
  • The FileMaker Platform -Summary 08:10
  • What kind of Solutions can bemade with FMSP? 06:05
  • New Features Brain Dump forNew and Intermediate Users 13:19
  • Upgrading 12, 13, 14, 15, or 16Solutions to FM17 09:42
  • FM Pro Vs. Pro Advanced 03:00
• 2. 0200 - FM Starting Point Walkthrough 20 Videos 03:02:00
  • 0205 - What's new in FMSP 6? 04:30
  • 0206 - What's new in FMSP 5? 06:52
  • 0208 - FMSP Device Support & LayoutOrganization 04:54
  • 0210 - Script Numbering andOrganization 03:39
  • 0212 - FMSP Walkthrough - Intro 09:11
  • 0214 - FMSP Complexity Theory 06:23
  • 0218 - FMSP Account & ContactsWalkthrough 17:24
  • 0219 - FMSP Invoice Walkthrough 13:57
  • 0232 - FMSP Invoice - New Line Items- Advanced 14:29
  • 0233 - FMSP Estimate to InvoiceTransfer Button 11:25
  • 0234 - FMSP Calculating Margin andMarkup in Invoices 09:24
  • 0236 - FMSP Unlimited RelatedDigital Document Upgrade 08:40
  • 0241 - Tab Controls with Calculations 04:22
  • 0245 - Super New Action Calendar 03:21
  • 0250 - Dashboard Charts Part #1 11:24
  • 0251 - Dashboard Charts Part #2 -Scripting 25:20
  • 0252 - Dashboard Charts Part #3 -Performance 04:58
  • 0255 - Managing Primary Keys - AutoScript in FMSP 06:53
  • 0260 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values 10:12
  • 0265 - Startup Bug in FMSP - FM 16Warning... 5.0.1 - 5.0.8 02:23
• 3. 0270 - Old FM Starting Point Videos 2 Videos 00:23:00
  • 0272 - Calendar Under the Hood Part1 - Old 09:38
  • 0273 - Calendar Under the Hood Part2 - Old 12:46
• 4. 0300 - Fundamentals & Basics 11 Videos 01:33:00
  • 0301 - Opening Files ... for New Users 07:09
  • 0304 - What is a Database - Part 1 05:50
  • 0305 - What is a Database - Part 2 04:30
  • 0307 - Modes in FileMaker 05:38
  • 0308 - Browse Mode, and the Deletemenu item 06:17
  • 0309 - Saving Data 02:01
  • 0310 - Converting from .fp7 to.fmp12 file formats 10:45
  • 0312 - Converting from .fp5 to .fp7file formats 11:23
  • 0313 - How to make a Copy of a FMDatabase 04:58
  • 0315 - What is a Relationship (VeryBasic Video) 18:24
  • 0330 - Basics of Sharing a Database 13:36
• 5. 0400 - Performing Finds & Sorts 8 Videos 00:59:00
  • 0401 - Finding Records - Basics 05:37
  • 0402 - Finding - Multiple Requests 11:01
  • 0403 - Finding Ranges of Dates 05:23
  • 0404 - Finds with Special Operators 08:39
  • 0405 - Finds and Indexing andPerformance, Stored Calcs 06:16
  • 0406 - Finds Constrain and Extend 04:24
  • 0407 - Sorting Records 07:37
  • 0408 - Custom Sort Orders 07:42
• 6. 0500 - Working on Fields & Layouts 28 Videos 04:16:00
  • 0501 - Layouts - Available tools 16:30
  • 0502 - Tour of the Inspector Pane -Right Side 14:43
  • 0503 - Tour of the Object Pane - LeftSide 07:57
  • 0504 - Intro to Adding Fields toDatabase (Text and Number) 10:11
  • 0505 - Added Calc fields and HidingObjects 11:14
  • 0506 - Creating a Survey, Tab Panels& Value Lists 13:02
  • 0507 - Value Lists - Under the hood 09:33
  • 0508 - Hiding Objects & ConditionalFormatting 10:33
  • 0509 - Text Fields with User SpecifiedFormatting 09:28
  • 0510 - Merge Fields 04:29
  • 0511 - Stored Vs UnstoredCalculations 11:51
  • 0512 - 3 Types of Buttons and OneGlyph - Icon 09:34
  • 0513 - Button Bar as New Data InputControl Style 04:12
  • 0514 - Inline Field Labels 06:28
  • 0515 - Tabs vs. Slide Controls 05:59
  • 0516 - Popovers and New WindowCommand 09:42
  • 0517 - Auto-Enter Options for Fields 07:53
  • 0522 - Global Fields 10:43
  • 0523 - Tooltips 06:56
  • 0524 - Object Flags, or Badges 07:34
  • 0525 - Object Alignment tools 10:38
  • 0526 - Creating a new iOS Layoutfrom Scratch - Stencils 07:01
  • 0527 - Field Validation Options 12:54
  • 0528 - Repeating Fields 07:34
  • 0530 - Layout Badge Tooltips 02:32
  • 0539 - Custom Currency in FMSP 04:01
  • 0540 - Formatting Currency - When itgoes into a Text Field 08:55
  • 0545 - Hamburger Menus 06:02
• 7. 0550 - Container Fields & DocumentManagement 6 Videos 00:57:00
  • 0551 - Container Field Introduction 08:32
  • 0552 - Thumbnailing - Under theHood 03:53
  • 0553 - Interactive Containers 11:50
  • 0556 - Fixing Interactive Containers -Which are not Interactive 15:30
  • 0560 - Containers in FMSP 06:38
  • 0580 - When Container Storage goesBad... Recovery Plan... 08:39
• 8. 0600 - Advanced Layout Techniques 9 Videos 01:30:00
  • 0601 - Making Layouts load 200%faster in FM 16 - Performance 07:20
  • 0602 - 200% faster Part 2 -Performance 10:26
  • 0603 - 200% faster Part 3 -Performance 02:54
  • 0604 - Grouping with Slide Panels toHide Objects 05:45
  • 0605 - Get Object Attribute forHidden Objects 02:51
  • 0614 - What is a Virtual List? ***Advanced *** 14:09
  • 0615 - Hierarchical Portal forNavigation *** Advanced *** 16:49
  • 0622 - FileMaker 14 SVG Icon HelperTool 19:23
  • 0630 - Web Viewers 07:19
• 9. 0800 - Calculations 16 Videos 02:17:00
  • 0801 - Calculation Engine & WorkSpace 13:20
  • 0802 - Calculation Engine & WorkSpace Part 2 05:13
  • 0810 - Parsing Text with Calcs - Part1 12:07
  • 0811 - Parsing Text with Calcs - Part2 11:33
  • 0812 - Detecting Window Mode andFilter Function 11:06
  • 0813 - Date Calcs 05:11
  • 0814 - Detecting Device & PlatformTypes 03:22
  • 0820 - Get Functions Walkthrough -Part 1 10:12
  • 0821 - Get Functions Walkthrough -Part 2 11:47
  • 0822 - Get Functions Walkthrough -Part 3 10:23
  • 0823 - Get Functions Walkthrough -Part 4 09:29
  • 0824 - GetLayoutAttribute 05:26
  • 0825 - GetContainerAttribute 05:15
  • 0826 - Get(UUID) andGet(PersistentID) 08:11
  • 0840 - List Function, Summary List,and GetValue 07:58
  • 0842 - SortValues and UniqueValues 01:37
• 10. 0900 - Writing Scripts 31 Videos 05:05:00
  • 0901 - Scripting 10:34
  • 0902 - Intro to Script Workspace 10:49
  • 0903 - Workspace KeyboardShortcuts 08:20
  • 0904 - Set fields vs. Copy, Paste 16:36
  • 0905 - Set fields & Context 02:30
  • 0906 - Buttons run one Command 15:02
  • 0907 - Navigation 03:25
  • 0908 - IF...THEN...decisions 06:30
  • 0909 - Variables vs. Globals 04:55
  • 0910 - Performing Finds 09:03
  • 0911 - Basic Error Capture 10:26
  • 0912 - Calling Subscripts - ScriptParameters 10:26
  • 0913 - Advanced Script Parameters& Script Results 05:02
  • 0914 - Looping Scripts 03:10
  • 0917 - Preserving User Contextwhen running a Script 07:23
  • 0918 - New Window - Script Step 14:04
  • 0920 - Script Debugger - Part 1 20:55
  • 0921 - Script Debugger - Part 2 03:08
  • 0924 - Data Viewer 07:06
  • 0943 - Perform Script on Server -PSOS 20:10
  • 0945 - PSOS in FMSP 07:13
  • 0946 - Testing for PSOS Availability 12:42
  • 0948 - Case Statement 02:09
  • 0950 - Deduplicating Records, thePlan 07:56
  • 0951 - Replace Command - A TigerLoose at the Zoo 08:02
  • 0953 - Landmines in FileMaker 09:46
  • 0955 - Testing to Make Sure YourScript has Access to a Record 03:57
  • 0957 - Testing to See if a Field orvariable contains ONLY a number / Tri… 05:17
  • 0965 - One Use Loop Technique 05:57
  • 0968 - Go To Object 12:18
  • 0970 - Go to Related Record - GTRR 24:05
• 11. 0980 - Script Triggers 6 Videos 00:43:00
  • 0981 - Script Triggers - Intro 05:02
  • 0982 - Script Triggers - LayoutSpecific 09:21
  • 0983 - Script Triggers - ObjectSpecific 07:51
  • 0984 - Script Triggers - FieldValidations 07:50
  • 0985 - Script Triggers - MoreLayouts controls 06:06
  • 1001 - Database PerformanceOptimization Overview 05:26
• 12. 1000 - Performance Optimization 8 Videos 02:19:00
  • 1003 - Making Scalable Databases -Part 1 11:03
  • 1004 - Making Scalable Databases -Part 2 15:33
  • 1007 - Server Evidence - SlowPerformance - Slow Scripts 03:28
  • 1010 - Performance Improvementswith the 16 Platform 08:01
  • 1015 - FileMaker's 3 Engines withNick Hunter 24:44
  • 1025 - Database PerformanceTuning with Nick Lightbody 51:14
  • 1030 - Performance Improvementswith the 15 Platform 10:25
  • 1040 - Performance Improvementswith the 14 Platform 09:17
• 13. 1100 - Relationships 23 Videos 03:59:00
  • 1101 - What is a Relationship? 06:11
  • 1102 - Table Occurrence Basics 11:52
  • 1103 - Relationship Graph & ERDs 12:23
  • 1104 - What is a Portal... and a Oneto Many Relationship? 06:42
  • 1105 - Multi-Predicate Relationships 08:40
  • 1106 - Multi-Key Relationships 09:38
  • 1107 - Cascading Adds 07:33
  • 1108 - Cascading Deletes 11:20
  • 1110 - Portal Dialog Options 12:12
  • 1111 - Portals Dialog - Add-OnTables 08:02
  • 1112 - Portal Summary Sum Totals 07:08
  • 1114 - Filtering Portals - RadioButtons 07:19
  • 1120 - Lookup Values 13:13
  • 1121 - Relookup Command -Updating One Time Relationships 08:07
  • 1130 - Anchor Buoy DesignMethodology Part 1 09:24
  • 1131 - Anchor Buoy DesignMethodology Part 2 07:24
  • 1135 - Master Detail Portals - NewFeature 10:51
  • 1136 - Master Detail Portals - Buildone in 60 seconds... 04:34
  • 1140 - Many to Many Relationships 14:38
  • 1141 - Preference Table in yourSolution 07:07
  • 1150 - Calculating and Primary Keywith the current Year 10:14
  • 1170 - Multiple Page Invoices -Portal Management - Part 1 10:26
  • 1171 - Multiple Page Invoices -Portal Management - Part 2 28:33
• 14. 1200 - Security 15 Videos 02:49:00
  • 1201 - Security in FileMakerOverview 07:19
  • 1202 - Accounts and Privileges 16:38
  • 1204 - Extended Privileges...RecentChanges 04:48
  • 1205 - Encryption at Rest (EAR) 08:36
  • 1206 - Point-to-Point Encryption -SSL Certificates 04:32
  • 1207 - Audit Trails - Part 1 -Overview 12:28
  • 1208 - Audit Trails - Part 2 -Technical 11:46
  • 1209 - Audit Trails - Audits in FMSPPart 1 09:08
  • 1210 - Audit Trails - Audits in FMSPPart 2 17:44
  • 1211 - Audit Trails - Logging Recordsviewed - HIPAA 19:21
  • 1213 - Security through Obscurity 07:55
  • 1214 - Record Level Security 13:30
  • 1215 - Layout and Process AccessControls - Restricting Staff 15:08
  • 1216 - Hacking a FileMaker File...and Protecting It 07:55
  • 1220 - CryptAuthCode SecurityFunctions 07:39
• 15. 1300 - Printing & Report Creation 11 Videos 01:56:00
  • 1301 - Printing and PDF Generation 13:18
  • 1302 - Structuring your data so it isreportable 04:28
  • 1303 - Table View for Ad-HocReporting 04:09
  • 1304 - Layout Parts on List View -for Beginners 09:29
  • 1305 - FileMaker Report Wizard -Very Cool 10:20
  • 1306 - Printing & Reporting onGovernment Forms 07:04
  • 1307 - Subsummaries in Detail 11:15
  • 1320 - State of Charting in FileMaker 13:01
  • 1321 - Built-in Charting Overview 19:33
  • 1322 - Google Charts 12:16
  • 1325 - MultiPage Append to PDF 07:19
• 16. 1400 - Custom Functions 3 Videos 00:53:00
  • 1401 - Top 10 FileMaker CustomFunctions (For Senior Developers) 18:44
  • 1402 - Richard Carlton's Top 5FileMaker Custom Functions 13:46
  • 1403 - Parsing XML - CustomFunction 16:28
• 17. 1500 - FileMaker Server (on premiseServer) 18 Videos 04:14:00
  • 1501 - Deployment & Sharing -terminology 04:03
  • 1502 - Deployment & Sharing - Intro 14:54
  • 1503 - FMS Changes... AdminConsole 04:34
  • 1504 - FMS Install w/William 13:28
  • 1505- Walkthrough of FMS AdminConsole 12:57
  • 1507 - Finding the Server Logs 06:58
  • 1508 - Scheduling Backups - TheBasics 15:21
  • 1509 - Hard Linking 07:15
  • 1510 - Progressive Backups 08:36
  • 1511 - FMS - Restoring from a Crash 14:10
  • 1512 - FMS - Command LineInterface (CLI) 15:54
  • 1514 - FMS - SSL Install 14:52
  • 1516 - FMS - Admin Data API 10:25
  • 1520 - FMS - Offsite Backups 11:47
  • 1525 - Disconnecting Idle Users 04:53
  • 1530 - SASE 13:03
  • 1541 - Server PerformanceImprovements 14 - Nick Lightbody 35:46
  • 1542 - Server PerformanceImprovements 15 - Nick Lightbody 31:24
• 18. 1600 - FileMaker Cloud 19 Videos 02:46:00
  • 1602 - Detailed Comparison withRegular FileMaker Server 10:32
  • 1603 - Is FileMaker Cloud Right foryou? 11:05
  • 1604 - Brain Dump for ExperiencedFileMaker Developers 11:35
  • 1607 - Uploading files to FileMakerCloud 07:16
  • 1609- Picking the right size ofAmazon Server 08:38
  • 1611 - Understanding Amazon'sTotal Cost 14:22
  • 1612 - How to Save 50% to 75% onAmazon Instance 07:21
  • 1613 - FMI Hourly Costs... withAWS...Switch to Annual 03:11
  • 1615 - Restoring from a Backup(New Process) 10:55
  • 1616 - Robot DB & Notifications 04:47
  • 1617 - Automated Maintenance 07:54
  • 1618 - EBS & Backups 07:35
  • 1620 - Supersize my Server! 07:48
  • 1622 - Detecting When a File isrunning on FileMaker Cloud 05:01
  • 1624 - Instance Refresh &Emergency Procedures Part 1 10:51
  • 1630 - Offboarding FileMaker Cloud 03:48
  • 1640 - Intro T2 Burstable Instances,Performance, CPU Credits 10:01
  • 1641 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large 03:19
  • 1642 - Standard Usage Scenario 16:11
• 19. 1700 - WebDirect 2 Videos 00:25:00
  • 1704 - Overview WebDirect -Android Client for FileMaker 07:34
  • 1710 - Creating PDF's and Emailingfrom WebDirect 16:43
• 20. 1800 - E-mailing, Imports and Exports -Basic Integration 12 Videos 01:31:00
  • 1801 - Introduction to FileMakerIntegration 02:19
  • 1802 - Importing Data 14:36
  • 1803 - Exporting Data 07:58
  • 1804 - Scripting Import & Exports -Basics 04:31
  • 1805 - Automating Imports orExports - Robots and Servers 08:30
  • 1809 - Finding Your SMTP Settings 03:47
  • 1810 - Automating outbound emails 08:41
  • 1812 - Spamming with FileMaker 06:52
  • 1814 - Automating Emailing ofExports, Like a PDF 08:03
  • 1816 - Scripting FileMaker to Deletea File 01:59
  • 1817 - Multi-Table Imports...Complex Imports 11:37
  • 1830 - Updating data in a FileMakertable from an Excel File 09:02
• 21. 1900 - Intermediate Integration 22 Videos 04:12:00
  • 1901 - Intermediate IntegrationOverview 02:24
  • 1903 - Barcode DeploymentPlanning & Options 12:01
  • 1904 - Installing the BarcodeCreator into FMSP 05:53
  • 1905 - Scanning Items into Invoiceswith Barcodes 02:26
  • 1906 - Under-the-hood withScanner Barcodes In FMSP Part 1 07:17
  • 1907 - Under-the-hood withScanner Barcodes In FMSP Part 2 08:40
  • 1908 - Under-the-hood withScanner Barcodes In FMSP Part 3 12:41
  • 1909 - USB Barcodes Gun We'reUsing 04:05
  • 1910 - Setup Printer Labels & UsersScanning the Wrong Barcode 06:24
  • 1911 - Viewer Questions & troubleshooting Barcodes 07:04
  • 1912 - CHOPPING BLOCK!! InfinitePeripherals Barcode Hardware for iPho… 10:53
  • 1914 - OUT OF DATE GettingFileMaker Server to Generate PDFs - PS… 09:25
  • 1915 - What is a FileMaker Robot? 08:41
  • 1921 - Using 360Works Email Pluginto Send HTML Emails 16:12
  • 1930 - Building a Progress Bar inFileMaker 12:41
  • 1931 - Validating Emails with aService 08:30
  • 1932 - Getting Driving DistanceFrom Google 08:39
  • 1935 - Dialing VOIP Phone with SIP& X-Lite 10:10
  • 1940 - Sending SMS with Twilio 10:28
  • 1945 - Syncing to iPad or Syncing 2databases - 2 39:39
  • 1946 - Clustering and Replication -MirrorSync 3 20:03
  • 1960 - 360Works' CloudMail insideof FMSP...Overview 09:32
• 22. 2000 - Advanced Integration - PHP & Rest 9 Videos 01:24:00
  • 2001 - What is REST and SectionOverview 09:11
  • 2002 - What OAuth 05:34
  • 2003 - Integration with Paypal ShortOverview 09:31
  • 2004 - Integration with Paypal -Workflow Planning 10:00
  • 2005 - Integration with Paypal -Setup Website 14:37
  • 2006 - Integration with Paypal-Under-the-hood Walk Through 04:03
  • 2015 - Newbie Introduction to APITraining #1 11:52
  • 2016 - Newbie Introduction to APITraining #2 10:47
  • 2017 - Newbie Introduction to APITraining #3 18:32
• 23. 2300 - FileMaker's Certification Test 4 Videos 00:46:00
  • 2303 - If it's not Canon... it doesn'texist... 05:26
  • 2304 - What is FMI's Official StudyList Part #1 12:31
  • 2305 - What is FMI's Official StudyList Part #2 15:53
  • 2306 - Final Test Taking Tips... 10:01
• 24. 2400 - Data Migration 5 Videos 00:38:00
  • 2401 - Data Migration Intro 00:36
  • 2405 - Data Migration Tool - Intro 04:10
  • 2406 - Data Migration Tool - Rulesof the Road 09:46
  • 2407 - FDMT - CLI Test Drive 15:14
  • 2410 - FDMT - Free Wrapper App -Productive Computing 04:17
• 25. 2500 - MISC 4 Videos 00:49:00
  • 2520 - Duplicate Module in FMSPPart 1 06:20
  • 2521 - Duplicate Module in FMSPPart 2 14:38
  • 2522 - Duplicate Module in FMSPPart 3 14:47
  • 2523- Duplicate Module in FMSPPart 4 12:04