Mark Conway Munro

Learn FileMaker Pro 16 (eBook, PDF)

The Comprehensive Guide to Building Custom Databases

• Format: PDF

Produktbeschreibung

Extend FileMaker's built-in functionality and totally customize your data management environment with specialized functions and menus to super-charge the results and create a truly unique and focused experience. This book includes everything a beginner needs to get started building databases with FileMaker and contains advanced tips and techniques that the most seasoned professionals will appreciate. Written by a long time FileMaker developer, this book contains material for developers of every skill level.

FileMaker Pro 16 is a powerful database development application used by millions of people in diverse industries to simplify data management tasks, leverage their business information in new ways and automate many mundane tasks. A custom solution built with FileMaker can quickly tap into a powerful set of capabilities and technologies to offer users an intuitive and pleasing environment in which to achieve new levels of efficiency and professionalism.

What You’ll learn

• Create SQL queries to build fast and efficient formulas
  
• Discover new features of version 16 such as JSON functions, Cards, Layout Object window, SortValues, UniqueValues, using variables in Data Sources
• Write calculations using built-in and creating your own custom functions
  
• Discover the importance of a good approach to interface and technical design
  
• Apply best practices for naming conventions and usage standards
Explore advanced topics about designing professional, open-ended solutions and using advanced techniques

Who This Book Is For

Casual programmers, full time consultants and IT professionals.

Produktdetails

• Verlag: Apress
• Erscheinungstermin: 6. September 2017
• Englisch
• ISBN-13: 9781484228630
• Artikelnr.: 53063362

Autorenporträt

Mark Munro is an author, software developer and entrepreneur. A 1988 introduction to FileMaker led Mark to pursue a career as a developer. Soon after, he was using AppleScript and FileMaker for information management and process automation. In 1994, Mark founded Write Track Media, a computer consultancy to develop custom database and workflow automation solutions for clients. Today, Mark continues in that mission, using AppleScript and FileMaker Pro in combination with other tools and technologies to build time-saving systems for a diverse list of clients. Armed with the conviction of the virtue of using of technology to free human focus from repetitive computer tasks so they can pursue a higher level of productivity, Mark’s passion for the work is unwavering.

Inhaltsangabe

PART 1 — Introduction.- 01 Introducing FileMaker.- 02 Exploring the Application.- 03 Exploring a Database Window.- 04 Working with Records.- 05 Transferring Data.- PART 2 — Defining Database Structure.- 06 Working with Database Files.- 07 Creating Tables.- 08 Defining Fields.- 09 Connecting Tables with Relationships.- 10 Writing Formulas.- 11 Creating Custom Functions.- 12 Using SQL Queries.- 13 Managing Containers.- 14 Managing Value Lists.- PART 3 — Using Built-in Functions.-15 Text Functions.- 16 Text Functions (JSON).- 17 Text Formatting Functions.- 18 Number Functions.-.-19 Date, Time & Timestamp Functions.- 20 Container Functions.- 21 Aggregate, Summary & Repeating Functions.- 22 Financial & Trigonometric Functions.- 23 Logical Functions.- 24 Get Functions.- 25 Design Functions.- 26 Mobile Functions.- PART 4 — Designing User Interfaces.- 27 Introducing Layout Mode.- 28 Getting Started with Layouts.- 29 Exploring Layout Palettes.- 30 Creating Layout Objects.- 31 Configuring Objects.- 32 Using Themes and Styles.- 33 Customizing the Menu Bar.- PART 5 — Automating Tasks with Scripts.- 34 Introduction to Scripting.- 35 Common Scripting Tasks.- 36 Debugging Scripts.- 37 Reacting to Script Triggers.- 38 Extending Features with Plug-ins.- PART 6 — Sharing Databases on a Network.- 39 Introducing Network Sharing.- 40 Securing Database Access.- 41 Advanced Sharing and Analysis Tools.- 42 Getting Connected.