FileMaker 16: FileMaker 16

Curriculum For This Course

0100 - Introductions - Overview

9Lectures

Time 01:16:00

FM Starting Point Walkthrough

19Lectures

Time 03:28:00

0300 - Fundamentals & Basics

9Lectures

Time 01:11:00

Performing Finds & Sorts

8Lectures

Time 00:58:00

0500 - Working on Fields & Layouts

29Lectures

Time 04:41:00

0550 - Containers Field & DocumentManagement

6Lectures

Time 01:12:00

0600 - Advanced Layout Techniques

14Lectures

Time 02:21:00

0700 - Emailing, Imports and Exports

15Lectures

Time 02:26:00

0800 - Integration

21Lectures

Time 04:02:00

0900 - Writing Scripts

35Lectures

Time 05:25:00

1000 - Calculations

17Lectures

Time 02:14:00

1100 - Relationships

20Lectures

Time 03:39:00

1200 - Security

16Lectures

Time 03:45:00

1300 - FileMaker Server

7Lectures

Time 02:36:00

1400 - Printing & Report Creation

11Lectures

Time 01:56:00

1500 - Custom Functions

3Lectures

Time 00:53:00

1600 - WebDirect

1Lectures

Time 00:17:00

1700 - MISC

12Lectures

Time 03:01:00

1800 - FileMaker Cloud

22Lectures

Time 03:41:00

1900 - FileMaker's Certification Test

4Lectures

Time 00:48:00

0100 - Introductions - Overview
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	1. 1602 - Creating PDF's and Emailingfrom WebDirect	16:34

1700 - MISC
	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
	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
	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