The Philosophy of FileMaker – Part 2

The Philosophy of FileMaker – Part 2, available at $19.99, has an average rating of 4.85, with 79 lectures, based on 107 reviews, and has 616 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 2

Summary

Title: The Philosophy of FileMaker – Part 2

Price: $19.99

Average Rating: 4.85

Number of Lectures: 79

Number of Published Lectures: 79

Number of Curriculum Items: 79

Number of Published Curriculum Objects: 79

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 2 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 2

Lecture 1: Recap of Part 1

Chapter 2: Ultimate Find

Lecture 1: Why Script a Find?

Lecture 2: Basic Find Script

Lecture 3: Continue and Cancel

Lecture 4: Hiding Objects

Lecture 5: Canceling a Script

Lecture 6: No Records Found

Lecture 7: No Find Criteria

Lecture 8: Modify Find

Lecture 9: Dynamic Scripting

Lecture 10: List versus Form

Lecture 11: Table Occurrence Found Sets

Lecture 12: GTRR with Table Occurrences

Lecture 13: Adaptive Saving and Restoring

Lecture 14: Fixing the Other Scripts

Lecture 15: Perfecting Invoice Duplication

Chapter 3: Calculations

Lecture 1: Anatomy of a Calculation

Lecture 2: The Many Faces of the Calculation Dialog

Lecture 3: Sales Tax

Lecture 4: Grand Total – Part 1

Lecture 5: Grand Total – Part 2

Lecture 6: Phone Formatting

Lecture 7: Phone Validation

Lecture 8: Remove Text Formatting

Lecture 9: Overdue Invoice Display

Lecture 10: Locating Overdue Invoices

Lecture 11: Parsing Text

Lecture 12: Replacing Data

Lecture 13: Parsing Text Advanced

Lecture 14: Scripts versus Calculations

Lecture 15: Field Level Tracking

Lecture 16: Advanced Field Level Tracking

Lecture 17: True Modification Tracking

Lecture 18: Tooltips

Lecture 19: Hiding Objects in Portals

Lecture 20: Delivery Work Day

Chapter 4: FileMaker Advanced

Lecture 1: What does it do?

Lecture 2: Recover

Lecture 3: Plug-ins

Lecture 4: Database Design Report

Lecture 5: Developer Utilities

Lecture 6: Script Debugger 101

Lecture 7: Debugging Script Example

Lecture 8: Custom Phone Function

Lecture 9: Recursion Primer

Lecture 10: Recursive Phone Function

Lecture 11: Validation Recursion

Lecture 12: Custom Menus

Lecture 13: Dynamic Custom Menus

Chapter 5: Multi-User Solutions

Lecture 1: Sharing a File

Lecture 2: Record Locking Defined

Lecture 3: Deleting a Record

Lecture 4: Adaptive Deletion

Lecture 5: Deleting a Portal Row

Lecture 6: Deleting a Line Item

Lecture 7: Global Fields & Script Variables

Lecture 8: Identifying Scripts with Record Locking

Lecture 9: Scripting for Multiple Locked Records

Lecture 10: Marking Records

Lecture 11: Multiple User Marking

Lecture 12: Creating a Multi-Key

Lecture 13: Saving a Found Set

Lecture 14: Restoring a Found Set

Lecture 15: Transactional Processing

Lecture 16: Leveling Inventory Revisited

Chapter 6: Custom Form Letters

Lecture 1: Merge Fields in Browse

Lecture 2: Substitution

Lecture 3: Print Layout

Lecture 4: Print Script

Lecture 5: Resolving Record Locking

Lecture 6: Save Letter

Lecture 7: Insert Letter

Lecture 8: Overwrite Letter

Lecture 9: Automating Text Formatting

Lecture 10: Formatting Magic

Lecture 11: Emailing

Lecture 12: History

Lecture 13: Mistakes

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: 8 votes
4 stars: 25 votes
5 stars: 73 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