Enhance your FileMaker Pro skills and streamline your database solutions. Optimise app development with advanced table relationships and learn scripting from industry experts in FileMaker training.
2 day course 10am - 5pm Live Online or Classroom-based
What you will learn
- Understanding relational database systems and how to create efficient relationships between tables to solve complex data challenges.
- How to manage data using one-to-many relationships, including displaying, filtering and navigating related records with portals.
- Creating and editing scripts to create, edit and delete records, automate workflows and enhance user interactions with custom windows.
- Exploring event-driven scripting using triggers to execute actions based on user interactions, window or layout changes.
- How to use calculation fields with logical and aggregate functions to perform advanced data analysis and dynamic calculations.
- Implementing database security by defining accounts, privilege sets and rules to control access and protect sensitive data.
- Mastering general techniques to streamline data management processes and improve the functionality of your FileMaker solutions.
- Learning more advanced skills to enable you to build more robust databases that enhance productivity across your organisation.
This FileMaker Pro Intermediate course includes
-
Authorised Certificate
-
Lifetime support after your course
-
Course materials
-
Live Instructor-led training
-
Refreshments all day
-
Latest Mac or PC ready to go
-
Authorised Trainers
-
Hands-on exercises
Book this course
We offer FileMaker Pro Intermediate as a private course.
You can select a date which suits you or your team.
The course content can be fully customised to your exact learning requirements.
Request datesCourse Outline for FileMaker Pro Intermediate
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
FAQs about the FileMaker Pro Intermediate course
Is this FileMaker Pro Intermediate course suitable for me?
This course is designed for people who have experience in FileMaker Pro or have already attended one of our FileMaker Pro training courses or who would like to further their knowledge of best practice in the use of FileMaker Pro. If you are have any questions about whether the course could meet your needs, please speak to our customer service team, who will be delighted to advise you.
How is the content taught throughout the FileMaker Pro Intermediate course?
Our FileMaker Pro Intermediate course is extremely interactive. You will be using FileMaker Pro throughout the day, working through examples and live projects under the guidance of our trainer, who will be supporting you through each step.
What is the recommended number of people for the class when I attend the FileMaker Pro Intermediate course?
For private classes in FileMaker Pro Intermediate, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.
Should I attend the FileMaker Pro Intermediate course in person or live online?
For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.
What support is available after I attend the FileMaker Pro Intermediate course?
We offer ongoing support to our FileMaker Pro Intermediate course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.
Will I receive a certificate upon completion of my FileMaker Pro Intermediate course?
Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our FileMaker Pro Intermediate course. Our certificates note our Authorised Training Centre status.
FileMaker Pro Intermediate — Team and Bespoke Training
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 £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Book NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Book Now
Our Clients
Latest Blog Articles
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 FileMakerWhy Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact requirements.
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.