FileMaker Pro Intermediate
Claris Authorised
Training Provider
Course Facts
- 2 day course
- Our Trainers are Authorised Professionals
- Live Online or Classroom-based
- Certificate of completion
- Maximum class size of 6 for scheduled courses
- Unlimited support after your course
- Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses
Course Outline
- Introduction to relational database systems
- Managing data using One-to-Many relationships
- Introduction to Scripting
- Scripting the creation of records
- Event-driven scripting using script triggers
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Enquire NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Enquire NowTeam Training and Bespoke Sessions
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £525 + VAT.
Overview
Course Outline
Introduction to relational database systems
- The efficiencies achieved using related tables and the problems they solve
- Defining relationships between tables and understanding the Match field
- 'One to many' relationships
- 'One to one' relationships
- 'Many to many' relationships
Managing data using One-to-Many relationships
- Placing fields from a parent-table on a child layout
- Understanding and using portals on a parent layout
- Displaying related records in a portal
- Creating new records in a portal
- Navigating related files using the Go to Related Record script step
- Filtering portals
Introduction to Scripting
- Scripts v. button single actions
- Creating, duplicating and editing scripts
- Locating and adding script steps to a script
- Commonly scripted procedures
- Running scripts from buttons
- Building a Button Bar
- Scripting the creation of new windows
- Use the Card style window
- Specifying name, size and position
- Switching between windows
- Organising scripts using the Script Workspace window
- Organising scripts in folders
Scripting the creation of records
- Recap on the concept of primary and secondary keys
- Scripting the creation of related records using Set Variable and Set Field script steps
- Using the Commit Record script step
- Refreshing portals
Event-driven scripting using script triggers
- Window-based triggers
- Object-based triggers
- Layout-based triggers
- Worked examples
The power of calculation fields
- Formulae, operators and functions
- Using Text and Number functions
- Using logical functions such as If(), IsEmpty() and Case()
- Using aggregate calculations such as Count(), Min() and Max()
- Using the Let() function
Database sharing and security issues
- Defining accounts and passwords
- Understanding privilege sets
- Granting limited access by specifying a formula or rule
- Assigning full access rights to a script
Further scripting techniques
- Using script variables
- Using script parameters
- Running scripts using event triggers
- Script trigger categories
- Using script triggers - worked examples
- Using custom dialogs in scripts
- Using conditional script steps; If,Else If, Else and End If
- Using globally stored fields as part of a scripted search
- Scripting the export of data e.g as an Excel file or as a PDF and using variables to name the output file
Our Clients
Our Recent Success Stories
InDesign
Sumble's Story
Graphic Designer at Houses of Parliament
Resolve
Greg's Story
Head of Video at Hurst UK
InDesign
Amy's Story
Graphic Designer at Bedfont Scientific
600+ Reviews
Why Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact specification.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.
Courses Live Online
Join our virtual classrooms to learn from the comfort of your own space in real time from our accredited training experts.
SEE COURSES
Classroom Training
Join us at one of our Authorised Training Centres for a traditional classroom-based experience.
We have everything ready for you to have the best training experience.
SEE COURSES
Private Courses
One-to-one tuition or a private group training with just you or your colleagues.
We can train you live online, at one of our centres or onsite, wherever you are located.
SEE COURSESUseful Links
- Home page for Claris FileMaker — create custom robust operational apps. – Official FileMaker page, showing how to create custom robust operational apps
- FileMaker store – Where to buy FileMaker software
- FileMAker Wikipedia page – History and background of Claris FileMaker
- Claris Community - join the Claris and FileMaker Community – Become part of the FileMaker community and get help and resources
Harnessing the Power of Web Services in FileMaker with API Connections
Low-Code Automation Tools and the Claris Platform
Entrepreneurs, SMEs and Department Heads - Why You Need Claris FileMaker