Philosophy Of Filemaker 20 - Volume 1

Learn FileMaker Scripting, Calculations and Relationships at an intermediate and advanced level!

What you'll learn

FileMaker Scripting

FileMaker Calculations

FileMaker Relationships

FileMaker Design

Requirements

FileMaker Beginner Knowledge

Must know the Differences between the 4 Modes: Browse, Find, Layout and Preview

Must have a Beginner Knowledge of Scripting

Must have a Beginner Knowledge of Calculations

Must have a Beginner Knowledge of Relationship Design

Description

If you want to learn how to create FileMaker 20 scripts, calculations and relationships at a professional level then this course is for you. Well known author John Mark Osborne starts off with a blank file so you can see every part of the process but quickly moves into intermediate, advanced and even expert techniques. The course uses a single example of an Invoicing solution to aid the learning process so you can focus on a single solution from beginning to end. Even if you don't want to build an Invoicing solution, the skills taught in this course will teach you the ins and outs of developing any solution in FileMaker. That's because John teaches you how to think for yourself instead of how to regurgitate techniques. John shows you multiple approaches to every solution and compares and contrasts the advantages and disadvantages so you know when to use each solution to each unique problem. With all the knowledge required to be a professional FileMaker developer, this course comes in 3 volumes. If you study all three volumes, you will be well prepared to prduce FileMaker solutions for your company or clients. If you aren't convinced, watch the free previews in each chapter to find out why people have trusted John's FileMaker training for the last 30 years.

Overview

Section 1: Introduction

Lecture 1 Video Structure

Lecture 2 FileMaker 20

Lecture 3 Work Files

Section 2: Database Beginnings

Lecture 4 Requirements Document

Lecture 5 ERD

Lecture 6 Naming Convention

Lecture 7 New File

Lecture 8 Tables & Housekeeping Fields

Lecture 9 Data Entry Fields

Lecture 10 Relationships

Lecture 11 Window Size & Navigation

Lecture 12 Symbols & Merge Fields

Lecture 13 Homework & Themes

Lecture 14 Button Bar

Lecture 15 List View

Lecture 16 Finishing Touches

Section 3: Portals, Calculations & Scripts

Lecture 17 Emails, Phones & Addresses

Lecture 18 Portal Buttons

Lecture 19 Portal Enhancements

Lecture 20 Dynamic Delete

Lecture 21 Phone Formatting

Lecture 22 Custom Functions

Lecture 23 Importing

Lecture 24 Parsing

Lecture 25 Selecting a Customer

Lecture 26 Lines Portal

Lecture 27 Customer Invoices

Lecture 28 Filtered Portal

Lecture 29 Miscellaneous

Section 4: Scripting

Lecture 30 Triggering a Script & Whittling Down the List

Lecture 31 GTRR (and Open URL)

Lecture 32 New Invoice from Customers

Lecture 33 New Portal Row

Lecture 34 Upcoming Birthdays

Lecture 35 Overdue Invoices

Lecture 36 Dynamic Navigation

Lecture 37 Duplicating Invoices

Lecture 38 Sorting Dynamically

Lecture 39 New Window

Lecture 40 Open Script

Lecture 41 Rolodex

Lecture 0 Compare & Contrast

Section 5: Calculations

Lecture 42 Notes with a Timestamp

Lecture 43 Tax Rates

Lecture 44 More Portal Totals + Correction

Lecture 45 Totalling a Filtered Portal

Lecture 46 ExecuteSQL to the Rescue

Lecture 47 Multiple Payments

Lecture 48 Balance calculation

Lecture 49 Outstanding Balances

Lecture 50 Delete Payment & Balance

Lecture 51 Full Payment

Lecture 52 Removing Formatting & Returns

Lecture 53 Delivery Date

Lecture 54 Maps

Lecture 55 Directions

Lecture 56 Timestamp All

Lecture 57 Window Title

Lecture 58 Calculated Button

Section 6: The Ultimate Find

Lecture 59 Why Script a Find?

Lecture 60 Basic Find

Lecture 61 Continue & Cancel

Lecture 62 Hiding in Find

Lecture 63 Searching a Phone

Lecture 64 Canceling a Script

Lecture 65 No Records Found

Lecture 66 No Find Criteria

Lecture 67 Modify Find

Lecture 68 Dynamic Scripting

Lecture 69 Table Occurrence Found Sets

Lecture 70 GTRR with Table Occurrences

Lecture 71 Adaptive Saving & Restoring

Lecture 72 List View Find

Lecture 73 Find While Typing

Aspiring FileMaker Developers who wants to Create Professional Solutions