1. Introduction

5 lectures 40m 16s

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

2. 0200 - FM Starting Point Walkthrough

20 lectures 2h 59m 41s

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

3. 0270 - Old FM Starting Point Videos

2 lectures 22m 24s

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

4. 0300 - Fundamentals & Basics

11 lectures 1h 30m 31s

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

5. 0400 - Performing Finds & Sorts

8 lectures 56m 39s

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

6. 0500 - Working on Fields & Layouts

28 lectures 4h 8m 9s

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

7. 0550 - Container Fields & DocumentManagement

6 lectures 55m 2s

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

8. 0600 - Advanced Layout Techniques

9 lectures 1h 26m 56s

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

9. 0800 - Calculations

16 lectures 2h 12m 10s

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

10. 0900 - Writing Scripts

31 lectures 4h 48m 56s

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

11. 0980 - Script Triggers

6 lectures 41m 36s

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

12. 1000 - Performance Optimization

8 lectures 2h 13m 45s

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

13. 1100 - Relationships

23 lectures 3h 53m 31s

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

14. 1200 - Security

15 lectures 2h 44m 27s

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

15. 1300 - Printing & Report Creation

11 lectures 1h 52m 12s

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

16. 1400 - Custom Functions

3 lectures 48m 58s

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

17. 1500 - FileMaker Server (on premiseServer)

18 lectures 4h 20s

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

18. 1600 - FileMaker Cloud

19 lectures 2h 42m 10s

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

19. 1700 - WebDirect

2 lectures 24m 17s

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

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

12 lectures 1h 27m 55s

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

21. 1900 - Intermediate Integration

22 lectures 3h 53m 48s

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