FileMaker 16 Video Course

Curriculum For This Course

• 1. 0100 - Introductions - Overview 9 Videos 01:16:00
  • 0102 - The FileMaker Platform -Summary 07:29
  • 0105 - Installing FileMaker andDowngrades 08:46
  • 0106 - Buying / Licensing FileMaker -FLT 06:29
  • 0107 - Pro for FLT & ConcurrencyConnections 13:48
  • 0108 - New Feature Brain Dump forNew and Intermediate Users 08:50
  • 0109 - The New Windows Interface 03:06
  • 0113 - Basics of Sharing a Database 13:36
  • 0115 - Upgrading 12, 13, 14, or 15Solutions to FM16 07:49
  • 0117 - FM Pro Vs. Pro Advanced 02:26
• 2. FM Starting Point Walkthrough 19 Videos 03:28:00
  • 0201 - FMSP Walkthrough - Intro 06:23
  • 0202 - FMSP Device Support & LayoutOrganization 05:22
  • 0203 - Script Numbering andOrganization 04:10
  • 0205 - Whats new in FMSP 5? 06:30
  • 0207 - FMSP Account & ContactsWalkthrough 17:24
  • 0208 - FMSP Invoice Walkthrough 09:12
  • 0211 - FMSP Sales Followups 14:37
  • 0212 - FMSP Invoice - New Line Items- Advanced 14:25
  • 0213 - FMSP Estimate to InvoiceTransfer Button - Customize it! 11:32
  • 0214 - FMSP Calculating Margin andMarkup in Invoices 09:24
  • 0216 - FMSP Unlimited RelatedDigital Document Upgrade 08:40
  • 0219 - Calendar Under the Hood Part1 09:38
  • 0220 - Calendar Under the Hood Part2 12:46
  • 0221 - Tab Controls with Calculations 04:19
  • 0230 - Dashboard Charts Part #1 11:22
  • 0231 - Dashboard Charts Part #2 -Scripting 25:18
  • 0232 - Dashboard Charts Part #3 -Performance 05:02
  • 0235 - Managing Primary Keys 06:54
  • 0240 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values 10:36
• 3. 0300 - Fundamentals & Basics 9 Videos 01:11:00
  • 0301 - What is a Database - Part 1 05:49
  • 0302 - What is a Database - Part 2 04:31
  • 0303 - Modes in FileMaker 05:40
  • 0304 - Browse Mode, and the Deletemenu item 06:29
  • 0305 - Saving Data 02:02
  • 0306 - Converting from .fp7 to.fmp12 file formats 10:49
  • 0307 - Converting from .fp5 to .fp7file formats 09:30
  • 0308 - How to make a Copy of a FMDatabase 05:10
  • 0309 - What is a Relationship? 18:27
• 4. Performing Finds & Sorts 8 Videos 00:58:00
  • 0401 - Finding Records - Basics 05:43
  • 0402 - Finding - Multiple Requests 10:49
  • 0403 - Finding Ranges of Dates 04:14
  • 0404 - Finds with Special Operators 08:37
  • 0405 - Finds and Indexing andPerformance, Stored Calcs 06:15
  • 0406 - Finds Constrain and Extend 04:37
  • 0407 - Sorting Records 07:38
  • 0408 - Custom Sort Orders 07:42
• 5. 0500 - Working on Fields & Layouts 29 Videos 04:41:00
  • 0501 - Layouts - Available tools 13:15
  • 0502 - Tour of the Inspector 21:29
  • 0503 - Intro to Adding Fields toDatabase (Text and Number) 12:11
  • 0504 - Added Calc fields and HidingObjects 11:40
  • 0505 - Creating a Survey & TabPanels & Value Lists 14:28
  • 0506 - Value Lists - Under the hood 09:11
  • 0507 - Hiding Objects & ConditionalFormatting 13:26
  • 0508 - Text Fields with User SpecifiedFormatting 11:20
  • 0509 - Merge Fields 04:36
  • 0510 - Stored Vs UnstoredCalculations 11:22
  • 0511 - 3 Types of Buttons and OneGlyph - Icon 09:36
  • 0512 - Button Bar as New Data InputControl Style 03:05
  • 0513 - Inline Field Labels 03:29
  • 0514 - Layout Object Windows (LOW)(aka Layout Object Tree) 09:25
  • 0515 - Tabs vs. Slide Controls 05:51
  • 0516 - Popovers and New WindowCommand 09:43
  • 0517 - Auto-Enter Options for Fields 08:00
  • 0521 - Introduction to Single-User vs.Multi-User databases 09:25
  • 0522 - Global Fields 10:44
  • 0523 - Tooltips 07:08
  • 0524 - Object Flags, or Badges 07:33
  • 0525 - Object Alignment tools 11:44
  • 0526 - Creating a new iOS Layoutfrom Scratch - Stencils 07:01
  • 0527 - Field Validation Options 13:03
  • 0528 - Repeating Fields 08:34
  • 0530 - Layout Badge Tooltips 02:46
  • 0539 - Custom Currency in FMSP 04:06
  • 0540 - Formatting Currency - When itgoes into a Text Field 10:02
  • 0545 - Hamburger Menus & InlineText Labels 06:07
• 6. 0550 - Containers Field & DocumentManagement 6 Videos 01:12:00
  • 0551 - Container Field Introduction 11:40
  • 0553 - Advanced Container FieldKung-Fu 11:01
  • 0556 - Interactive Containers inFileMaker 15:35
  • 0560 - Containers in FMSP 06:33
  • 0562 - HiJacking Containers in FMStarting Point 17:02
  • 0580 - When Container Storage goesBad... Recovery Plan... 08:38
• 7. 0600 - Advanced Layout Techniques 14 Videos 02:21:00
  • 0601 - Making Layouts load 200%faster in FM 16 - Performance 07:16
  • 0602 - 200% faster Part 2 -Performance 08:12
  • 0603 - 200% faster Part 3 -Performance 02:53
  • 0604 - Grouping with Slide Panels toHide Objects 05:45
  • 0605 - Get Object Attribute forHidden Objects 02:52
  • 0608 - Script Triggers - Intro 04:17
  • 0609 - Script Triggers - LayoutSpecific 10:03
  • 0610 - Script Triggers - Object Specific 07:51
  • 0611 - Script Triggers - FieldValidations 10:12
  • 0612 - Script Triggers - More Layoutscontrols 06:05
  • 0614 - What is a Virtual List? ***Advanced *** 14:12
  • 0615 - Hierarchical Portal forNavigation *** Advanced *** 16:49
  • 0620 - Go to Related Record - GTRR 19:10
  • 0622 - FileMaker 14 SVG Icon HelperTool 18:20
• 8. 0700 - Emailing, Imports and Exports 15 Videos 02:26:00
  • 0701 - Sharing Data Intro 01:17
  • 0702 - Importing Data 14:34
  • 0703 - Exporting Data 07:59
  • 0704 - Scripting Import & Exports -Basics 04:31
  • 0706 - Send Email Script Step 03:53
  • 0707 - Finding Your SMTP Settings 08:40
  • 0708 - Automating outbound emails 06:51
  • 0709 - Spamming with FileMaker 08:07
  • 0710 - Automating Emailing ofExports, Like a PDF 02:00
  • 0711 - Scripting FileMaker to Deletea File 11:36
  • 0712 - Multi-Table Imports...Complex Imports 21:20
  • 0713 - Upgrading Copies of FMSP,migrating / updating to a new release 09:16
  • 0714 - Updating data in a FileMakertable from an Excel File 13:27
  • 0720 - Using 360Works Email Pluginto Send HTML Emails 06:00
  • 0725 - 360Works' CloudMail Install 16:15
• 9. 0800 - Integration 21 Videos 04:02:00
  • 0803 - Barcode DeploymentPlanning & Options 12:20
  • 0804 - Installing the BarcodeCreator into FMSP 07:21
  • 0805 - Scanning Items into Invoiceswith Barcodes 02:25
  • 0806 - Under-the-hood withScanner Barcodes In FMSP Part 1 07:20
  • 0807 - Under-the-hood withScanner Barcodes In FMSP Part 2 08:40
  • 0808 - Under-the-hood withScanner Barcodes In FMSP Part 3 12:52
  • 0809 - USB Barcodes Gun We'reUsing 06:40
  • 0810 - Setup Up Printer Labels &Users Scanning the Wrong Barcode 06:23
  • 0811 - Viewer Questions & troubleshooting Barcodes 07:06
  • 0812 - Infinite Peripherals BarcodeHardware for iPhone & iPad 11:29
  • 0814 - Getting FileMaker Server toGenerate PDFs - PSOC 09:01
  • 0815 - What is a FileMaker Robot? 08:40
  • 0820 - Intro to Sending HTML emailsand SMS messages 07:15
  • 0830 - Building a Progress Bar inFileMaker 12:19
  • 0831 - Validating Emails with aService 08:27
  • 0832 - Getting Driving DistanceFrom Google 08:45
  • 0835 - Dialing VOIP Phone with SIP& X-Lite 10:13
  • 0840 - Sending SMS with Twilio 10:38
  • 0845 - Syncing to iPad or Syncing 2databases - MirrorSync 2 45:21
  • 0846 - Clustering and Replication -MirrorSync 3 19:48
  • 0847 - 360Works MirrorSync 4 05:24
• 10. 0900 - Writing Scripts 35 Videos 05:25:00
  • 0901 - Scripting 09:58
  • 0902 - Intro to Script Workspace 11:47
  • 0903 - Workspace KeyboardShortcuts 10:56
  • 0904 - Set fields vs. Copy, Paste 16:35
  • 0905 - Set fields & Context 02:29
  • 0906 - Buttons run one Command 15:02
  • 0907 - Navigation 03:27
  • 0908 - IF...THEN...decisions 06:30
  • 0909 - Variables vs. Globals 06:05
  • 0910 - Performing Finds 09:03
  • 0911 - Basic Error Capture 10:26
  • 0912 - Calling Subscripts - ScriptParameters 08:57
  • 0913 - Advanced Script Parameters& Script Results 05:02
  • 0914 - Looping Scripts 03:15
  • 0917 - Preserving User Contextwhen running a Script 07:23
  • 0918 - New Window - Script Step 14:06
  • 0920 - Script Debugger - Part 1 20:54
  • 0921 - Script Debugger - Part 2 03:11
  • 0924 - Data Viewer 13:32
  • 0932 - UI Indicators for DatabaseActivity 10:46
  • 0940- Database PerformanceOptimization Overview 05:42
  • 0941- Making Scalable Databases 11:26
  • 0942- Server Evidence - SlowPerformance - Slow Scripts 03:28
  • 0943 - Perform Script on Server -PSOS 20:10
  • 0945 - PSOS in FMSP 07:11
  • 0946 - Testing for PSOS Availability 12:27
  • 0947 - SASE 10:31
  • 0948 - Case Statement 02:09
  • 0950 - Deduplicating Records, thePlan 07:56
  • 0951 - Replace Command - A TigerLoose at the Zoo 08:03
  • 0953 - Landmines in FileMaker 09:50
  • 0955 - Testing to Make Sure YourScript has Access to a Record 07:40
  • 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
• 11. 1000 - Calculations 17 Videos 02:14:00
  • 1001 - Calculation Engine & NewWork Space 13:21
  • 1002 - Calculation Engine & NewWork Space Part 2 04:48
  • 1010 - Parsing Text with Calcs - Part1 12:07
  • 1011 - Parsing Text with Calcs - Part2 11:33
  • 1012 - Detecting Window Mode andFilter Function 11:14
  • 1013 - Date Calcs 05:11
  • 1014 - Detecting Device & PlatformTypes 03:27
  • 1020 - Get Functions Walkthrough -Part 1 08:51
  • 1021 - Get Functions Walkthrough -Part 2 07:16
  • 1022 - Get Functions Walkthrough -Part 3 03:39
  • 1023 - Get Functions Walkthrough -Part 4 05:07
  • 1024 - GetLayoutAttribute 05:26
  • 1025 - GetContainerAttribute 05:15
  • 1026 - Get(UUID) andGet(PersistentID) 08:11
  • 1040 - List Function, Summary List,and GetValue 07:58
  • 1042 - SortValues and UniqueValues 01:40
  • 1045 - Get (ScriptName) - Understand Timing Issues... 16:37
• 12. 1100 - Relationships 20 Videos 03:39:00
  • 1101 - What is a Relationship? 09:27
  • 1102 - Table Occurrences 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:46
  • 1106 - Multi-Key Relationships 11:01
  • 1107 - Cascading Adds 07:24
  • 1108 - Cascading Deletes 06:12
  • 1111 - Portal Dialog Options 16:44
  • 1112 - Portal Summary Sum Totals 07:14
  • 1114 - Filtering Portals - RadioButtons 07:30
  • 1120 - Lookup Values 13:12
  • 1121 - Relookup Command -Updating One Time Relationships 08:06
  • 1130 - Anchor Buoy DesignMethodology Part 1 09:23
  • 1131 - Anchor Buoy DesignMethodology Part 2 07:31
  • 1132 - Many to Many Relationships 14:37
  • 1135 - Preference Table in yourSolution 07:08
  • 1140 - Calculating and Primary Keywith the current Year 10:14
  • 1150 - Multiple Page Invoices -Portal Management - Part 1 10:26
  • 1151 - Multiple Page Invoices -Portal Management - Part 2 28:25
• 13. 1200 - Security 16 Videos 03:45:00
  • 1201 - Security in FileMakerOverview 05:21
  • 1202 - Accounts and Privileges 12:11
  • 1203 - Extended Privileges...theBasics 10:26
  • 1204 - Extended Privileges...RecentChanges 09:08
  • 1205 - Encryption at Rest (EAR) 09:12
  • 1206 - Point-to-Point Encryption -SSL Certificates 52:27
  • 1207 - Audit Trails - Part 1 -Overview 12:25
  • 1208 - Audit Trails - Part 2 -Technical 11:46
  • 1209 - Audit Trails - Audits in FMSPPart 1 09:14
  • 1210 - Audit Trails - Audits in FMSPPart 2 17:44
  • 1211 - Audit Trails - Logging Recordsviewed - HIPAA 19:22
  • 1213 - Security through Obscurity 07:55
  • 1214 - Record Level Security 13:29
  • 1215 - Layout and Process AccessControls - Restricting Staff 15:09
  • 1216 - Hacking a FileMaker File...and Protecting It 07:56
  • 1220 - CryptAuthCode SecurityFunctions 07:39
• 14. 1300 - FileMaker Server 7 Videos 02:36:00
  • 1301 - Deployment & Sharing 19:10
  • 1302 - FMS Admin Walkthrough 18:23
  • 1303 - Scheduling Backups 14:45
  • 1304 - Progressive Backups 04:48
  • 1305 - Restoring from a Crash 18:58
  • 1306 - Server PerformanceImprovements 14 - Nick Lightbody 44:07
  • 1307 - Server PerformanceImprovements 15 - Nick Lightbody 31:27
• 15. 1400 - Printing & Report Creation 11 Videos 01:56:00
  • 1401 - Printing and PDF Generation 13:14
  • 1402 - Structuring your data so it isreportable 04:29
  • 1403 - List View for Ad-HocReporting 04:09
  • 1404 - Layout Parts on List View -for Beginners 09:34
  • 1405 - FileMaker Report Wizard -Very Cool 10:20
  • 1406 - Printing & Reporting onGovernment Forms 07:04
  • 1407 - Subsummaries in Detail 11:17
  • 1420 - State of Charting in FileMaker 13:00
  • 1421 - Built-in Charting Overview 19:34
  • 1422 - Google Charts 12:12
  • 1425 - MultiPage Append to PDF 07:19
• 16. 1500 - Custom Functions 3 Videos 00:53:00
  • 1501 - Top 10 FileMaker CustomFunctions (For Senior Developers) 17:46
  • 1502 - Richard Carlton's Top 5FileMaker Custom Functions 13:44
  • 1503 - Parsing XML - CustomFunction 16:40
• 17. 1600 - WebDirect 1 Videos 00:17:00
  • 1602 - Creating PDF's and Emailingfrom WebDirect 16:34
• 18. 1700 - MISC 12 Videos 03:01:00
  • 1701 - Performance Improvementsin 14 - Advanced 08:01
  • 1702 - Database PerformanceTuning with Nick Lightbody 51:12
  • 1704 - 3 Areas of PerformanceImprovement in Pro 15 10:25
  • 1706 - 3 Area of PerformanceImprovement in Pro 14 09:29
  • 1708 - How to make an AssetDatabase in 5 Minutes 07:59
  • 1717 - PHP #1 - Overview 11:52
  • 1718 - PHP #2 - Technical ProcessWalkthrough 10:34
  • 1719 - PHP #3 - Sample CodeReview 16:55
  • 1720 - Duplicate Module in FMSPPart 1 07:09
  • 1721 - Duplicate Module in FMSPPart 2 14:42
  • 1722 - Duplicate Module in FMSPPart 3 14:50
  • 1723 - Duplicate Module in FMSPPart 4 12:07
• 19. 1800 - FileMaker Cloud 22 Videos 03:41:00
  • 1802 - Detailed Comparison withRegular FileMaker Server 16:30
  • 1803 - Is FileMaker Cloud Right foryou? 08:15
  • 1804 - Brain Dump for ExperienceFileMaker Developers 16:38
  • 1805 - How to Buy FMC - Directfrom AWS - New Users 18:30
  • 1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses 17:27
  • 1807 - Uploading files to FileMakerCloud 07:16
  • 1809 - Picking the right size ofAmazon Server 09:43
  • 1811 - Understanding Amazon'sTotal Cost 14:32
  • 1812 - How to Save 50% to 75% onAmazon Instance 07:43
  • 1813 - FMI Hourly Costs... withAWS...Switch to Annual 03:11
  • 1814 - Restoring from a Backup(New Process) 11:02
  • 1815 - Restoring from a Backup 07:06
  • 1816 - Robot DB & Notifications 04:47
  • 1817 - Automated Maintenance 07:55
  • 1818 - EBS & Backups 07:32
  • 1820 - Supersize my Server! 07:47
  • 1822 - Detecting When a File isrunning on FileMaker Cloud 05:01
  • 1824 - Instance Refresh &Emergency Procedures Part 1 10:51
  • 1830 - Offboarding FileMaker Cloud 03:48
  • 1840 - Intro T2 Burstable Instances,Performance, CPU Credits 09:59
  • 1841 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large 03:17
  • 1842 - Standard Usage Scenario 16:15
• 20. 1900 - FileMaker's Certification Test 4 Videos 00:48:00
  • 1902 - Who takes the FileMakerCertification test? 05:19
  • 1904 - What is FMI's Official StudyList Part #1 12:34
  • 1905 - What is FMI's Official StudyList Part #2 15:53
  • 1906 - Final Test Taking Tips... 10:43