FileMaker 16

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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