The Philosophy of FileMaker - Part 4
4.9 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
169 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Philosophy of FileMaker - Part 4 to your Wishlist.

Add to Wishlist

The Philosophy of FileMaker - Part 4

Intermediate FileMaker Pro 15 with Go, WebDirect and Server
4.9 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
169 students enrolled
Created by John Mark Osborne
Last updated 10/2016
English
Current price: $50 Original price: $200 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create a Preferences section for a multi-user solution
  • Create Options for a multi-user solution
  • Increase their knowledge of ExecuteSQL
  • Create a To-Dos system with reminders
  • Add notes with timestamps
  • add notes via a portal for better organization
  • Allow for multiple payments
  • Get Maps and Directions from Google and Apple Maps
  • Design an efficient FileMaker Go solution
  • Add GPS coordinates
  • Make a phone call
  • Scan barcodes
  • Add a picture
  • Get a solution on an iOS device
  • Understand when to use synchronization
  • Work with the Perform Script on Server step
  • Add a WebDirect component to a solution
  • Deploy a solution on FileMaker Server
  • Configure FileMaker Server for Backups, Security and much more!
View Curriculum
Requirements
  • Students should have completed Part 1, 2 & 3 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 4 of this training series continues on with FileMaker Scripting, Calculations, Relationships and Reporting but then delves into FileMaker Go, WebDirect and FileMaker Server. 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 is the target audience?
  • Students will learn how to design and deploy 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
76 Lectures
08:01:47
+
Part 4
1 Lecture 05:02
+
Preferences
13 Lectures 01:06:38

Preferences allow each user/account to customize the solution to their own particular way of working.

Preferences Defined
03:25

Let's start by creating the table, fields and interface for our preferences feature.

The Table, Fields and Interface
10:09

There's a right way and a wrong way to access preferences. Understanding the wrong way will help you understand why the right way is the best way.

The Wrong Way!
03:58

Using the ExecuteSQL function to grab information from preferences is a lot easier than attempts in previous videos to total filtered portals.

Easy ExecuteSQL
07:04

Placing the ExecuteSQL formula in a custom function will centralize the code, making it easier to update.

Custom Function
02:14

The first preference we will implement is the startup layout.

Go to Layout
03:10

The next preference is the size of the screen on open.

Screen Size
06:51

Options are similar to preferences but aren't unique to each user/account.

Options
08:22

Display company information from options on the invoice print layout.

Company Info
05:37

Adding the logo from options to the invoice printing layout isn't as straightforward as the text information.

Logo
05:15

Let's add one more option so users can specify their preferred phone formatting.

Phone Formatting
03:37

On open, let's check if the account is new and add a preference record when necessary.

Open Script Verification
04:39

You might be thinking it would be easier to use variables to store preferences and options upon opening of the file.

Global Variable Preferences
02:17
+
Notes, To Dos & Cross-Tabs
9 Lectures 01:15:10

A script to organize your notes is very important.

Notes Timestamp
09:45

Portals inherently organize data and are often a better choice for notes.

Notes Portal
08:45

Both note techniques covered are mostly adaptive so let's move them to invoices.

Adaptive Notes
04:31

A reminder system is handy for sales and customer service employees so they don't have to keep separate notes about future customer contact.

To Dos Feature
07:31

To better organize the to dos portal, let's sort and conditionally format it.

To Dos Sort and Format
06:28

A script automating the finding of unfinished to do items is ideal for efficiency.

Upcoming To Dos
07:27

A report can be useful for meetings or other situations where you may not have a computer available.

To Dos Report
11:37

Generate a PDF version of the To Dos report on the desktop or as an email attachment.

PDF Generation
08:58

Produce a report like you can achieve in a spreadsheet with columns and rows.

Cross-Tab Reporting
10:08
+
Payments, Currency & Addresses
10 Lectures 01:20:31

The ability to apply multiple payments to a single invoice is crucial in some businesses.

Multiple Payments
08:09

With the ability to add payments, we now need a balance owed calculation.

Balance
04:31

With our new payments portal, we need to update some of the existing calculations and scripts.

Status and Overdue
09:12

Let's add a button to enter a full payment.

Full Payment
03:31

Validating for overpayments is a very important task!

Validate Payment
05:54

Allow for a single payment to be applied across multiple invoices.

Payment Across Invoices
15:30

A seasoned developer is also a good software quality assurance expert.

Testing Fund Application
06:49

Format a number for currency with a calculation outside layout mode.

Currency Formatting
04:06

A Google map is easy but what about Google directions?

Google Directions
09:24

In order to verify the validity of an address, you'll need to scrape a web site.

Verifying an Address
13:25
+
FileMaker Go
17 Lectures 01:38:56

Before you design scripts and layouts for an iOS device, you first need to understand the idea behind the design of FileMaker Go.

Purpose of FIleMaker Go
05:02

FileMaker Go was designed as a client and within the limitations of a portable device so there are things you cannot do and things you shouldn't do.

Can Nots and Should Nots!
05:59

Knowing iOS screen sizes and window elements will help you design a layout that works well.

Screen Size
04:17

Layout size is the main difference between designing for desktop versus iOS.

Theme & Layout
05:28

Let's add buttons for adding records, finding, list view, calling, emailing and visiting a web site.

Startup Script & Layout
07:18

The open script needs to go to the iPhone layout instead of the desktop layout.

Form Layout Buttons
07:02

The buttons on the iOS home layout still don't function.

Home Layout Buttons
11:30

Sharing to FileMaker Go devices isn't much different than FileMaker Pro but there is one important consideration when authenticating.

Sharing
03:30

Let's see what our solution looks like on an iPhone.

Logging On
04:21

Testing even the simplest features is key to a robust solution.

Testing and Fixing
06:58

Along with form view, the list view is crucial to all FileMaker solutions, regardless of the platform.

List View
05:20

Testing often takes longer than programming.

More Testing
05:22

iOS devices have the ability to provide your location with GPS, allowing you to grab the current address.

GPS
07:12

On an iOS device I prefer to use the Apple Maps URL scheme.

Apple Maps and Directions
03:35

A quick discussion of the unique features available in Container fields on an iOS device.

Pictures, Barcodes and Signatures
03:28

Live connections aren't always possible on the go so synchronization is the best alternative.

Synchronizing
03:03

The iPhone and iPad have very different screen sizes so should you design custom layouts for each device?

What about iPad?
09:31
+
FileMaker Server
19 Lectures 02:06:45

FileMaker Pro can act as a host so why do you need FileMaker Server?

Server vs Pro
08:31

Choosing the right hardware and configuring it properly will help provide uninterrupted service for your guests.

Hardware Considerations
07:40

Consider what ports need to be opened in your firewall so you are ready to go when you install FileMaker Server.

Ports
02:35

Installing FileMaker Server is not much more difficult than FIleMaker Pro but there are a few considerations.

Install and Uninstall
08:47

FileMaker Server installs a sample file so you can test immediately after installation.

Testing
03:51

Uploading a file is as easy as choosing a menu item from the FileMaker Pro or Advanced menus.

Uploading a File
03:13

The Status pane is the default screen when opening the Admin Console and shows you an overview of what's happening.

Status Pane
07:42

The Activity pane displays live information about the databases and clients using the server.

Activity Pane
06:23

Schedule backups, FileMaker Scripts, System Level scripts and more to run automatically at specified times.

Schedules Pane
13:15

Logs include events, access and web publishing.

Log Viewer
04:16

Troubleshooting a performance problem is aided by averages, peaks, lows and graphs of related statistics.

Statistics Pane
11:09

General Settings are pretty straightforward but there are a few items worth discussing.

General Settings Pane
07:05

One of the most important configuration panes for performance and functionality.

Database Server Pane
10:12

The Folders tab in the Database Server pane specifies additional file folders, a backup folder and a progressive backup folder.

Folders Tab
10:20

The Logging tab controls the frequency of data collection, the size of logs and additional logs that can be written to disk.

Logging Tab
04:52

Some plug-ins can run on FileMaker Server and Directory Service helps FIleMaker clients find an LDAP server on the network more easily. 

Plug-Ins and Directory Service
02:49

The Web Publishing pane controls settings for custom web publishing and WebDirect.

Web Publishing Pane
03:20

Should you make changes to a live database or a backup?

Live or Offline Updating
05:32

FileMaker Cloud and third party hosting services can save you up-front costs and time.

Cloud or Hosting Services
05:13
+
WebDirect
6 Lectures 23:27

Before you design a WebDirect solution, understand the purpose and limitations of this deployment option.

Purpose and Limitations
06:01

The most often forgotten sharing option is extended privileges.

Extended Privileges
01:24

Be careful with your time and money and reuse layouts and code when it makes sense.

Why Design a New Layout?
03:52

Pay attention at all times cause you never know when a bug might rear it's ugly head.

Squashing Bugs
02:42

Let's test from a web browser to see what doesn't work.

What Doesn't Work?
07:22

Hide Object even works in WebDirect!

Hide Object
02:06
+
Working with John Mark Osborne
1 Lecture 05:18

Services include development, training and templates.

Preview 05:18
About the Instructor
John Mark Osborne
4.7 Average rating
584 Reviews
4,517 Students
9 Courses
FileMaker Pro Expert

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 and 15 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 and 15 certification tests and is proud to display the FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15 certification logos.