Learning FileMaker - Practical Techniques

A practical FileMaker training course that teaches how to use FileMaker in the real world
4.3 (40 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
360 students enrolled
$50
Take This Course
  • Lectures 98
  • Contents Video: 6 hours
    Other: 0 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2014 English

Course Description

This Practical Techniques in FileMaker training course from Infinite Skills 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.

What are the requirements?

  • PC or Mac

What am I going to get from this course?

  • Learn How To Get The Most From FileMaker

What is the target audience?

  • FileMaker Users Of All Levels

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Important - Download These First - Working Files
Preview
Article
0101 About The Course
Preview
04:59
0103 How To Use The Tutorials
Preview
03:02
0104 Why A Contact Manager?
Preview
02:25
0105 Goal For This Tutorial
02:31
0106 Using The Included Working Files
01:13
0107 How To Access Your Working Files
03:22
Section 2: Starting From Scratch
0201 Planning Your Solution
03:04
0202 Data Modelling
05:48
0203 Entity Relationship Diagram 101
04:41
0204 Example ERDs
04:54
0205 Contact Manager ERD
05:48
0206 Source Tables
01:52
0207 Housekeeping Fields
04:08
0208 Key Fields
04:59
0209 Data Entry Fields
02:49
0210 Relationships
03:50
0211 Themes
02:02
0212 Form Layout
05:14
0213 List Layout
04:11
0214 Harmonious Layouts
02:41
Section 3: Automation
0301 Navigation - Part 1
04:12
0302 Navigation - Part 2
04:35
0303 Basic Security
04:01
0304 Open Script
04:41
0305 Sorting Columns
04:22
0306 Basic Scripted Find
04:51
0307 No Records Found
05:10
0308 Custom Message
04:19
0309 No Find Criteria
03:05
0310 Modify Last Find
05:03
0311 Form Or List
02:42
0312 Find Mode Confusion
02:34
0313 Hiding Objects
04:29
Section 4: Table Occurrences
0401 Anchor Buoy Relational Design
04:15
0402 Company Layouts
05:20
0403 Related Fields
03:24
0404 Go To Related Record
02:24
0405 Portals
03:17
0406 Adding Portal Rows
04:34
0407 Deleting Portal Rows
03:06
0408 Emailing
04:28
0409 Two Hops Away
03:42
0410 Printing Two Tables
03:56
0411 Scripting A Print
05:28
0412 Self Relationships
03:38
0413 Sorting Portals
02:37
0414 Sorting Relationships
02:13
0415 Importing Flat To Relational
05:18
Section 5: Calculations
0501 Age
05:32
0502 Phone Formatting
05:22
0503 Quality Assurance
03:06
0504 Phone Validation
03:25
0505 Custom Functions
03:47
0506 Hiding Objects
01:58
0507 Conditional Formatting
02:01
0508 Recursion
04:05
0509 Recursive Phone Formatting
04:24
0510 Last Modified Related - Part 1
04:05
0511 Last Modified Related - Part 2
02:15
0512 Time Stamped Notes
05:16
Section 6: Correspondence
0601 Fields And Interface
02:23
0602 Adding A Merge Field
02:34
0603 Print Layout
03:49
0604 Print Script
04:45
0605 Saving A Letter
05:03
0606 Inserting A Letter
02:53
0607 Deleting A Letter
03:49
0608 Emailing A Letter
02:12
0609 Attachments - Part 1
04:18
0610 Attachments - Part 2
03:37
0611 Tracking History
04:27
Section 7: Complex Relationships
0701 What Is A Join Table?
02:46
0702 Creating The Links Table
02:35
0703 Value Lists And The Index
03:39
0704 Testing The Basic Construct
02:23
0705 Inspecting The Linked Record
01:25
0706 Conditional Value Lists
01:54
0707 Auto-Enter Calculations
04:29
0708 Conditional Formatting
03:36
0709 Cleaning Up The Interface
02:13
0710 Conditional GTRR
02:32
0711 Filtered Portal
04:46
0712 Exclude Selected Links
02:25
Section 8: Miscellaneous
0801 Reminder System
04:57
0802 Finding Reminders
04:28
0803 What Is Record Locking?
03:20
0804 Testing For A Locked Record
03:27
0805 Fixing The Correspondence Script
02:46
0806 Custom Menus
04:27
0807 Dynamic Custom Menus - Part 1
02:45
0808 Dynamic Custom Menus - Part 2
02:41

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course