[NPL] Intermediate/Advanced FileMaker Script Training
TweetFollow Us on Twitter

[NPL] Intermediate/Advanced FileMaker Script Training

The SCRIPTOLOGY FileMaker Hands-On Training Classes

Intermediate and Advanced scripting courses for serious FileMaker Pro
3.0/4.0 users, based on the popular Scriptology book and CD ROM from ISO
Productions.

Course Content: FileMaker Pro Scripting

Locations:
- Phoenix, Arizona
- Santa Clara, California *
- Toronto, CANADA *
- Santa Monica, California *

* Due to the popularity of this course, it has been expanded to
include three new locations. The Santa Monica course doesn't have a
new date at this time. If you are interested in this class, contact
Jerry Robin using the contact information below.

Upcoming INTERMEDIATE classes (see curriculum details below)

- January 20-22, 1999 (Phoenix, AZ)
- February 3-5, 1999 (Toronto, CANADA)
- February 24-26, 1999 (Santa Clara, CA at FileMaker, Inc. headquarters)
- March 22-24, 1999 (Phoenix, AZ)

Upcoming ADVANCED classes (see curriculum details below)

- January 25-26, 1999 (Phoenix, AZ)
- February 8-9, 1999 (Toronto, CANADA)
- March 1-2, 1999 (Santa Clara, CA at FileMaker, Inc. headquarters)
- March 25-26, 1999 (Phoenix, AZ)

To sign-up for these courses, please visit:

http://www.filemakerpros.com/training.html

Or, email:

scriptology@filemakerpros.com

Or, call:

650-856-1983

NOTE: It is possible to take both the intermediate and advanced
scripting class with one trip. In fact, we encourage it with a
$240.00 discount for anyone who takes both the intermediate and
advanced scripting class. You will get a weekend break between the
two courses to relax and enjoy yourself. (Exception: no break between
the March classes in Phoenix.)

The fee for each class is $995.00. Each attendee receives a copy of
the Scriptology book and CD at no additional charge (an $80 value).
Both classes together are only $1,750.

Due to the exchange rate differences between the U.S. and the
Canadian dollar, the Toronto class is $1,299.00 Canadian for the
intermediate or advanced course or $2350.00 Canadian for both
classes. Thanks for your understanding.

Each class will be taught by two instructors. This allows for maximum
knowledge, since each instructor has a variety of experiences.
The Phoenix courses will be taught by:
- John Mark Osborne, co-author of the Scriptology book and CD, and
- Jerry Robin, nationally renowned FileMaker trainer

The Santa Clara courses will be taught by:
- John Mark Osborne, co-author of the Scriptology book and CD, and
- Eric Culver, nationally renowned FileMaker trainer

The Toronto CANADA courses will be taught by:
- John Mark Osborne, co-author of the Scriptology book and CD, and
- Vince Menanno, president of Waves in Motion

---------------------------------------------------------------------

About the INTERMEDIATE class - Scriptology 101 - (see below for more
details):

Day 1: Fundamentals of Scripting

Day 2: Intermediate Scripting

Day 3: Intermediate/Advanced Scripting

---------------------------------------------------------------------

About the ADVANCED class - Scriptology 201 - (see below for more details):

Day 1 & 2: Intermediate/Advanced Scripting

---------------------------------------------------------------------
** Please read this if you are planning to take the Advanced class
only: **
It is recommended that you attend both the intermediate and advanced
courses even if you believe you are an advanced user. The
intermediate course covers material that is essential groundwork for
the advanced course. (See the curriculum details below in order to
ascertain whether you qualify for the advanced course.) Even if you
know some or most of the material mentioned below, it is likely the
intermediate course will enhance your knowledge or even correct
erroneous assumptions. We have found that most people will benefit
greatly by taking both the intermediate and advanced courses.
---------------------------------------------------------------------

The wildly-popular Scriptology book and CD from ISO Productions will
be referred to throughout both courses. However, Scriptology is
provided to help you continue learning after you graduate. The
primary material for the course is specially designed exercises that
will help you learn everything you ever wanted to know about
scripting. (Well, whatever we can squeeze into a couple of days,
anyway...)

Every student will have a computer. You will have plenty of
opportunity to follow along with the instructors and practice the
scripting techniques as they are presented. There will also be a
2-hour lab the second night of the Intermediate class, so you can
practice what you've learned.

Although each class will cover techniques and solutions for real-life
scripting scenarios, the emphasis for the class will be on thinking
creatively. Students will be challenged to discover multiple
approaches to the same problem and asked to analyze the advantages
and disadvantages of each. Our goal is to teach you how to solve the
problems specific to your work.

Course curriculum includes:
--------------------------------------
- Comprehensive overview of Script Steps
- Selected topics from the Scriptology book and CD
- Deeper coverage of the most important script steps
- Complex Scripting problems
- Insightful answers to your most challenging personal scripting problems

Curriculum Details:
--------------------------
Fundamentals of Scripting (Day 1 - Intermediate class)
-----------------------------------------------------------------------
+ Comprehensive overview of ScriptMaker dialog including keyboard
shortcuts, helpful hints to make scripting easier and what script steps
you don't need to learn
+ An exercise titled "Introduction to Scripting" designed to teach
navigational script steps such as Go to Record, Go to Layout, Sort, Find
All, attaching scripts to buttons and other straightforward script steps
that introduce you to scripting.
+ Organizing, Commenting and Modularizing Scripts
+ An exercise titled "Find" which takes you from a basic 2 line
user-definable find script to a 44 line script that covers just about
every conceivable feature. Students will help the instructor build this
script so that the purpose of each script step can be discovered.
Included in the exercise is Set Error Capture, Allow User Abort, If,
Status functions and Show Message.
+ Additional find subjects will be covered including how to locate
records related to the currently selected one. Four approaches will be
covered to demonstrate the advantages and disadvantages of each. Also, a
file from Scriptology will be used to demonstrate how to isolate a record.
+ An exercise titled "Restoring" will be used to teach this fundamental
scripting concept. Included in the discussion will be cross-platform
considerations, advanced uses of restore and the various parameters that
can be restored with find, import, export, sort and Page/Print Setup.
+ Question and Answer session regarding the fundamentals

Intermediate Scripting (Day 2 of Intermediate class)
---------------------------------------------------------------------
+ An exercise titled "Replace" will show how the Replace function works
and why it is better than a looping script in many situations. In the
process of the exercise, calculation functions like Case, Left, Right,
Middle, LeftWords, MiddleWords and RightWords will be discussed in order
to perform a calculated replace.
+ An exercise named "Set Field" will show you how this script step
differs from all other ScriptMaker steps. Powerful techniques such as
appending, subtracting, pushing and pulling will be discussed.
+ An exercise titled "Show Message" will explore how this script step can
be used for much more than just displaying a message on the screen.
Topics include determining which button was selected, troubleshooting
with Show Message, balloon help and bypassing messages for savvy users.
+ An exercise named "If/Else" was designed to show how the If script step
can change a static script into a dynamic script. Without this script
step, your scripts would always perform the same task.
+ Question and Answer session for intermediate issues

Intermediate/Advanced Scripting (Day 3 of Intermediate class)
------------------------------------------------------------------------

+ An exercise called "Go to Related Record" shows how this powerful
script step can perform finds.
+ An exercise titled "Perform Script" will demonstrate how to use this
script step for than just modularization. It is the most basic method for
communicating between files.
+ A file called "Exit/Halt" will demonstrate the differences between
these two script steps. In addition, the options on the Button dialog
that appear when selecting Perform Script will be discussed.
+ A file from Scriptology will be covered to demonstrate when to use
Paste Result rather than Set Field.
+ Startup and close scripts will be covered using examples from
Scriptology.
+ Any script steps that haven't been covered sufficiently will be
explored in more detail with the remaining time. Since each class varies,
this period can be longer or shorter depending on the number of related
questions that are discussed.
+ Question and Answer session

Intermediate/Advanced Scripting (Day 1 and 2 of Advanced Class)
------------------------------------------------------------------------
+ Dynamic scripting and calculations using loops and status functions.
+ Conditional layouts and when not to use scripting.
+ Hierarchical or Conditional menus in single-user and multi-user
scenarios.
+ Multi-key relationships and the Go to Related Record script step.
+ Restoring and saving a found set of records.
+ Irregular button highlighting.
+ Conditional scripting based on a user-entered password.
+ How to determine which version of FileMaker is being used.
+ Preventing users from accessing the Windows menu.
+ Custom dialogs.
+ Progress bars and charting.
+ Marking records in single-user and multi-user scenarios.
+ Referential Integrity.
+ Clairvoyance or type ahead.
+ Multi-state buttons.
+ Topics suggested by students. (Students are encouraged to bring their
own scripting challenges. This is often the most exciting part of the
class, as the instructors solve the most difficult problems before your
very eyes!)

---------------------------------------------------------------------
About the instructors:

John Mark Osborne is the co-author of "Scriptology" and the
"Everything CD for FileMaker Pro" (both published by ISO
Productions). For 2 years, John was the Technical Lead for FileMaker
Pro at FileMaker, Inc., serving as an escalation path for other
technical support representatives and writing a large portion of
TechInfo, their technical information reference. He is also the
author of the popular FileMaker Pro web site Database Pros
(www.filemakerpros.com).

Jerry Robin, owner of Robin Consulting Services, is an experienced
consultant, trainer and developer of custom FileMaker Pro databases.
He is one of only five consultants in the U.S. who has been
authorized by FileMaker, Inc. to teach their "Relational Database
Design 1" Seminar. Since 1992, he has provided custom database design
services and training to dozens of companies in the U.S. and Canada,
including Motorola, NASA, Holiday Inn, Citibank and Apple Computer.
Jerry also offers courses in relational design and custom web
publishing with FileMaker Pro. Visit his web site for more
information (www.robinconsulting.com).

Eric Culver is owner and president of Information Specialists. Eric
is one of only three trainers authorized by FileMaker, Inc. to teach
the advanced relational design course. Eric also runs a successful
consulting business where he created SuperSeats, an internet based
Microsoft Access/SQL Sever application for the ticket broker
community, and Flash Code, a commercially available shrink-wrapped
application for health care insurance billing. Eric also offers
courses in relational design with FileMaker Pro. Visit his web site
for more information (www.info-specialists.com).

Vince Menanno is owner and president of Waves in Motion. Vince
recently demonstrated his library of commercially available
shrink-wrapped plug-ins for FileMaker Pro 4.0 to a packed theatre at
the FileMaker Developer conference. Vince has also created fantastic
developer tools such as The Analyzer and DocuScript. For more
information regarding Waves in Motion products, visit the Waves in
Motion web site (www.wmotion.com).
---------------------------------------------------------------------
Class prerequisites:

You should have the following knowledge before you come to the
Intermediate class:

- understand the basics of creating and using relationships in FileMaker
Pro
- know how to create and use portals
- understand how to define fields and design layouts
- in general, feel very confident using basic FileMaker Pro features
- you don't need to know anything about ScriptMaker, but a quick read
through of the script steps can really help you get the most out of the
class

The Advanced Scripting course is NOT for beginners. You should have
the following knowledge before you come to class (or attend the
Intermediate course):

- confidence designing relationships in FileMaker Pro
- know how to create and use portals
- familiarity with most scripting steps
- familiarity with most calculation functions
- in general, feel confident designing FileMaker database solutions

---------------------------------------------------------------------
Registration and fees:

Course fee for the Intermediate Training is $995.00 for all 3 days -
includes Scriptology book and CD. Course fee for the Advanced
Training is $995.00 for 2 days - includes Scriptology book and CD.
The price for both classes is $1,750.00.

Due to the exchange rate differences between the U.S. and the
Canadian dollar, the Toronto class is $1,299.00 Canadian for the
intermediate or advanced course or $2350.00 Canadian for both classes.

These classes are usually sold out well in advance. To guarantee a
seat in any class, please register no later than 3 weeks before date
of class. All class fees must be paid one week before class.
(Corporate and Government Purchase Orders also accepted.)

To register, for schedule updates, or for information about other
FileMaker training classes, please visit:
http://www.filemakerpros.com/training.html

Or, email:

scriptology@filemakerpros.com

Or, call:

650-856-1983

To learn more about the Scriptology book and CD, visit
www.scriptology.com, send email to iso@isoproductions.com or call ISO
Productions at (925) 454-0187.

Regards,
John Mark Osborne

 
AAPL
$98.15
Apple Inc.
-0.23
MSFT
$43.58
Microsoft Corpora
-0.31
GOOG
$587.42
Google Inc.
+1.81

MacTech Search:
Community Search:

Software Updates via MacUpdate

Knock 1.1.7 - Unlock your Mac by knockin...
Knock is a faster, safer way to sign in. You keep your iPhone with you all the time. Now you can use it as a password. You never have to open the app -- just knock on your phone twice, even when it's... Read more
Mellel 3.3.6 - Powerful word processor w...
Mellel is the leading word processor for OS X and has been widely considered the industry standard since its inception. Mellel focuses on writers and scholars for technical writing and multilingual... Read more
LibreOffice 4.3.0.4 - Free Open Source o...
LibreOffice is an office suite (word processor, spreadsheet, presentations, drawing tool) compatible with other major office suites. The Document Foundation is coordinating development and... Read more
Freeway Pro 7.0 - Drag-and-drop Web desi...
Freeway Pro lets you build websites with speed and precision... without writing a line of code! With it's user-oriented drag-and-drop interface, Freeway Pro helps you piece together the website of... Read more
Drive Genius 3.2.4 - Powerful system uti...
Drive Genius is an OS X utility designed to provide unsurpassed storage management. Featuring an easy-to-use interface, Drive Genius is packed with powerful tools such as a drive optimizer, a... Read more
Vitamin-R 2.15 - Personal productivity t...
Vitamin-R creates the optimal conditions for your brain to work at its best by structuring your work into short bursts of distraction-free, highly focused activity alternating with opportunities for... Read more
Toast Titanium 12.0 - The ultimate media...
Toast Titanium goes way beyond the very basic burning in the Mac OS and iLife software, and sets the standard for burning CDs, DVDs, and now Blu-ray discs on the Mac. Create superior sounding audio... Read more
OS X Yosemite Wallpaper 1.0 - Desktop im...
OS X Yosemite Wallpaper is the gorgeous new background image for Apple's upcoming OS X 10.10 Yosemite. This wallpaper is available for all screen resolutions with a source file that measures 5,418... Read more
Acorn 4.4 - Bitmap image editor. (Demo)
Acorn is a new image editor built with one goal in mind - simplicity. Fast, easy, and fluid, Acorn provides the options you'll need without any overhead. Acorn feels right, and won't drain your bank... Read more
Bartender 1.2.20 - Organize your menu ba...
Bartender lets you organize your menu bar apps. Features: Lets you tidy your menu bar apps how you want. See your menu bar apps when you want. Hide the apps you need to run, but do not need to... Read more

Latest Forum Discussions

See All

Empire Manager (Games)
Empire Manager 1.0 Device: iOS iPhone Category: Games Price: $3.99, Version: 1.0 (iTunes) Description: Become ruler of an empire. Manage your economy, develop technology, hire an army and conquer the world in this addictive turn-... | Read more »
Empire Manager HD (Games)
Empire Manager HD 1.0 Device: iOS Universal Category: Games Price: $7.99, Version: 1.0 (iTunes) Description: Become ruler of an empire. Manage your economy, develop technology, hire an army and conquer the world in this addictive... | Read more »
Star Admiral Review
Star Admiral Review By Rob Thomas on July 30th, 2014 Our Rating: :: ADMIRABLE ADMIRALSUniversal App - Designed for iPhone and iPad While this new digital CCG may feel a bit familiar, Star Admiral offers a sci-fi twist and galaxy’s... | Read more »
Zap! Pow! Become a Badass Wizard in Phan...
Zap! Pow! | Read more »
Urban Trial Freestyle Review
Urban Trial Freestyle Review By Blake Grundman on July 30th, 2014 Our Rating: :: RIDIN' DIRTYUniversal App - Designed for iPhone and iPad A rough ride that has trouble keeping its wheels on the track.   | Read more »
Take Note! Noteshelf Has Recieved a Big...
Take Note! Noteshelf Has Recieved a Big Update. Posted by Jessica Fisher on July 30th, 2014 [ permalink ] iPad Only App - Designed for the iPad | Read more »
Cubama Review
Cubama Review By Nadia Oxford on July 30th, 2014 Our Rating: :: TETRIIIIIS IIIIIN SPAAAAACE!Universal App - Designed for iPhone and iPad With its addictive challenge and interesting premise, Cubama is frantic screen-tapping fun.   | Read more »
Become a Guardians of Galactic Peace Wit...
Become a Guardians of Galactic Peace With the New Spacefaring Sim, Kairobotica. Posted by Jessica Fisher on July 30th, 2014 [ permalink ] | Read more »
Soul Guardians: Age of Midgard Review
Soul Guardians: Age of Midgard Review By George Fagundes on July 30th, 2014 Our Rating: :: SO MUCH GRIND IT CRUNCHESUniversal App - Designed for iPhone and iPad Swords and trading cards are fun, right? So is Soul Guardians: Age of... | Read more »
NFL Fantasy Football App Redesigned Ahea...
NFL Fantasy Football App Redesigned Ahead of Upcoming 2014 Season Posted by Ellis Spice on July 30th, 2014 [ permalink ] | Read more »

Price Scanner via MacPrices.net

More iPad Upgrade Musings – The ‘Book Mystiqu...
Much discussed recently, what with Apple reporting iPad sales shrinkage over two consecutive quarters, is that it had apparently been widely assumed that tablet users would follow a two-year hardware... Read more
13-inch 2.5GHz MacBook Pro on sale for $999,...
Best Buy has the 13″ 2.5GHz MacBook Pro available for $999.99 on their online store. Choose free shipping or free instant local store pickup (if available). Their price is $100 off MSRP. Price is... Read more
Save up to $300 on an iMac with Apple refurbi...
The Apple Store has Apple Certified Refurbished iMacs available for up to $300 off the cost of new models. Apple’s one-year warranty is standard, and shipping is free. These are the best prices on... Read more
WaterField Unveils 15″ Outback Solo & 13″...
Hard on the heels of Apple’s refreshed MacBook Pro Retina laptops announcement, WaterField Designs has unveiled a 15-inch version of the waxed-canvas and leather Outback Solo and a 13-inch version of... Read more
New Roxio Toast 12 Delivers Digital Media Pow...
Roxio Toast 12 is a hub for sharing digital media to virtually any platform or device. has introduced two new additions to its Roxio Toast product family – Roxio Toast 12 Titanium and Roxio Toast 12... Read more
The lowest prices on leftover Retina MacBook...
Best Buy has dropped prices on leftover 13″ and 15″ Retina MacBook Pros by up to $300 off original MSRP on their online store for a limited time. Choose free local store pickup (if available) or free... Read more
Apple Updates MacBook Pro with Retina Display...
Apple today updated its MacBook Pro with Retina display with faster processors and double the amount of memory in both entry-level configurations. MacBook Pro with Retina display features a Retina... Read more
Up to $250 price drop on leftover 15-inch Mac...
B&H Photo has dropped prices on 2013 15″ Retina MacBook Pros by as much as $250 off original MSRP. Shipping is free, and B&H charges NY sales tax only: - 15″ 2.3GHz Retina MacBook Pro: $2349... Read more
Updated MacBook Pro Price Trackers
We’ve updated our MacBook Pro Price Trackers with the latest information on prices, bundles, and availability on the new 2014 models from Apple’s authorized internet/catalog resellers as well as... Read more
Apple updates MacBook Pros with slightly fast...
Apple updated 13″ and 15″ Retina MacBook Pros today with slightly faster Haswell processors. 13″ models now ship with 8GB of RAM standard, while 15″ MacBook Pros ship with 16GB across the board. Most... Read more

Jobs Board

Sr Software Lead Engineer, *Apple* Online S...
Sr Software Lead Engineer, Apple Online Store Publishing Systems Keywords: Company: Apple Job Code: E3PCAK8MgYYkw Location (City or ZIP): Santa Clara Status: Full Read more
Sr Software Lead Engineer, *Apple* Online S...
Sr Software Lead Engineer, Apple Online Store Publishing Systems Keywords: Company: Apple Job Code: E3PCAK8MgYYkw Location (City or ZIP): Santa Clara Status: Full Read more
*Apple* Solutions Consultant (ASC) - Apple (...
**Job Summary** The ASC is an Apple employee who serves as an Apple brand ambassador and influencer in a Reseller's store. The ASC's role is to grow Apple Read more
Sr. Product Leader, *Apple* Store Apps - Ap...
**Job Summary** Imagine what you could do here. At Apple , great ideas have a way of becoming great products, services, and customer experiences very quickly. Bring Read more
*Apple* Solutions Consultant (ASC) - Apple (...
**Job Summary** The ASC is an Apple employee who serves as an Apple brand ambassador and influencer in a Reseller's store. The ASC's role is to grow Apple Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.