Cover image for Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases

Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases

Author Mark Conway Munro
Release Date: 2017/09/01
ISBN: 9781484228630
Topic:
0%
57
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

Book Description

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. 

Table of Contents

  1. Cover
  2. Frontmatter
  3. 1. Using FileMaker
    1. Part Frontmatter
    2. 1. Introducing FileMaker
    3. 2. Exploring the Application
    4. 3. Exploring a Database Window
    5. 4. Working with Records
    6. 5. Transferring Data
  4. 2. Defining Data Structures
    1. Part Frontmatter
    2. 6. Working with Database Files
    3. 7. Working with Tables
    4. 8. Defining Fields
    5. 9. Connecting Tables with Relationships
    6. 10. Managing Containers
    7. 11. Managing Value Lists
  5. 3. Writing Formulas and Using Functions
    1. Part Frontmatter
    2. 12. Writing Formulas
    3. 13. Text Functions
    4. 14. Text Functions (JSON)
    5. 15. Text Formatting Functions
    6. 16. Number Functions
    7. 17. Date, Time, and Timestamp Functions
    8. 18. Container Functions
    9. 19. Aggregate, Summary, and Repeating Functions
    10. 20. Financial and Trigonometric Functions
    11. 21. Logical Functions
    12. 22. Get Functions
    13. 23. Design Functions
    14. 24. Mobile Functions
    15. 25. Creating Custom Functions
    16. 26. Introducing ExecuteSQL
  6. 4. Designing Interfaces
    1. Part Frontmatter
    2. 27. Introducing Layout Mode
    3. 28. Getting Started with Layouts
    4. 29. Exploring Layout Palettes
    5. 30. Creating Layout Objects
    6. 31. Manipulating Objects
    7. 32. Using Themes and Styles
    8. 33. Customizing Menus
  7. 5. Automating Tasks with Scripts
    1. Part Frontmatter
    2. 34. Introduction to Scripting
    3. 35. Common Scripting Tasks
    4. 36. Debugging Scripts
    5. 37. Using Script Triggers
    6. 38. Extending Features with Plugins
  8. 6. Sharing and Networking
    1. Part Frontmatter
    2. 39. Introducing Network Sharing
    3. 40. Securing Database Access
    4. 41. Advanced Sharing and Analysis Tools
    5. 42. Getting Connected
  9. Backmatter
18.118.193.232