The Philosophy of FileMaker - Part 3

Name: The Philosophy of FileMaker - Part 3
Rating: 4.8 (78 reviews)

Intermediate FileMaker Pro 15 Scripting, Calculations, Relationships and Reporting

(78 ratings)

505 students

Created by John Mark Osborne

Last updated 8/2016

English

English [Auto]

What you'll learn

Design a multi-user solution
Identify and create one-to-many, many-to-one, one-to-one and many-to-many relationships
Create an Entity-Relationship diagram (ERD)
Design according to the principals of anchor-buoy relational design
Translate business systems from real-life to electronic using data modeling
Create portals, filtered portals and filtered relationships
Learn how to print properly in a multi-table environment
Work with columns, merge fields, labels and a variety of other print mediums
Create reports using sub summary parts and summary fields
Learn how to script complex automations with decision making intelligence
Create adaptive or dynamic scripts
Work with modular scripting
Capture errors and redirect programming with error analysis
Save and restore found sets for a better user experience
Compare and contrast different approaches to a problem in order to design better solutions
Validate and format a phone number for consistent data entry
Flag overdue or upcoming events
Understand record locking and script for multi-user solutions
Learn the differences and best uses for global fields, variables and parameters

Requirements

Students should have completed Part 1 & 2 of the Philosophy of FileMaker
Students should be familiar with the basics of browse, find, layout and preview mode which can be achieved by taking any of the beginner courses also available on Udemy
Students do not need to have experience with relational design, scripting and calculations but familiarity can help in faster learning
This is an intermediate course with some advanced information

Description

Part 3 of this training series continues on with FileMaker Scripting, Calculations, Relationships and Reporting from the guy who actually wrote the book, Scriptology: FileMaker Pro Demystified. With over two decades of experience teaching FileMaker, John Mark Osborne will help you understand tough FileMaker concepts with ease. Intermediate and advanced FileMaker techniques will be taught throughout the three part tutorial series. In order to better understand every nut and bolt that goes into designing a solution, a single file will be created from scratch. The chosen solution is an invoicing solution for its familiarity to a wide audience and flexibility of applying techniques to other solutions. The completed FileMaker file at each stage is provided to assist with the learning process.

Who this course is for:

Students will learn how to design a complete solution from the ground up including layout design, scripting, calculations, relational design and reporting
An invoicing solution will be used as the basis for the course but the concepts learned can be applied to any solution
This is an intermediate course with some advanced information

John Mark Osborne

FileMaker Pro Expert

4.6 Instructor Rating
1,448 Reviews
13,263 Students
17 Courses

John Mark Osborne has been working with FileMaker Pro for over 20 years. He earned his FileMaker Pro degree working on the frontlines of Claris technical support. John was the Technical Lead for FileMaker, serving as an escalation path for other technical support representatives and writing a large portion of TechInfo (now called Knowledgebase), their technical information reference. John also acted as a liaison between the technical support department and the FileMaker development team, reporting bugs, attending product meetings and acting as resource for the development team.

John Mark is best known as the author of the popular FileMaker Pro web site Database Pros. The Database Pros web site has been on the internet for 20 years and gets over 35,000 hits a day by offering free FileMaker Pro tips, tricks and techniques.

John Mark is also well known as the co-author of the wildly popular Scriptology book and CD ROM. John Mark launched a hands-on training class based on his Scriptology book and it has become so popular that it is now taught at MacWorld Exposition in San Francisco and New York. Most recently, John Mark was one of twelve trainers in the United States authorized to teach their new FileMaker Training Series of classes.

John Mark has been a featured speaker at the FileMaker Developer Conference for 15 years. At the 1999 Developer Conference, he was awarded the FileMaker Pro Excellence award for "creation of outstanding technical resources".

John Mark is a former technical editors for Advisor magazine working on the tips and tricks section which is the most popular column in the magazine.

John Mark has recorded beginner, intermediate and advanced tutorial videos for FileMaker 8, 9, 10, 11, 12, 13, 14, 15, 16 and 17 totaling thousands of hours.

John Mark Osborne is an FBA member (FileMaker Business Alliance) working closely with FileMaker, Inc. and their most important customers. John Mark Osborne has also passed the rigorous FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15, 16 and 17 certification tests and is proud to display the FileMaker 7, 8, 9, 10, 11, 12, 13, 14,15, 16 and 17 certification logos.