یادگیری فایل‌میکر پرو ۱۶: راهنمای جامع برای ساخت پایگاه‌های داده سفارشی

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. Importing and Exporting Records -- Supported File Types -- Downloading Sample Data -- Importing Records -- Setting Up an Automatic Recurring Import -- Performing an Import -- Browsing the Source Records -- Selecting a Target Table -- Mapping Fields -- Setting Import Options -- Notification of Results -- Resulting Found Set -- Performing an Update Import -- Update Existing Records in Found Set -- Update Matching Records in Found Set -- Exporting Records -- Specifying Export Fields -- Selecting a Table -- Adding Fields to the Export Order -- Removing Fields to the Export Order -- Reordering Fields in the Export List -- Setting Up the Sample Export -- Output File Character Set -- Apply Current Layout's Data Formatting to Exported Data -- Group by Option -- Finishing the Export -- Exporting Field Contents -- Summary -- Part II: Defining Data Structures -- Chapter 6: Working with Database Files -- Creating a New Database File -- Configuring a Sandbox Table -- Changing the Default Table Name -- Creating Data Entry Fields -- Creating a Calculation Field -- Creating a Summary Field -- Setting Up Layouts -- Renaming the Default Layout -- Adding Fields to a Layout -- Creating a List Layout -- Database File Options -- Open Settings -- Minimum Version Allowed to Open This File -- When Opening This Field -- Icon Settings -- Spelling Settings -- Text Settings -- Text Handling -- Data Entry Handling -- Script Triggers Settings -- Maintaining Healthy Files -- Database Maintenance Functions -- Saving a Copy As -- Checking Consistency -- Recovering a File -- Advanced Recovery Options -- Avoiding Design and Training Deficiencies -- Overwriting an Existing Record -- Forgetting to Commit a Record -- Deleting Records Carelessly -- Misidentifying a Found Set -- Restraining File Size -- Inefficient Design -- Fragmentation -- Understanding File Damage -- Causing File Damage Contextual Menus for Window Components -- Contextual Menus for Calculation Formulas -- Summary -- Chapter 3: Exploring a Database Window -- Using a Starter Solution -- Listing FileMaker's Starter Solutions -- Creating a Database from a Starter Solution -- Defining the Database Window -- Identifying Window Areas -- Defining Window Modes -- Browse Mode -- Find Mode -- Preview Mode -- Layout Mode -- Defining Content Views -- Form View -- List View -- Table View -- Exploring the Window Header -- Status Toolbar (Browse Mode) -- Default Status Toolbar Items (Browse Mode) -- Record Navigation Controls -- Function Buttons -- Quick Find Search Field -- Layout Menu -- View Buttons -- Preview Button -- Formatting Bar Button -- Edit Layout Button -- Customizing the Status Toolbar (Browse Mode) -- Opening the Customization Panel -- Choosing Toolbar Button Style -- Removing Toolbar Items -- Adding Toolbar Items -- Rearranging Toolbar Items -- Restoring the Default Toolbar Set -- Formatting Bar -- Window Ruler -- Managing Multiple Windows -- Creating a New Window -- Closing a Window -- Selecting a Window from the Menu -- Hiding and Showing Windows -- Minimizing a Window -- Opening an Existing Database -- Opening a Database through the Launch Center -- Managing Favorite Databases -- Summary -- Chapter 4: Working with Records -- Entering Data -- Opening a Record -- Understanding Field Focus -- Moving to Another Field with Tab Order -- Modifying Field Contents -- Typing -- Cut, Copy, Paste, Undo, Redo -- Drag and Drop -- Insert Functions -- Mouse Clicks -- Formatting Field Contents -- Closing a Record -- Managing Records -- Creating a New Record -- Deleting a Record -- Deleting All Records -- Duplicating a Record -- Searching for Records -- Performing Fast Searches -- Searching with Quick Find -- Performing a Quick Find -- Changing the Quick Find Criteria Clearing the Quick Find Criteria -- Using the Recent Search Menu -- Searching with Find Matching -- Using Find Mode -- Identifying Find Mode -- Status Toolbar (Find Mode) -- Default Status Toolbar Items (Find Mode) -- Navigation Controls -- Function Buttons -- Saved Finds Menu -- Layout Menu -- View Buttons -- Matching Records Options -- Insert Operators Menu -- Customizing the Status Toolbar (Find Mode) -- Entering Find Criteria -- Using Search Operators -- Managing Find Requests -- Creating New Find Requests -- Deleting a Find Request -- Duplicating Find Requests -- Performing a Find -- Manipulating a Previously Executed Find -- Modifying the Last Find -- Extending the Last Find -- Constraining the Last Find -- Building Complex Finds -- Working with Saved Finds -- Saving a Find -- Naming a Saved Find -- Understanding the Criteria Selection -- Saving or Canceling the Process -- Performing a Saved Find -- Managing Saved Finds -- Managing a Find Request -- Editing a Find Request Criteria -- Working with Found Sets -- Defining a Found Set -- Changing the Records in the Found Set -- Show All Records -- Omit Record -- Omit Multiple -- Show Omitted Only -- Sorting Records in the Found Set -- Modifying Field Values for Records in the Found Set -- Replace Field Contents -- Replacing with Current Contents -- Replacing with Serial Numbers -- Replacing with Calculated Result -- Relookup Field Contents -- Find and Replace -- Spell Checking -- Check Spelling Menu -- Contextual Spelling Features -- Printing -- Page Setup -- Using Preview Mode -- Identifying Preview Mode -- Status Toolbar (Preview Mode) -- Default Status Toolbar Items (Preview Mode) -- Navigation Controls -- Function Buttons -- Layout Menu -- Exit Preview Button -- Customizing the Status Toolbar (Preview Mode) -- Print Dialog Options -- Summary -- Chapter 5: Transferring Data Avoiding File Damage -- Maintaining Hardware and Software -- Avoiding Risky Behavior -- Using a FileMaker Server -- Performing Maintenance -- Improving Development Standards -- Troubleshooting Process for Random Crashing -- Copy the File -- Locate the Damage -- Checking the Database Structure -- Checking the Record Data -- Determine the Best Course of Action -- Transferring Record Data from Recovered File to Good Structure -- Specifying File Paths -- Formatting Paths -- Path Prefixes -- Path Types -- Relative Path -- Within the Same Folder -- Both Removed by One Subfolder -- Adding Additional Subfolders -- Full Path -- Network Path (Windows Shared Directory Only) -- FileMaker Server Network Address Path -- Building Dynamic Paths -- Using Variables in Paths -- Using Functions to Generate Contextual Paths -- Excluding File Extensions -- Avoiding Obsolete Wildcards -- Summary -- Chapter 7: Working with Tables -- Modeling Tables -- Introducing the Manage Database Dialog (Tables) -- Table Properties -- Naming Tables -- Managing Tables -- Selecting Tables -- Adding Tables -- Creating a New Table -- Adding a Table from an ODBC Data Source -- Preparing a Computer for an ODBC Connection -- Installing the ODBC Manager Application -- Installing the ODBC Driver -- Configuring Driver -- Connecting a FileMaker Database to the ODBC Client Driver -- Setting Up External Data Source -- Adding to Relationship Graph -- Using an ODBC Table in FileMaker -- Getting More Information -- Duplicating an Existing Table -- Importing a Table -- Converting a Data File to Database -- Modifying a Table Name -- Deleting Tables -- Summary -- Chapter 8: Defining Fields -- Defining Field Data Types -- Entry Fields -- Text Fields -- Number Fields -- Date Fields -- Date Calculations -- Two-Digit Date Conversion -- Time Fields -- Time Calculations -- Timestamp Fields 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. 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 15 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