by | Released July 2014 | ISBN: 9781771372701

In this Practical Techniques in FileMaker training course, expert author John Osborne teaches you a number of useful techniques for working in the FileMaker database. This course assumes you have some working knowledge of FileMaker.You will start by learning how to work from scratch, then jump into learning about automation, including how to sort columns, create a custom message, and hide objects. John will teach you about table occurrences, calculations, and correspondence. This video tutorial also covers complex relationships, such as creating a links table, testing the basic construct, and cleaning up the interface. Finally, you will cover a number of other handy techniques, including how to find reminders, create a custom menu, and squash bugs.Once you have completed this computer based training video, you will have developed the skills necessary to apply these practical techniques while working in FileMaker. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. 01. Introduction
   • About The Course 00:04:59
   • About The Author 00:03:00
   • How To Use The Tutorials 00:03:02
   • Why A Contact Manager? 00:02:26
   • Goal For This Tutorial 00:02:32
   • Using The Included Working Files 00:01:13
2. 02. Starting From Scratch
   • Planning Your Solution 00:03:05
   • Data Modelling 00:05:48
   • Entity Relationship Diagram 101 00:04:41
   • Example ERDs 00:04:54
   • Contact Manager ERD 00:05:49
   • Source Tables 00:01:53
   • Housekeeping Fields 00:04:08
   • Key Fields 00:05:00
   • Data Entry Fields 00:02:49
   • Relationships 00:03:50
   • Themes 00:02:02
   • Form Layout 00:05:14
   • List Layout 00:04:11
   • Harmonious Layouts 00:02:42
3. 03. Automation
   • Navigation - Part 1 00:04:12
   • Navigation - Part 2 00:04:36
   • Basic Security 00:04:01
   • Open Script 00:04:41
   • Sorting Columns 00:04:22
   • Basic Scripted Find 00:04:52
   • No Records Found 00:05:11
   • Custom Message 00:04:20
   • No Find Criteria 00:03:05
   • Modify Last Find 00:05:03
   • Form Or List 00:02:42
   • Find Mode Confusion 00:02:34
   • Hiding Objects 00:04:29
4. 04. Table Occurrences
   • Anchor Buoy Relational Design 00:04:15
   • Company Layouts 00:05:21
   • Related Fields 00:03:25
   • Go To Related Record 00:02:24
   • Portals 00:03:17
   • Adding Portal Rows 00:04:35
   • Deleting Portal Rows 00:03:07
   • Emailing 00:04:28
   • Two Hops Away 00:03:43
   • Printing Two Tables 00:03:57
   • Scripting A Print 00:05:28
   • Self Relationships 00:03:38
   • Sorting Portals 00:02:38
   • Sorting Relationships 00:02:13
   • Importing Flat To Relational 00:05:19
5. 05. Calculations
   • Age 00:05:33
   • Phone Formatting 00:05:23
   • Quality Assurance 00:03:06
   • Phone Validation 00:03:25
   • Custom Functions 00:03:47
   • Hiding Objects 00:01:58
   • Conditional Formatting 00:02:01
   • Recursion 00:04:05
   • Recursive Phone Formatting 00:04:24
   • Last Modified Related - Part 1 00:04:06
   • Last Modified Related - Part 2 00:02:15
   • Time Stamped Notes 00:05:16
6. 06. Correspondence
   • Fields And Interface 00:02:23
   • Adding A Merge Field 00:02:35
   • Print Layout 00:03:49
   • Print Script 00:04:46
   • Saving A Letter 00:05:03
   • Inserting A Letter 00:02:54
   • Deleting A Letter 00:03:49
   • Emailing A Letter 00:02:13
   • Attachments - Part 1 00:04:19
   • Attachments - Part 2 00:03:38
   • Tracking History 00:04:28
7. 07. Complex Relationships
   • What Is A Join Table? 00:02:46
   • Creating The Links Table 00:02:36
   • Value Lists And The Index 00:03:39
   • Testing The Basic Construct 00:02:24
   • Inspecting The Linked Record 00:01:25
   • Conditional Value Lists 00:01:54
   • Auto-Enter Calculations 00:04:29
   • Conditional Formatting 00:03:37
   • Cleaning Up The Interface 00:02:13
   • Conditional GTRR 00:02:32
   • Filtered Portal 00:04:47
   • Exclude Selected Links 00:02:25
8. 08. Miscellaneous
   • Reminder System 00:04:57
   • Finding Reminders 00:04:28
   • What Is Record Locking? 00:03:20
   • Testing For A Locked Record 00:03:27
   • Fixing The Correspondence Script 00:02:47
   • Custom Menus 00:04:27
   • Dynamic Custom Menus - Part 1 00:02:45
   • Dynamic Custom Menus - Part 2 00:02:41
   • Navigation Menu 00:02:31
   • Anchors 00:03:14
   • Tab Order 00:02:33
   • Cleaning Up 00:03:30
   • Squashing Bugs 00:05:07
9. 09. Conclusion
   • Wrap-Up 00:01:38
Show and hide more