Learning FileMaker - Practical Techniques
4.4 (68 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.
475 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning FileMaker - Practical Techniques to your Wishlist.

Add to Wishlist

Learning FileMaker - Practical Techniques

A practical FileMaker training course that teaches how to use FileMaker in the real world
4.4 (68 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.
475 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn How To Get The Most From FileMaker
View Curriculum
Requirements
  • PC or Mac
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.

Who is the target audience?
  • FileMaker Users Of All Levels
Students Who Viewed This Course Also Viewed
Curriculum For This Course
98 Lectures
05:52:27
+
Introduction
7 Lectures 17:33




0105 Goal For This Tutorial
02:31

0106 Using The Included Working Files
01:13

0107 How To Access Your Working Files
03:22
+
Starting From Scratch
14 Lectures 56:01
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
+
Automation
13 Lectures 54:04
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
+
Table Occurrences
15 Lectures 57:40
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
+
Calculations
12 Lectures 45:16
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
+
Correspondence
11 Lectures 39:50
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
+
Complex Relationships
12 Lectures 34:43
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
+
Miscellaneous
13 Lectures 45:42
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

0809 Navigation Menu
02:30

0810 Anchors
03:13

0811 Tab Order
02:33

0812 Cleaning Up
03:29

0813 Squashing Bugs
05:06
+
Conclusion
1 Lecture 01:38
0901 Wrap-Up
01:38
About the Instructor
Infinite Skills
4.4 Average rating
49,076 Reviews
749,531 Students
331 Courses
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.