FileMaker Pro Advanced


  • FileMaker Pro Advanced

    The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

    Hannah Griffiths
    March 2024
  • FileMaker Pro Advanced

    We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.

    Rebecca F
    March 2024
  • FileMaker Pro Advanced

    I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!

    Trinitas Consulting
    March 2024
  • Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

    Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.

    Techedology
    March 2024
  • FileMaker Pro Introduction

    I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.

    Beaulieu Motor Museum
    March 2024
  • An enjoyable and productive day. A flexible content and pace of work which suited our needs.

    Guardian News & Media
    March 2024
  • I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo.

    Paresh Dudhaiya
    March 2024
  • FileMaker Pro Introduction

    We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.

    Mondrian Investment Partners Limited
    March 2024
  • I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!

    Julian Support
    March 2024
  • Thank you for organising my FileMaker training day. I learned so much with my trainer, Nick, and have come away with such a great database. Thank you Transmedia for being so helpful!

    Lucie M
    March 2024
  • FileMaker Pro Introduction

    The set up was very professional and my trainer was very knowledgeable. Highly recommended.

    Bladeroom
    May 2024
  • FileMaker Pro Introduction

    My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!

    The White Wall Company
    March 2024
  • Great delivery, enjoyable training session.

    March 2024
  • An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

    March 2024

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

  • Finding records and navigation within a table
  • Displaying related records on a layout
  • Optimum approaches to editing a record
  • Methods of creating new records
  • Further exercises according to time available
FULL OUTLINE
  • FileMaker Pro Advanced

    The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

    Hannah Griffiths
    March 2024
  • FileMaker Pro Advanced

    We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.

    Rebecca F
    March 2024
  • FileMaker Pro Advanced

    I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!

    Trinitas Consulting
    March 2024
  • Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

    Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.

    Techedology
    March 2024
  • FileMaker Pro Introduction

    I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.

    Beaulieu Motor Museum
    March 2024
  • An enjoyable and productive day. A flexible content and pace of work which suited our needs.

    Guardian News & Media
    March 2024
  • I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo.

    Paresh Dudhaiya
    March 2024
  • FileMaker Pro Introduction

    We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.

    Mondrian Investment Partners Limited
    March 2024
  • I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!

    Julian Support
    March 2024
  • Thank you for organising my FileMaker training day. I learned so much with my trainer, Nick, and have come away with such a great database. Thank you Transmedia for being so helpful!

    Lucie M
    March 2024
  • FileMaker Pro Introduction

    The set up was very professional and my trainer was very knowledgeable. Highly recommended.

    Bladeroom
    May 2024
  • FileMaker Pro Introduction

    My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!

    The White Wall Company
    March 2024
  • Great delivery, enjoyable training session.

    March 2024
  • An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

    March 2024

Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Enquire Now

Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.

Enquire Now

Team 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

This two day Claris-authorised course is aimed at those wanting to learn powerful techniques and best practice in FileMaker database design. It recommends good practise in many areas, such as record creation, record editing, controlled value choice and controlled data display. We showcase many tried and tested procedures amassed over years of professional development for clients such as the Victoria and Albert Museum, United Nations and many NHS departments. The further exercises shown are options at the end and dependent on the time remaining. By the end of the course, you will have taken your development skills to an expert level and know how to create professional solutions that are both technically sound and easy to use.
Read More...

Course Outline

Finding records and navigation within a table

  • Writing a competent search script
  • Writing a “type ahead” script trigger
  • Restoring the found set after finding no records that match your criteria
  • Navigating the found set using the “Master-Detail” portal approach
  • Avoiding the limitations of Master-Detail using a self-join instead
  • Using portal filtering to manage larger record sets
  • Using ExecuteSQL to find data
  • Understanding the strengths of ExecuteSQL - complex searches but simple scripting
  • Displaying the results of a data retrieval in a portal

Displaying related records on a layout

  • More creative use of table joins
  • Using non-equijoin relationships
  • Multi-parameter relationships
  • Self relationships
  • Controlling portals using relationships featuring globally-stored field values
  • Achieving better information presentation through filtered portals

Optimum approaches to editing a record

  • Avoiding thoughtless editing and good practice for permitting and preventing the editing of records
  • Starting from an Edit button
  • Locking down the environment during the editing process
  • Record locking and preventing Commit during the editing process
  • Saving or reverting to previous values at the end
  • Writing a generic script to roll back to previous values AFTER Commit

Methods of creating new records

  • Choosing from existing values: Value Lists vs. Portals on a Popover vs. a Card window list
  • Opening a new window to create a new record
  • Writing a validation script to save a new record
  • Picking and unpicking records from a portal Pick List including icons to indicate add and remove
  • Looping: initialise, perform, using ExitLoopIf ()
  • Collecting IDs into a variable array
  • Creating multiple records records as a batch process using “Allow Creation of Related Records”

Further exercises according to time available

  • Adding an audit trail to your solution
  • Portal sorting
  • Exploring script triggers in more depth
  • Accessing basic web services using Insert From URL
  • Using relationships to create conditional value lists
  • Using the WHILE function as a better alternative to recursive functions
  • Understanding the Data Separation model
  • Using Virtual Lists

Our Clients

Our Recent Success Stories

Resolve Training

Resolve

Greg's Story

Head of Video at Hurst UK

InDesign Training

InDesign

Cassie's Story

Designer at Dixon Interiors

Photoshop Training

Photoshop

Karen's Story

Picture Editor at Reach PLC

30 years working with Claris
Five Star Training Five Star Training Five Star Training Five Star Training Five Star Training   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 COURSES

Latest Help Station Articles