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