Constructing a Complete FileMaker 16 CRM Part 3

Constructing a Complete FileMaker 16 CRM – Part 3, available at $19.99, has an average rating of 4.95, with 74 lectures, based on 26 reviews, and has 184 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 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 contact management 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 beginner 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 contact management 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 beginner information.

Enroll now: Constructing a Complete FileMaker 16 CRM – Part 3

Summary

Title: Constructing a Complete FileMaker 16 CRM – Part 3

Price: $19.99

Average Rating: 4.95

Number of Lectures: 74

Number of Published Lectures: 74

Number of Curriculum Items: 74

Number of Published Curriculum Objects: 74

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

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 contact management 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 beginner 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 contact management 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 beginner information

Continue learning FileMaker 16 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 Contact Manager or CRM 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: Ultimate Find

Lecture 1: Important Find Operators

Lecture 2: How does the Index Work?

Lecture 3: Why Script a Find?

Lecture 4: Basic Find Script

Lecture 5: Continue and Cancel

Lecture 6: Hiding Objects

Lecture 7: New Request and Omit

Lecture 8: No Records Found

Lecture 9: No Find Criteria

Lecture 10: Modify Find

Lecture 11: List Versus Form

Lecture 12: Dynamic Scripting

Lecture 13: Table Occurrence Found Sets

Lecture 14: GTRR with TOs

Lecture 15: Implementation

Chapter 3: Becoming a Developer

Lecture 1: Users

Lecture 2: Modularization

Lecture 3: Simplicity

Lecture 4: Corrupting a Database

Lecture 5: Recover

Lecture 6: Backups

Lecture 7: Organizing

Lecture 8: Plug-In Example

Lecture 9: Database Design Report

Lecture 10: Script Debugger

Lecture 11: Compare & Contrast

Lecture 12: KISS

Chapter 4: Custom Menus & Security

Lecture 1: What is a Custom Menu?

Lecture 2: Creating a Menu Set

Lecture 3: Automatic Installation

Lecture 4: Adaptive Menus

Lecture 5: Security Overview

Lecture 6: Ersatz Systems

Lecture 7: Accounts

Lecture 8: Authentication Types

Lecture 9: Privilege Sets

Lecture 10: Data Access and Design

Lecture 11: Scripting No Access

Lecture 12: Extended Privileges

Lecture 13: Record Level Access

Lecture 14: File Access & Re-Login

Chapter 5: Reminders

Lecture 1: Reminders Structure

Lecture 2: Portal Changes

Lecture 3: Formatting & Filtering

Lecture 4: Choosing an Interface

Lecture 5: Finding Reminders

Lecture 6: Reminders Report

Lecture 7: Report Script

Lecture 8: Reminders by Person

Lecture 9: Updating Find

Lecture 10: Contact Information

Lecture 11: Add Account

Lecture 12: Finding Reminders Revisited

Lecture 13: Auto-Enter Me

Lecture 14: Reminders in Employees

Lecture 15: Account First

Lecture 16: Install OnTimer

Lecture 17: Reminders by Time

Lecture 18: Reminders Open

Lecture 19: Reminders Show

Lecture 20: Navigate to Reminder

Chapter 6: Wrapping it Up!

Lecture 1: Naming Windows Adaptively

Lecture 2: Naming New Records

Lecture 3: Notes Revealed

Lecture 4: Portal Notes

Lecture 5: Adding Notes without a Blank Row

Lecture 6: Groups

Lecture 7: Family

Lecture 8: SQA

Lecture 9: Clean Up Schema

Lecture 10: Fix Tab Order

Lecture 11: FileMaker Versions

Chapter 7: Working with John Mark Osborne

Lecture 1: Services Offered

Instructors

John Mark Osborne
FileMaker Pro Expert

Rating Distribution

1 stars: 2 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 5 votes

5 stars: 19 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!