The Philosophy of FileMaker – Part 3

The Philosophy of FileMaker – Part 3, available at $19.99, has an average rating of 4.75, with 75 lectures, based on 80 reviews, and has 517 subscribers.

You will learn about 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 This course is ideal for individuals who are Students will learn how to design a complete solution from the ground up including layout design, scripting, calculations, relational design and reporting or An invoicing solution will be used as the basis for the course but the concepts learned can be applied to any solution or This is an intermediate course with some advanced information It is particularly useful for Students will learn how to design a complete solution from the ground up including layout design, scripting, calculations, relational design and reporting or An invoicing solution will be used as the basis for the course but the concepts learned can be applied to any solution or This is an intermediate course with some advanced information.

Enroll now: The Philosophy of FileMaker – Part 3

Summary

Title: The Philosophy of FileMaker – Part 3

Price: $19.99

Average Rating: 4.75

Number of Lectures: 75

Number of Published Lectures: 75

Number of Curriculum Items: 75

Number of Published Curriculum Objects: 75

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Part 3

Lecture 1: Recap of Part 2

Chapter 2: Script Triggers

Lecture 1: Trigger Types

Lecture 2: Definitions

Lecture 3: Considerations

Lecture 4: Order of Execution

Lecture 5: Layout Navigation

Lecture 6: Centralized Sorting

Lecture 7: Prevent Carriage Returns

Lecture 8: History Table

Lecture 9: History Decisions

Lecture 10: History Script

Lecture 11: List View Filter

Lecture 12: Commit Interruption

Lecture 13: Tab Panel Restoration

Lecture 14: Window Naming

Lecture 15: Validation Substitution

Lecture 16: Find Interrupted

Chapter 3: Save a Found Set

Lecture 1: Loop with Global

Lecture 2: Loop with Variable

Lecture 3: Speed Testing

Lecture 4: GetNthRecord Recursion

Lecture 5: Summary List

Lecture 6: Compare and Contrast

Lecture 7: Saving Multiple Found Sets

Lecture 8: Duplicate Set Names

Lecture 9: Restoring Multiple Found Sets

Lecture 10: Deleting a Found Set

Lecture 11: Multiple Tables

Lecture 12: Account Aware Found Sets

Lecture 13: Save with Snapshot Link

Lecture 14: Restore Snapshot Link

Lecture 15: Multiple Tables Revisited

Chapter 4: Parsing for Features

Lecture 1: New Requests Made Easier

Lecture 2: Beyond Basic Parsing

Lecture 3: Parsing a Form Email

Lecture 4: Parse a Form Email Formula

Lecture 5: Parse a Form Email Script

Lecture 6: Saving Find Criteria

Lecture 7: Restoring Find Criteria

Lecture 8: Multiple Tables or Users

Lecture 9: Menu Number

Lecture 10: Web Browser Back Button

Lecture 11: Storing Layouts

Lecture 12: Restoring Layouts

Lecture 13: Forward Button

Lecture 14: Back Records, Files and Windows

Chapter 5: Security

Lecture 1: Security Overview

Lecture 2: Complete Approach

Lecture 3: Accounts

Lecture 4: Privilege Sets

Lecture 5: Data Access and Design

Lecture 6: Extended Privileges

Lecture 7: Record Level Access

Lecture 8: External File Protection

Lecture 9: No Access Layout

Lecture 10: Capturing Security Errors

Lecture 11: Re-Login

Lecture 12: Random Passwords

Lecture 13: Manage Override Setup

Lecture 14: Manager Override Script

Chapter 6: Odds & Ends

Lecture 1: Open: Install Menu Set

Lecture 2: Open: Window Settings

Lecture 3: Open: File Name Variable

Lecture 4: Bundling Products

Lecture 5: Open: Locate Overdue Invoices

Lecture 6: Open: Initialize Globals

Lecture 7: Find Similar Methods

Lecture 8: Find Similar Comparison

Lecture 9: Identifying a Duplicate

Lecture 10: Deleting Duplicates

Lecture 11: Preventing Duplicates

Lecture 12: Tab Order

Lecture 13: Cleaning Up Layouts

Lecture 14: Cleaning Up Schema

Chapter 7: Working with John Mark Osborne

Lecture 1: Services Offered

Instructors

John Mark Osborne
FileMaker Pro Expert

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 1 votes
4 stars: 20 votes
5 stars: 58 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu