View UC Santa Cruz Home PageStaff Human Resources Site Banner. Blue Background with Gradient. Text in Gold.
View Staff HR Home PageView Staff HR Directory & SevicesView Staff HR Forms LibraryPolicies & ContractsStaff HR Procedures
SHR A-Z Indes and Glossary Links View the SHR A-Z Index View the SHR Glossary
Job Opportunities ...
Current Openings
Job Seeker Toolkit
Contact Us ...
Locate Your Team
Directory & Services
Topics ...
Benefits
Compensation/Classification
Employee & Labor Relations
Employment Services

Training & Development
HR Management Toolkit

Related Resources ...
Academic Personnel Office
Campus Conflict Resolution
Campus Ombuds
Required Labor Law Notices
Title IX, Sexual Harassment

Mailing Address
Staff Human Resources
UC Santa Cruz
1156 High Street
Santa Cruz, CA 95064

Office Location: [Directions]
1201 Shaffer Road
Santa Cruz, CA 95060

© UC Santa Cruz
Terms and Conditions of Use
Maintained by shrweb@ucsc.edu
Last Revised: 08/02/2011

Training & Development - Technical Training Curriculum

[Back to course listing]

FileMaker Pro, Scripting Basics

Imagine being able to have FileMaker perform a sequence of complex actions with a single command! You'll be able to do exactly that once you attend the "Scripting Basics in FileMaker Pro" course, where you'll learn how to create scripts that save you time and ensure consistent results. You can stop doing routine, repetitive procedures manually by learning how to create scripts that will do these tasks for you.

During the class, you will learn how to create scripts that find and organize records and prepare desired reports with one click or a single keystroke. You'll create a "loop" script that examines a database and marks duplicate records automatically. Another script helps you find and archive old records that are no longer needed. You learn how to plan, document, and troubleshoot FileMaker Pro scripts.

Presenter(s): Frank Widman, Senior Technical Training Consultant

Prerequisites: FileMaker Pro Level 2 or equivalent experience

Enrollment: Use our Online Registration Form, or call 459-5565.

Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.

Related Courses:

Schedule
Date Time Fee Location

February 8, 2011

9am - 4pm $30 Kerr Hall Room 159

Course Outline

  • Planning Scripts
    • Defining a Script
    • The importance of keeping scripts small and simple
  • Creating Scripts
    • Create, edit and run a basic script
    • Manipuate the script editing window
  • Conditional Scripting
    • If Structure
    • Set Error Capture
    • Get Functions
    • Show custom messages
  • Using Loop Script to Mark Duplicate Records
    • Loop Structure
    • Utilize the Set Field command
    • Incorporating global fields into script steps
  • Automated Page Numbering
    • Find the total number of pages in a multi-page report
    • Use a global number field to define the total pages
  • Copying Records to Another File
    • Create a script that exports records to an archive database
    • Use an external script from another database
  • Start up and Shutdown Scripts
  • Using External Scripts and Buttons
    • Use a script in conjunction with 2 related databases
  • Comprehension Activities
    • Create Individual Sales/Student Reports
    • Create a Context-Sensitive Help System
    • Create Multiple Letters Using Scripts
  • Documenting and Troubleshooting
    • Tips for working with FileMaker Pro scripts