Plan and create database tables, fields, relationships
Use powerful SQL queries to create more efficient and powerful solutions
Automate tasks with scripts and plug-ins

Master FileMaker Pro with comprehensive, up-to-date instructions Covers basic to advanced topics Boost workflow efficiency using proven methods from a seasoned developer

Autorentext

Mark Conway Munro is an author and software developer. After being introduced to FileMaker in 1988, Mark began using AppleScript and FileMaker for information management and process automation tasks. In 1994, he founded Write Track Media, a computer consultancy firm that develops custom database and workflow automation solutions. With an unwavering commitment to freeing human focus from repetitive tasks, Mark designs time-saving systems that allow his clients to pursue higher levels of productivity. Among his many accomplishments, Mark is recognized for writing AppleScript: Developer Reference (2010, Wiley) and the widely acclaimed Learn FileMaker Pro series (2017, 2021, 2024, Apress).

Inhalt

Part 1 - Using FileMaker.- Chapter 1 Introducing FileMaker.- Chapter 2 Launching the Application.- Chapter 3 Exploring a Database Window.- Chapter 4 Working with Records.- Chapter 5 Transferring Data.- Part 2 Defining Database Structure.- Chapter 6 Creating a Database File.- Chapter 7 Building Tables.- Chapter 8 Defining Fields.- Chapter 9 Forming Relationships.- Chapter 10 Managing Containers.- Chapter 11 Defining Value Lists.- Part 3: Writing Formulas and Using Functions.- Chapter 12 Writing Formulas.- Chapter 13 Exploring Built-in Functions .- Chapter 14 Using JSON.- Chapter 15 Creating Custom Functions.- Chapter 16 Introducing ExecuteSQL- Part 4 Designing User Interfaces.- Chapter 17 Introducing Layouts.- Chapter 18 Getting Started with Layouts.- Chapter 19 Surveying Layout Panes.- Chapter 20 Creating Layout Objects.- Chapter 21 Manipulating Objects.- Chapter 22 Using Themes and Styles.- Chapter 23 Customizing Menus.- Part 5 Automating with Scripts.- Chapter 24 Introduction to Scripting.- Chapter 25 Common Scripting Tasks.- Chapter 26 Debugging Scripts.- Chapter 27 Using Script Triggers.- Chapter 28 Extending Features with Plugins.- Part 6 Deploying and Maintaining Solutions.- Chapter 29 Managing Database Security.- Chapter 30 using Developer Tools.- Chapter 31 Maintaining Healthy Files.- Chapter 32 Deploying a Solution.- Chapter 33 Interfacing External Systems.- Part 7 Exploring Advanced Topics.- Chapter 34 Building a Summary Report.- Chapter 35 Keeping Object References Dynamic.- Chapter 36 Using Transactions.- Chapter 37 Using Machine Learning.- Chapter 38 Leveraging Artificial Intelligence.