Understand how to use the AI capabilities within FileMaker Pro. Optimise workflows and functionality with expert AI techniques.
1 day course 10am - 5pm Live Online or Classroom-based
What you will learn
- Understanding the principles of integrating AI features into FileMaker Pro, enabling smarter data analysis and automation.
- How LLMs can help you build FileMaker Find Requests at lightning speed from free-form, English-based search requests.
- How to interrogate and summarise PDF documents in seconds using the power of AI.
- How to simulate a chat interface using LLM technology directly within FileMaker Pro.
- How to perform semantic search within your own data using vector embeddings.
- How to build and harness SQL queries in multiple and flexible ways using simple search terms.
- Exploring practical applications for automating repetitive tasks, empowering you to prioritise valuable strategic work.
- How to apply new AI techniques in real client scenarios, helping you achieve higher professional standards in your role.
Related Courses
This FileMaker Pro AI Introduction 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 AI Introduction 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 AI Introduction
The Possibilities Offered By Using AI in FileMaker
- Simulating an AI Query and Return chatbot in the style of ChatGPT, Claude etc
- Perform Find By Natural Language using AI
- Perform Semantic Search using AI
- Perform SQL Queries using AI
Getting Started
- What is an LLM?
- Providers and models supported in FileMaker
- Setting up your development environment
- AI models supported
- Setting up a free account with Cohere
- Configuring the AI account connection
Using Generate Response From Model
- The Generate Response From Model script step
- Defining the Prompt and the Response
- Understanding Temperature
- Asking a question and returning a reponse
Using AI to Analyse FileMaker Data
- Performing AI analysis of internally stored data eg. summarising PDFs
- Using the GetTextFromPDF() function
- Combining the prompt with the PDF
- Working with the Markdown included in the response
Interrogating your own data using Instructions
- Enabling your team to perform FileMaker searches using free-form text
- Gathering data, finding records and looping through to build your summarised raw data
- Using the Instructions option to build the equivalent of a System prompt
- Using free-form search terms to find matching records
Simulating an AI chat interface
- Saving context using messages
- Saving message history
- Controlling memory using the Count option
- Noting the memory history is stored as a JSON array
- Likely use cases for memory-enhanced messaging
Using Perform Find by Natural Language
- The options within the script step 'Perform Find by Natural Language'
- Understanding how it works - sending Schema not actual data to the AI
- Found Set vs. 'Found Set by JSON' vs. 'Find Request as JSON'
- Inspecting the Find Requests generated
- Making requests more intelligent using AI reasoning
- Enhancing requests using Parameters and a Prompt template
- Generating the search results as JSON rather than a found set
- Generating just the Find Requests as JSON rather than performing the search , Layouts, Query, Sort order
Understanding the options within 'Perform SQL Query by Natural Language'
- Using Query
- Using Query for data only
- Using Get SQL
- Using Get First SQL
- Using Get DDL
Perform SQL Query by Natural Language
- Choosing tables: From List, By Name or By DDL
- How it works , prompt sent to AI along with DDL, SQL query returned, Data collected then processed by AI then returned
- Further options with JSON
- Using 'Query for data only'
- Using 'Get SQL' to returns only the SQL needed to retrieve the response
- Using 'Get First SQL'
Using DDL in Perform SQL Query by Natural Language
- What is Data Definition Language?
- Understanding DDL in FileMaker , using the GetTableDDL() function to reveal tables, fields and values entered in Comments
- Using DDL in Perform SQL Query by Natural Language
- Using the [LLM] tag
Perform Semantic Search using AI
- Traditional FileMaker Find mode vs. Semantic Search
- How AI Semantic Search works in FileMaker
- Using vector embeddings to allocate numerical values to words, phrases and images
- Understanding the use of Cosine similarity to define similar, not similar and opposite meanings
- Turning text into vector embeddings
- Using tokens and embeddings
- The trade-off between performance and efficiency
- The principle of using Cosine similarity to measure the angle between two vectors
The Practical Process of Semantic Search
- Performing semantic finds
- Adjusting Cosine similarity
- Advanced semantic find features
- Performing hybrid searches
- Monitoring the process
- Working with token counts
- AI call logging
FAQs about the FileMaker Pro AI Introduction course
Is this FileMaker Pro AI course suitable for me?
This course is designed for FileMaker developers who have been using FileMaker Pro for around 2 years or more. 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 AI course?
Our FileMaker Pro AI course is extremely interactive. You will be using FileMaker Pro throughout the day, understanding the benefits of applying LLM technology to FileMaker. You'll work through our AI chat, search and SQL query examples under the guidance of our trainer, who will be inviting questions and supporting you through each step.
How many people are likely to be in the class when I attend the FileMaker Pro AI course?
For private classes in FileMaker Pro AI, 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 AI 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 AI course?
We offer ongoing support to our FileMaker Pro AI 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 AI Introduction course?
Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our FileMaker Pro AI Introduction course. Our certificates note our Authorised Training Centre status.
FileMaker Pro AI Introduction — 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.