
Beyond Tables and Layouts: Build More with FileMaker
Creating tables, fields, and layouts is an important part of FileMaker development. But building a useful solution also means understanding how to make those components work together.
How do you calculate invoice totals, validate information before it’s saved, or automate a series of tasks that would otherwise require several manual steps?
That’s where calculations, scripting, and other intermediate FileMaker development techniques come into play. Productive Computing University‘s Claris FileMaker Pro Intermediate course gives you an opportunity to put these concepts into practice.
Put Your FileMaker Skills to Work
As your FileMaker solutions become more sophisticated, you’ll encounter opportunities to simplify processes and improve how information is managed.
For example, you can use:
- Calculations to process information, perform mathematical operations, and generate results.
- Value lists and data validation to guide data entry and help maintain accurate information.
- Scripts and script triggers to automate repetitive tasks and respond to user actions.
- Layout techniques to create more functional and user-friendly interfaces.
Understanding these features individually is helpful. Learning how to combine them is where you can begin developing more capable FileMaker solutions.
Learn Through a Practical Invoice Project
Through the course’s guided lessons, you’ll work with products, invoices, and related line items while exploring calculations, validation, scripting, and automation.
You’ll also learn how to automate parts of the invoicing process, including generating PDF invoices and sending them by email.
The course provides downloadable project files, allowing you to follow along and see how the different components come together.
While invoicing provides a practical example, the development techniques you learn can be applied to many other business workflows.
Ready to Expand Your Development Skills
If you’re already comfortable with FileMaker tables, fields, layouts, and relationships, the Intermediate course can help you build on that knowledge.
If you’re newer to FileMaker development, we recommend PCU’s Claris FileMaker Pro Beginner course to establish a solid foundation. The Beginner course is recommended, but not required if you already have the necessary skills.
Explore the Claris FileMaker Pro Intermediate course at Productive Computing University and discover how to put these development techniques to work in your own solutions.
Frequently Asked Questions
What will I learn in the Claris FileMaker Pro Intermediate course?
You’ll learn calculation functions, value lists, data validation, scripting, script triggers, and advanced layout options. You’ll also build Product, Invoice, and Invoice Line Item tables and incorporate calculations into an invoice solution.
Will I build an actual FileMaker solution during the course?
Yes. You’ll build a basic invoice solution that includes Product and Invoice tables, Invoice Line Items, and calculations. You’ll connect the new tables to the working file created in the Beginner course.
Does the course cover FileMaker scripting and automation?
Yes. You’ll be introduced to scripting and script triggers and learn how these tools can help automate actions and workflows within a FileMaker solution.
Who is the Claris FileMaker Pro Intermediate course designed for?
The course is designed for aspiring FileMaker developers, current developers who want to expand their skills, and individuals who want to learn how to develop their own customized FileMaker solutions.
Click here to register for the Claris FileMaker Pro Intermediate course.
Other products and services Productive Computing, Inc. offers:
- What can PCI do for you? – overview of our services
- Health Assessment – a comprehensive report of your FileMaker system
- Consulting and Development – services billed by the hour
- Maintenance and Support – services billed monthly
- Packaged Services – Security Audit, SSL or Server Installation
- Plug-ins – tools to integrate with QuickBooks, Outlook, Google, and more
- Solutions – free customizable and scalable CRM template
- Claris and FileMaker Licensing – discounts on new seats and renewals
- FileMaker and QuickBooks Hosting – host your files in the cloud
- Productive Computing University – online beginner to advanced training courses
- Certification Programs – expert-led training, hands-on development, and personalized evaluations


